Forum Discussion

tuncay's avatar
tuncay
Helper III
6 months ago

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

  • 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.

    • tuncay's avatar
      tuncay
      Helper III

      yes, you're right. It's due to the negative value, but how can I solve that?

      • JamieHolding's avatar
        JamieHolding
        Resolver 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.

  • 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.

  • 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.