Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Sorting rows in Pivot table
Hi,
I've a pivot table and connected chart with names of month in the rows. Default ordered by name and I'm able to manualy order them in correct order. All OK. But now my problem: The months are in a sort of floating year, from one month till the same month in the other year (ref to year is included in the name), so I have to sort one time apr '05 to mar '06 and the other time may '05 to apr '06. I've tried it with a dummy var with numbers (200504 .... 200609 ....), but then that var is visible in the chart, what I don't like. Anyone an idea? regards, Henk |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Derived Columns in Pivot Table | Excel Discussion (Misc queries) | |||
How to create a Pivot table from text file with more than 65000 rows? | Excel Discussion (Misc queries) | |||
Pivot Tables, Help? | Excel Discussion (Misc queries) | |||
Pivot Table Problems | Excel Discussion (Misc queries) | |||
Problems with sorting a pivot table | Excel Discussion (Misc queries) |