Formatting Pivot Chart Dates
If you create a pivot chart in Excel, with dates along the axis, you might want to change the format of those dates. For example, if the date format is November 10, 2008, you may prefer something shorter, such as 10-Nov. However, if you try to format the dates through the Format Axis dialog box, the change won’t be successful.
The pivot chart date formats are controlled by the field format in the pivot table. To change the date format:
- Right-click a date in the pivot table (not the pivot chart).
- Click on Field Settings
- Change the Number Format to the date format that you want.
This tip, and the answers to your other burning pivot table questions, can be found on the Pivot Table FAQ page on my web site.