Auto y-scale not working correctly?

JohanS

New Member
Joined
Jun 24, 2010
Messages
3
I have a simple line graph with two data series. The one series has a lowest value of 12,04 and a highest value of 14,05. The second series has a lowest value of 11,36 and a highest value of 12,39. If I selct Auto scaling for Y-axis the Minimum, Maximum, Major Unit and Minor Unit the minimum goes to 0 (and the Maximum to 16) whilst a more appropriate minimum would be say 10 to 11. If I use the exact same graph but now the range of values for the two series are 4,47 to 4,80 and 5,01 to 5,02 respectively, the scale minimum goes to 4,10 (and maximum to 5,10). So in this case the auto scale does not force the minimum to 0. Can anyone shed light on this problem?
 

Excel Facts

Best way to learn Power Query?
Read M is for (Data) Monkey book by Ken Puls and Miguel Escobar. It is the complete guide to Power Query.
Hello JohanS and welcome to the forums.

It is not that it is broken, but it is how it works.

If the difference is about 20% then it will narrow your axis. If the difference is larger than 20% then you will have the Zero as the minimum.

Be careful with axis not down to zero as you can skew the graph look and distort it for your viewers.

John P did a good post about this on his site: http://peltiertech.com/WordPress/

Hope this helps.

Steve=True
 
Upvote 0

Forum statistics

Threads
1,203,072
Messages
6,053,377
Members
444,659
Latest member
vuphihung

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top