CFChart Creates Phantom Data. Need tips on how to fix.
I'm running this code in Coldfusion 8 Standard and it creates 3 phantom bars for Employee hours when no data is present.
Any ideas on how to fix this?
<cfchart format="flash" xaxistitle="Date" yaxistitle="Total Hours" chartwidth="600" chartheight="400">
<cfchartseries type="bar" itemcolumn="ENDINGDATE"
valuecolumn="TOTALHOURS" seriescolor="##009900" serieslabel="Contractor Hours" >
<cfchartdata item="09/29/2007 " value="21">
<cfchartdata item="10/13/2007" value="20">
<cfchartdata item="10/27/2007 " value="20">
<cfchartdata item="11/24/2007 " value="7">
<cfchartdata item="01/19/2008 " value="1">
</cfchartseries>
<cfchartseries type="bar" itemcolumn="ENDINGDATEFAA"
valuecolumn="TOTALHOURSFAA" seriescolor="##0000CC" serieslabel="Employee Hours" >
<cfchartdata item="09/29/2007 " value="5">
<cfchartdata item="10/13/2007 " value="6">
</cfchartseries>
</cfchart>
Message was edited by: ColdFusionUsers2 .didn't include all the code