# Auto y-scale not working correctly?

#### JohanS

##### New Member
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.

Hope this helps.

Steve=True

Replies
2
Views
628
Replies
4
Views
843
Replies
4
Views
3K
Replies
7
Views
2K
Replies
2
Views
3K

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.

### Which adblocker are you using?

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

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