Excel plotting Positive number as negative?

[mayur553]

Hello experts... I am trying to plot a stacked bar graph with 2 series.

Series 1 is positive number
Series 2 is a negative number but am using ABS to convert it to positive number

When i plot the stacked bar graph, Somehow series 2 is still plotted as a negative series

Does anyone knows what am doing wrong.

 

[PCL]

Double check the data for serie 2
If you change the data for serie by the one used for serie 1 what's up

 

[mayur553]

I have named range my series so that i have a dynamic range. So my worksheet shows a positive number on screen as i have used ABS but for some reason graph still plots it as a negative number.

I am facing the same issue for other series where i am converting the numbers from negative to positive using ABS. Excel always plots them as negative