Forum Discussion
Line and Stacked Column Chart: Line does not show correct
Hello, I have created a line and stacked column chart that shows some figures. In addition it should show the "Total" of these figures as a line (black line) → Controllable Factory Costs. However, t...
If you have negative segments of a stacked column chart, then a line for the total will not equal the top of the column chart since
Top of column chart = sum of all positive segments
Line chart = sum of all positive and negative segments, so is lower
Let me know if this is what's happening.
yes, you're right. It's due to the negative value, but how can I solve that?
Technically it's working as intended, the line IS the total, and the stacked values are greater than the total due to the negative segments.
I don't think this is broken, it just needs to make the negative values and x-axis more clear so someone can easily see that coloured area within the stacked bar chart doesn't necessarily mean value - it can be negative.
