Microsoft Office Tutorials and References
In Depth Information
readers to know which label aligns with which point on the chart’s
To correct these problems, select the chart’s X axis then choose
Format, Selected Axis. In the Scale tab of the Format Axis dialog
de-select the check-box “Value (Y) axis crosses between dates”.
This change will anchor the chart line on the left and right axes, as
shown in the previous figure.
Return X-axis labels to their vertical orientation
When you make a chart small, Excel
displays the labels at an angle, as shown in
These angled labels are difficult to read
and take up too much space. We therefore
need to return them to a vertical orientation.
To correct the orientation, select the X axis
in the chart. Choose Format, Selected Axis.
Choose the Alignment tab of the Format
Axis dialog. The Automatic radio button will
be selected. To de-select it, click the up arrow in the Degrees scroll
bar, and then click the down arrow. After you do so, the Degrees
will be set to zero, but the automatic radio button will be
After you make this change, the
chart will look worse, as shown
here. But that’s okay. We’ll fix it
in the next step.