Drawing > Creating charts and pictographs > Displaying axis values |
![]() ![]() ![]() |
Displaying axis values
You can display values along the axes of a chart to control how the numerical data is presented. If an axis has no numerical values, the options in the Chart Type dialog box are dimmed. The axis value options are not available for a Pie chart.
To display axis values:
1 |
Select the chart and double-click the Chart tool. |
2 |
In the Chart Type dialog box, click the X Axis or Y Axis button to display the Axis Options dialog box. |
3 |
Choose an Axis values option: |
![]() |
Select Calculate from Data to calculate axis values from the data entered in the worksheet. |
![]() |
Select Manual to enter your own Minimum, Maximum, and Between values. The Between value determines how many steps will be displayed between each whole number. For example, if the axis values range from 1 to 10, a between value of 1 will display 1, 2, 3, and so on. A Between value of 2 will display 2, 4, 6, and so on. |
To have the axis start with a high number and end with a lower number, enter a negative number in the Between box. |
|
4 |
Choose Tick Marks options. Major tick marks correspond to numbers or category labels on the axis. They can be displayed across, inside, or outside the axis. |
Minor tick marks are evenly spaced between major marks. The value in the Count text box determines how many minor tick marks appear between each major mark. They can also be displayed across, inside, or outside of the axis. |
|
5 |
For Axis Value Labels, enter a prefix to add a label before a value (such as $ for $125) and suffix to add a label after a value (such as % for 5%). |
6 |
Click OK. |
7 |
Repeat the procedure to set options for the other axis. |
8 |
Click Apply to preview your changes without closing the Chart panel, or click OK to apply the changes and close the panel. |
![]() |
![]() ![]() ![]() |