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, the axis is not correct. Even though the data matches and its same the visual shows it as it would be less..
Hope you can help
5 Replies
- JamieHoldingResolver I
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.- tuncayHelper III
yes, you're right. It's due to the negative value, but how can I solve that?
- JamieHoldingResolver I
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.
- V-yubandi-msftCommunity Support
Hi tuncay ,
If you get a chance, please review the responses shared by JamieHolding. They have correctly pointed out the key points, so kindly check and let us know if you need any additional details.
Thank you all for your valuable support JamieHolding .
Regards,
Yugandhar.
- V-yubandi-msftCommunity Support
Hi tuncay ,
We haven’t received a response from your end yet. Please let us know whether the issue has been resolved or if you’re still facing any difficulties. Feel free to reach out if you need further assistance.
Thank you.