Problem with x-axis scatter plot graph

[fnoogernooger]

I'm using Excel 2007. I'm trying to get the x-axis to go with my data that I've selected (ex. (-3σ)-(-2.01σ)) but when it transitions to the graph, it changes (ex. 1). Help?

 

[Latha]

Hi,

try the below :

Right click on the bars (chart bars) > select Format Data Series > Switch on to "Fill" > Check "Invert if negative" option.

Regards,
Latha