Hi,
I have a CFCHART problem. I am just trying to populate an Agri-Bar type chart from my database. I have 4 queries to populate my cfchartseries and my queries get 5 col from database. <cfchart style="mytype.xml" format="png" scaleFrom="-1" scaleTo="1" chartWidth="600" chartHeight="300" name="mygraph"> <cfchartseries seriescolor="ff9900" type="horizontalbar" query="myquery1" serieslabel="mylabel" valueColumn="myvalues" itemColumn="mychoices" /> <cfchartseries seriescolor="cc0000" type="horizontalbar" query="myquery2" serieslabel="mylabel" valueColumn="myvalues" itemColumn="mychoices" /> <cfchartseries seriescolor="99ffcc" type="horizontalbar" query="myquery3" serieslabel="mylabel" valueColumn="myvalues" itemColumn="mychoices" /> <cfchartseries seriescolor="009900" type="horizontalbar" query="myquery4" serieslabel="mylabel" valueColumn="myvalues" itemColumn="mychoices" /> </cfchart> I have a graph like following. I can get my values from database but what about X-Axis labels (1-5)? How can I populate these labels from my database? When I use "myvalues" field from my queries, I have just 4 query but 5 X-Axis. :-( Any idea? TIA! Sincerely, Oðuz Demirkapý ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:237141 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
