cfquery "qryAnswer" returns three columns (QYesCount, QnoCount, and QNACount). What I am trying to do is drawing a bar chart with the itemcolumn "QNo" (=Question Numbers) against the three columns. What do you put more than one column onto valuecolumn in cfchartseries? Is there any other way to get around this?
<cfchart xaxistitle="Question 3, 5, 7, 14, 14a, 15" yaxistitle="Count of Yes/No/NA" scaleFrom="0" gridlines="5" rotated="no" SHOWXGRIDLINES="yes" SHOWYGRIDLINES="yes" CHARTWIDTH="900" CHARTHEIGHT="400" SHOWBORDER="no"> <cfchartseries type="bar" query="qryAnswer" itemcolumn="QNo" valuecolumn="QYesCount" paintStyle="raise"> </cfchart> Tia, Daniel ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:200094 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=11502.10531.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54