Microsoft Office Tutorials and References
In Depth Information
readers to know which label aligns with which point on the chart’s
line.
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
previous figures.
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
deselected.
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.
Sales
$10,000.00
$8,000.00
$6,000.00
$4,000.00
$2,000.00
$-
Ja
n04
Ma
r04
Ma
y04
J
ul04
Se
p04
No
v04
Ja
n05
Search JabSto ::




Custom Search