CFChart Problem
This may be a silly question, but I would like an answer!
If have a chart which shows the number of hours worked per week (see image attached). The green line is last year's data and you can ignore the red line. Our year starts in week 14 and so there is only one line returned by the query for this year so far showing 6315 hours (the orange line). My code is below.
My question is, why do I have an orange line that stays at the same level for the whole year as the current week. (Should it not have the rest of the year showing at the bottom of the graph (point 0))?
If have a chart which shows the number of hours worked per week (see image attached). The green line is last year's data and you can ignore the red line. Our year starts in week 14 and so there is only one line returned by the query for this year so far showing 6315 hours (the orange line). My code is below.
My question is, why do I have an orange line that stays at the same level for the whole year as the current week. (Should it not have the rest of the year showing at the bottom of the graph (point 0))?
<cfchart format = "flash" chartHeight = "500" chartWidth = "1000" showXGridlines = "yes" showYGridlines = "yes" showLegend="no" yAxisTitle = "Hours" sortXAxis = "no" showmarkers="no">
<cfchartseries query="QoQ_Qty" type="line" itemColumn="WkNo" valueColumn="TotQty" serieslabel="">
</cfchartseries>
<cfchartseries query="QoQ_Qty#MYear#" type="line" itemColumn="WkNo" valueColumn="TotQty" serieslabel="">
</cfchartseries>
<cfchartseries type="line" seriescolor="red">
<cfchartdata value=8000>
</cfchartseries>
</cfchart>
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER