| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
inconsistent order of dates on pivot axis
I have a pivot chart where one of the axes is year and week no eg 200833
which is an output from a database query. Unfortunately, the pivot displays these periods in the wrong order - 200829,200830,200833,200831,200832 - and I can't figure out how to get them in the correct order. Please can someone help? Thanks kas |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
inconsistent order of dates on pivot axis
Hi Kas,
I have a pivot chart where one of the axes is year and week no eg 200833 which is an output from a database query. Unfortunately, the pivot displays these periods in the wrong order - 200829,200830,200833,200831,200832 - and I can't figure out how to get them in the correct order. Please can someone If you go to the pivot table on which the chart is based, you can rightclick the field in question and select Field properties. Then click the "Advanced" button and set the proper sorting options there. Regards, Jan Karel Pieterse Excel MVP http://www.jkp-ads.com Member of: Professional Office Developer Association www.proofficedev.com |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
inconsistent order of dates on pivot axis
You're a star. Thank you.
"Jan Karel Pieterse" wrote: Hi Kas, I have a pivot chart where one of the axes is year and week no eg 200833 which is an output from a database query. Unfortunately, the pivot displays these periods in the wrong order - 200829,200830,200833,200831,200832 - and I can't figure out how to get them in the correct order. Please can someone If you go to the pivot table on which the chart is based, you can rightclick the field in question and select Field properties. Then click the "Advanced" button and set the proper sorting options there. Regards, Jan Karel Pieterse Excel MVP http://www.jkp-ads.com Member of: Professional Office Developer Association www.proofficedev.com |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
inconsistent order of dates on pivot axis
Hi Kas,
You're a star. Thank you. You're welcome and thanks for letting us know this helped! Regards, Jan Karel Pieterse Excel MVP http://www.jkp-ads.com Member of: Professional Office Developer Association www.proofficedev.com |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Order of X-axis | Charts and Charting in Excel | |||
| Auto-scaling on Y axis inconsistent | Charts and Charting in Excel | |||
| Help! ISO formula for inconsistent monthly dates | Excel Discussion (Misc queries) | |||
| Graphing inconsistent dates and data | Charts and Charting in Excel | |||
| pivot table dates are out of order how do I correct them | Excel Worksheet Functions | |||
Linear Mode
