Chart Properties dialog box – Axis tab
Chart Properties shortcut menu > Chart – Axis tab
Lets you edit the properties of the current chart’s axes. Select an axis in the list box on the left side of the dialog box, then edit its properties as described below.
Title
Enter or edit the name of the selected axis. This will appear below or beside the selected axis in the chart.
Scale type
Specify the scale type of the selected axis. The available choices are Linear, Logarithmic (Base 2), and Logarithmic (Base 10). The scale type can only be specified when you selected Y-axis (primary or alternate).
Use exponential number format
If this check box is selected, the number 1000000 or more is presented in the exponential number format.
Configure data range automatically
If this check box is selected, the range of the selected Y-axis (primary or alternate) is configured automatically to fit the values in the chart. Deselect this check box if you want to configure the range manually.
The range can be configured manually using the settings described below:
Min. value
Enter the minimum value for the range. The range will start at this value.
Max. value
Enter the maximum value for the range. The range will end at this value.
Major scale
Enter the distance between major gridlines for the selected axis, in terms of the units of the axis.
Minor scale
Enter the number of divisions between major gridlines. Minor gridlines will be drawn at each division.
Related topics
Chart Properties dialog box – Chart Type tab
Chart Properties dialog box – Title tab
Chart Properties dialog box – Series tab
Chart Properties dialog box – Values tab
Chart Properties dialog box – Trendlines tab
Chart Properties dialog box – Chart Formatting tab