Microsoft Office Tutorials and References
In Depth Information
If you need additional horizontal
space, your can replace the text
for each month with its number.
Doing so displays the date as
illustrated here.
Sales
$10,000.00
$8,000.00
$6,000.00
$4,000.00
$2,000.00
$-
1
04
3
04
5
04
7
04
9
04
11
04
1
05
To create this effect, use a
formula like this:
C2:
=TEXT($B2,"m")&CHAR(13)&TEXT($B2,"yy")
Your third choice is a variation
that you can apply to either of the
earlier choices. As shown here, it
leaves the X-axis less cluttered
than otherwise.
Sales
$10,000.00
$8,000.00
$6,000.00
$4,000.00
$2,000.00
$-
Jan
04
Apr
Jul
Oct
Jan
05
To use this approach, leave the
first and last date formulas as
they were, but change the other
formulas to either of these
options:
Sales
$10,000.00
$8,000.00
$6,000.00
$4,000.00
$2,000.00
$-
C3:
=TEXT($B3,"mmm")
1
04
3579 11
05
C3:
=TEXT($B3,"m")
Adjust the tick-mark label frequency
As you can see from the two figures above, Excel still is
automatically setting the tick-mark label frequency. In the of these,
Excel displays a label every three months, and in the second, every
two months.
To specify the number of months between labels, select the X-axis
and choose Format, Selected Axis. In the Scale tab of the Format
Axis dialog, enter the value you want in the text box that is labeled
“Number of categories between tick-mark labels.”
Search JabSto ::




Custom Search