Customizing the Axes in a Chart

Chart axes are lines that border the chart area and provide a reference for measurements. They act as a vehicle for tick marks and scales and form a frame around the chart. The Y-axis is usually the vertical axis and contains data. The X-axis is usually the horizontal axis and contains categories.

To make your chart data easier to understand, you can do the following to customize each axis:

customize the title for the axis
show or hide the axis labels (data values)
show or hide the axis line
change the color, style, and weight of the axis line
show or hide major and minor tick marks and specify where to display them

Procedure

Select the axis chart object.
To show or hide the axis labels, in the Properties pane, select or clear the Axis label check box.
To show or hide axis lines, in the Properties pane, click Axis lines, and select or clear the Axis line check box.
To change the color, style, and weight of the axis line, in the Properties pane, click Axis lines.
To show or hide minor and major tick marks and specify their location, in the Properties pane, click Axis lines.