• Home
  • About

Entries RSS | Comments RSS
  • Beginning PivotTables in Excel 2007 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.

  • Categories

  • Archives

  • Recent Posts

    • Create Single Click Desktop Icons
    • Open a Second Window in Outlook 2007
    • Excel Twitters 20090103
    • Excel Twitters 2008127
    • Have an Excellent Christmas!
  • Pages

    • About
  • Subscribe in a reader

Formatting Pivot Chart Dates

Posted on August 11th, 2008 by Debra Dalgleish

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:

  1. Right-click a date in the pivot table (not the pivot chart).
  2. Click on Field Settings
  3. 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.

Share/Save/Bookmark

Filed under: Charts, Excel, Pivot Chart, Pivot Table

« Excel Twitters 20080810 Send Google Search Results to Your Newsreader »

One Response to “Formatting Pivot Chart Dates”


  1. Pingback from Excel Links of Week - Who is Obama edition? [Aug 12] | Pointy Haired Dilbert - Chandoo.org
    Time: August 12, 2008, 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. [...]

Leave a Reply

  • Subscribe

    Subscribe in a reader
  • Email Updates

    Subscribe by Email
  • Calendar

    August 2008
    S M T W T F S
    « Jul   Sep »
     12
    3456789
    10111213141516
    17181920212223
    24252627282930
    31  
  • Contextures

    • Contextures Excel Pages
    • My Video Tutorials
  • Excel

    • Daily Dose of Excel
    • Excel Team Blog
    • Jan Karel Pieterse
    • JP’s Excel/Outlook
    • PTS Blog
    • Spreadsheet Page Blog
    • TVMCalcs Excel Blog
  • General

    • Hodge Blog
    • J-Walk Blog
    • SuiteMinute