I have a bar chart based on a query that is working correctly. In my example the bar has 3 columns. I then want a scatter chart to display over the bar. The query for the scatter chart gets only one value but when I run it it displays values on all 3 bars. I have no idea what I'm doing wrong.
<cfchart format="flash" chartheight="300" title="Team Scores - Most Recent Routine Review" showborder="yes" scaleFrom = "0" gridlines="#gridlines#" scaleTo = "#scaleTo#" chartwidth="650" seriesplacement="default" labelformat="number" tipstyle="mouseOver" xaxistype="scale"> <cfchartseries type="bar" seriescolor="0053A6" serieslabel="Team" query="qryKPIResults" itemcolumn="TotalVariance" valuecolumn="cnt"> </cfchartseries> <cfchartseries type="scatter" seriescolor="red" serieslabel="Team Leader"> <cfchartdata item="#trim(BossKPI)#" value=1> </cfchartseries> </cfchart> ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:356136 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
