Webmaster Forum / ColdFusion / Getting Started / July 2006

Without knowing what your ultimate goal is, its hard to point you in the right
direction. For all intents and purposes, you do not need to use webchart. For
simplicity sake, take a look at <cfchart> and <cfchartseries>, that should do
anything you want it to do.

My Goal: is for the user to click, enter a contract number, query for the
contract number and have the chart appear showing bid amounts and goal amounts.
That's it, seems pretty simple to me, but I can't get it to work with
cfchart..... Can't get the second series in. I have successfully created the
chart in WEBCHART (with static data), I need to  get dynamic data from query.  
Thanks trainmom

http://www.macromedia.com/devnet/mx/coldfusion/articles/basic_chart.html

This should help.

HOW DO I GET from CFCHART to XML or  XML back to CFCHART?????
HOW DO I populate the Webchart?
HELP!!!!!

this is what I have in  testchart.cfm

<cfquery datasource="bid"  name="bidamount">
select name,amount,goal
from table
where id = #form.id#
</cfquery>

<cfchart style
  style="myxmlstyle.xml"   >

<cfchartseries  type="bar"
query="bid"
itemcolumn="name"
vaulecolumn="amount"
/>

--------
the xml file is:

<?xml version="1.0" encoding="UTF-8"?>
 <frameChart is3D=\"false\">
 <frame xDepth=\"12\" yDepth=\"11\"/>
  <yAxis scaleMin=\"0\" scaleMax=\"450\">
  <labelFormat style=\"Pattern\" pattern=\"\"/>
 
  </yAxis> <yAxis2 scaleMin=\"1\" scaleMax=\"100\">
  <logStyle type=\"ExcludeMinor\"/>
  </yAxis2>
 
   <dataLabels style=\"Pattern\" background=\"yellow\" foreground=\"blue\"
isMultiline=\"true\">
   <decoration foreColor=\"green\"/>
   <![CDATA[ \n ]]>
   </dataLabels>
   
   <legend isVisible=\"false\"/>
    <elements drawShadow=\"true\">
    <morph morph=\"Grow\" stage=\"Cols\"/>
   
    <series index=\"0\" place=\"Default\" shape=\"Line\" isSecondAxis=\"true\">
    <paint color=\"yellow\"/>
    <dataLabel>
    <![CDATA[ \n$(value) ]]>
    </dataLabel>
    </series>
   
     <series index=\"1\">
      <marker type=\"None\" bitmap=\"\"/>
      <paint color=\"red\"/>
     </series>
     
     <series index=\"2\">
       <marker type=\"None\"/>
       <paint color=\"blue\"/>
      </series>
     
       <series index=\"3\" shape=\"Line\">
         <paint color=\"green\"/>
         <dataLabel>
         <![CDATA[ $(value) ]]>
         </dataLabel>
         </series>
         
         </elements>
         <table isVisible=\"true\">
         <format style=\"Pattern\" pattern=\"\"/>
         </table>
         <title>MY New Chart </title>
         <paint isVertical=\"true\" min=\"47\" max=\"83\"/>
          </frameChart>"