By default, Excel determines the minimum and maximum scale values of the vertical (value) axis, also known as the y axis, when you create a chart. However, you can customize the scale to …

To change the interval between axis labels, under Interval between labels, click Specify interval unit, and then in the text box, type the number that you want.

To change the interval between axis labels, expand Labels, and then under Interval between labels, select Specify interval unit and type the number you want in the text box.

To change the format of numbers on the value axis: Right-click the value axis labels you want to format. Click Format Axis. In the Format Axis pane, click Number. Tip: If you don't see the …

When you create a chart from worksheet data that uses dates, and the dates are plotted along the horizontal (category) axis in the chart, Excel automatically changes the category axis to a date …

To change the interval between axis labels, expand Labels, and then under Interval between labels, select Specify interval unit and type the number you want in the text box.

Right-click the value axis labels you want to format, and then select Format Axis. Tip: If you don't see the Number section in the pane, make sure you've selected a value axis (it's usually the …

To change the interval between axis labels, under Interval between labels, click Specify interval unit, and then in the text box, type the number that you want.

If a chart that you create does not display the worksheet data on the axis that you want, you can quickly change the way that data is plotted.

Depending on the data that sparklines are based on, changing the axes can refine their scale and accuracy and make comparisons easier. Horizontal axis ... Vertical axis You can set minimum …