Each stacked bar does not sum correctly, not considering negative values.

[wonka1234240]

Hi,

I have this in my stacked bar - 

this is my data -

segment	quarter	millions_try
jeans	Q1/24	1,154,000,000.00
tshirt	Q1/24	1,353,000,000.00
jacket	Q1/24	650,000,000.00
socks	Q1/24	664,000,000.00
underwear	Q1/24	220,000,000.00
ties	Q1/24	(459,000,000.00)

which sums to 

         3,582,000,000.00

however my stacked bar looks as if it is 4,000,000,000, when it should be around the 3,500,000,00. 

Seems like the bar isnt taking into account the negative values when summing the x-axis.

Anything I can do here?

[Anonymous · Accepted solution]

Hi,

Thanks for the solution Sahir_Maharaj  offered, and i want to offer some more information for user to refer to.

hello @wonka1234240 , after testing, the calculation is right, you can open the total label, then set the display units to none

The total is right

If you want to look close to that value visually, you can adjust the maximum range of the x-axis, for example, 3.6bn.

Output

Best Regards!

Yolo Zhu

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[Sahir_Maharaj]

Hello @wonka1234240,

Your stacked bar chart is incorrectly ignoring negative values, leading to a total that appears larger than it should be.

The best way to properly show positive and negative contributions is to use a Waterfall Chart, which correctly visualizes increases and decreases.