Microsoft Office Tutorials and References
In Depth Information
Formatting Date Labels
To format the category axis labels:
1. Double-click the category axis to open the Format Axis dialog box with the Axis
2. Next to Major unit, click the Fixed option button, type in the box, and then 2
select Years in the list. The major tick marks are set to every two years.
3. Next to Minor unit, click the Fixed option button, type in the box, if necessary, 1
and then select Years in the list. The minor tick marks are set to every year. See
Date intervals for tick marks
set the major tick marks
at two-year i ntervals
set the minor tick marks
at one-year intervals
Next, you’ll format the category labels to show the four-digit year value rather than
the complete date. Excel does not have a built-in format to display only four-digit year
values, but you can create a custom format to accomplish this.
Custom date formats use combinations of the letters “m”, “d”, and “y” for months,
days, and years, respectively. The number of letters controls how Excel displays the date,
• With months, m or mm displays the one- or two-digit month number, mmm displays
the month’s three-letter abbreviation, and mmmm displays the month’s full name.
• With days, d or dd displays the one- or two-digit day value and dddd displays the day’s
• With years, yyyy displays the four-digit year value.
For example, a custom format of mmm-dd displays a three-letter month abbreviation
followed by a hyphen and a two-digit day number (such as Apr-05). The current date
format used in the category axis is yyyy , which—for example—displays March 14, d/
2013 as 3/14/2013.