will introduce you to the exciting new pivot table features in Excel 2007. Create quick summaries and pivot charts, add impact with traffic light icons, design calculated fields, group dates and numbers.
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.
August 12th, 2008 at 7:02 am
[...] Formatting dates in pivot chart, of course if you try the usual route of “format axis > number format” and set it to show the date nov-10 instead of 11/10/2008, it wouldnt work. You have to use the technique highlighted at the contextures blog. [...]