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, 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 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 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 …

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, 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 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.

After you create a chart, you can change the data series in two ways: Use the Select Data Source dialog box to edit the data in your series or rearrange them on your chart.