Vertical Axis of Graph, Format Axis to whole number, automatic

[jpsimmon]

I am trying to figure out if I can have a specific axis option (vertical axis) where my major unit is a whole number, so 1.0 but I still want it to Auto in case a large number comes in where it has to skip numbers to increase.

I hope this makes sense.

Thanks all!

 

[istiasztalos]

Hi,

You can change the format of the axis values in the chart settings, the path to the settings would be different based on your version of Excel, but either way you have to go to "Format Axis" settings and look for "Number" tab. Here you can change to whatever format you need, it will not affect the scaling. ()