The Scale tab provides different options for a category (x) axis. Important The following scaling options are only available when a value (y) axis is selected.
Note The Selected Axis command is only available when a chart axis is selected.
You can, however, customize the scale to better meet your needs. By default, Microsoft Excel determines the minimum and maximum scale values of the value (y) axis in a chart.