Microsoft Office Tutorials and References
In Depth Information
You have a lot of flexibility with this setting, because a label can
overlap the area available to other labels.
To illustrate, this figure shows
that the complete “January”
label extends into the space
where the February and March
labels would go. If you set the
number of tick marks between
labels at 1, the labels would
overlap, making the X-axis
labels illegible.
Sales
Sales
Sales
$10,000.00
$10,000.00
$10,000.00
$8,000.00
$8,000.00
$8,000.00
$6,000.00
$6,000.00
$6,000.00
$4,000.00
$4,000.00
$4,000.00
$2,000.00
$2,000.00
$2,000.00
$-
$-
$-
January
04
Jan
04
Jan
04
Apr
Apr
Ma y
Jul
Jul
Se p
Oct
Oct
Jan
05
Jan
05
Ja n
05
An Aside: How Not to Display Two Rows of X-Axis Labels
Some Excel references suggest
a different way to display two
rows of labels for the X axis.
Sales
10
6
Instead of wrapping one column
of labels in your spreadsheet,
these sources say, you should
set up two columns of labels in
your spreadsheet, and display them both in your chart.
2
JanFebMarAprMaJunJulAu SeOctNoDeJan
04 04 04 04 04 04 04 04 04 04 04 04 05
As this figure illustrates, this suggestion creates several problems.
The worst of these is that this method inserts a double-space
between the rows of labels, forcing the axis to take up more vertical
height that we want.
Second, this method imposes three changes to the chart’s formats:
Tick marks turn into vertical borders.
Labels must be associated with each period. You no longer can
display labels every two or three periods.
Search JabSto ::




Custom Search