Displaying and positioning axis labels
Axes labels are generated automatically from the column labels in a data series. You can display or hide axes labels on a chart that has an x-axis and a y-axis, and you can specify the labels’ positions. If the labels on an x-axis overlap, you can place them on multiple rows, or you can skip certain labels to make the information easier to read.
To display axis labels |  |
|
1.
|
|
Click a chart.
|
|
2.
|
|
Click Chart
 Axes, and click an axis. |
|
3.
|
|
Click the Labels tab.
|
|
4.
|
|
Enable the Display labels check box.
|
|
•
|
|
You can alternate between axes by choosing them from the list box under the preview window.
|
To hide axis labels | |
|
1.
|
|
Click a chart.
|
|
2.
|
|
Click Chart
Axes, and click an axis. |
|
3.
|
|
Click the Labels tab.
|
|
4.
|
|
Disable the Display labels check box.
|
|
•
|
|
You can alternate between axes by choosing them from the list box under the preview window.
|
To specify the position of x-axis labels | |
|
1.
|
|
Click a chart.
|
|
2.
|
|
Click Chart
Axes X-axis. |
|
3.
|
|
Click the Labels tab.
|
|
4.
|
|
Enable one of the following options:
|
|
•
|
Axis labels on bottom
|
|
•
|
Axis labels on top
|
|
•
|
Axis labels on both sides
|
|
If you want to position the x-axis labels in reverse order, enable the Draw as descending axis check box.
|
To specify the position of y-axis labels | |
|
1.
|
|
Click a chart.
|
|
2.
|
|
Click Chart
Axes, and click a y-axis. |
|
3.
|
|
Click the Labels tab.
|
|
4.
|
|
Enable one of the following options:
|
|
•
|
Axis labels on the right
|
|
•
|
Axis labels on the left
|
|
•
|
Axis labels on both sides
|
|
If you want to position the y-axis labels in descending order, enable the Draw as descending axis check box.
|
To position x-axis labels on multiple rows | |
|
1.
|
|
Click a chart.
|
|
2.
|
|
Click Chart
Axes X-axis. |
|
3.
|
|
Click the Labels tab.
|
|
4.
|
|
Type a number in the Display on box.
|
To skip x-axis labels | |
|
1.
|
|
Click a chart.
|
|
2.
|
|
Click Chart
Axes X-axis. |
|
3.
|
|
Click the Labels tab.
|
|
4.
|
|
Type the number of labels to skip in the Skip box.
|
|
•
|
|
You can also skip labels by enabling the Automatically skip labels check box.
|