Microsoft Office Tutorials and References
In Depth Information
Adjust the Date Formats
You have several options for your date formats. Which option you
choose depends on how small you want your chart to be and which
date format your audience prefers.
In most cases, however, you’ll give
yourself more power and flexibility if
you maintain two sets of dates, one
to provide the date values and the other to provide the date labels.
To illustrate, this figure shows the top of a chart’s data range.
Column B provides the date values, and column C provides the
labels for presentation in the chart.
AB
C
D
Sales
1
2
3
1/1/04 Jan￿04
$
2,878.00
2/1/04 Feb￿04
$
3,835.00
You have at least three options for how you format the date labels
in column C. Each choice displays the date in two rows.
If your mini-chart is small, but not
tiny, you might have room to
display a three-character month
in the X axis, as shown here. In
this case, you would enter this
formula in the cell shown below,
and then copy the formula down
the column as needed.
Sales
$10,000.00
$8,000.00
$6,000.00
$4,000.00
$2,000.00
$-
Jan
04
Apr
04
Jul
04
Oct
04
Jan
05
C2:
=TEXT($B2,"mmm")&CHAR(13)&TEXT($B2,"yy")
Here, the first TEXT function returns a month label like “Jan” or
“Oct”. The CHAR(13) function returns the carriage-return character,
which causes the remaining text to wrap to a second line in the
chart. And the second TEXT function displays the year, using two
characters.
Search JabSto ::




Custom Search