Stacked CF Chart Addition Issues
I think this is a bug, but I thought I'd put it out here and see if anyone has any suggestions before I go off reporting this to Adobe.
I have the below chart set up, and instead of putting the lower/first value in an item in front, it adds the two items together (w + w or y + y), which I guess might be expected. I really don't use Excel much, so I'm not sure what's typical. Anyway, if I have a client that sells $40 in tshirts and $60 in pants the bar will go up to $100, which is fine, because they sold $100 in inventory. Now I'm trying to add a line chartseries to show something else month to month. I wanted the datapoints at the positions you see below, however since this all is adding up, I thought I would set the item value to desired_value-total_item_values. So if I wanted the line at month 1 to be 37 I would set the value to -63 (37 - 100 = -63). However, when I do this my line marker is at 153 and the y axis now goes down to -53.
Does anyone have an idea of how I could get the line to show up at 37?
Thanks!
<cfchart seriesplacement="stacked" format="jpg">
<cfchartseries type="bar" seriescolor="003366">
<cfchartdata item="w" value="40">
</cfchartseries>
<cfchartseries type="bar" seriescolor="9966FF">
<cfchartdata item="w" value="60">
</cfchartseries>
<cfchartseries type="bar" seriescolor="003366">
<cfchartdata item="x" value="52">
</cfchartseries>
<cfchartseries type="bar" seriescolor="9966FF">
<cfchartdata item="x" value="78">
</cfchartseries>
<cfchartseries type="bar" seriescolor="0000FF">
<cfchartdata item="y" value="60">
</cfchartseries>
<cfchartseries type="bar" seriescolor="FFFF99">
<cfchartdata item="y" value="70">
</cfchartseries>
<cfchartseries type="line" seriescolor="000000" markerstyle="triangle">
<cfchartdata item="w" value="-63">
<cfchartdata item="x" value="-30">
<cfchartdata item="y" value="-52">
</cfchartseries>
</cfchart>