Jade has attended:
Excel Advanced course
Month order column headings in pivot tables
I have set up a pivot table which has the year and month along the top (column heading) and a list of countries along the rows. The issue I have is the order of the year and month in the column heading. As my data starts from April 2011, that is the first month that appears right through to Dec 2011 and that is in month order. However, when I entered data for April 2012 (in my source data and I had no issues when I entered data for Jan, Feb and Mar 2012), I noticed that April would appear to be the first month in 2012 followed by Jan, Feb and March 2012. Hence, the months are not in order.
How can I reorder the months in 2012 so that they are in month order when I refresh my pivot table?
Thanks,
Jade Hodgson
RE: Month order column headings in pivot tables
Hi Jade, thanks for your query. Two things might help here. The first is to click the Options drop down on the Options tab in the Pivot Table Tools group. Then click Options again and choose the Display tab. Then tick "Display item labels when no fields are in the values area".
Secondly, sort the pivot headings using the built in month lists. Click into one of the months and choose Sort from the Options tab. Then choose the More Options button and take the tick off Sort automatically. Then choose one of the options from the First key sort order drop down. This should reorder the headings, as long as there aren't any other factors influencing them.
Hope this helps,
Anthony
