Microsoft Office Tutorials and References
In Depth Information
Formatting Date Labels
You’ll create a custom format for the category axis that displays only the four-digit year.
To create a custom format for the four-digit year:
1. Click Number on the left side of the Format Axis dialog box.
2. Type yyyy in the Format Code box, which is the code for displaying only years.
See Figure 4-22.
Figure 4-22
Custom date format
built -in date
custom format
to display the
four-digit year
3. Click the Add button. The four-digit year format code is added to the list of
custom formats and is selected.
4. Click the Close button. The Format Axis dialog box closes, and the category axis
labels show values for every other year on the major tick marks. See Figure 4-23.
Search JabSto ::

Custom Search