inconsistent order of dates on pivot axis

K

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
help?

Thanks
kas
 
J

Jan Karel Pieterse

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
Click to expand...

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
 
K

kas

You're a star. Thank you.

Jan Karel Pieterse said:
Hi Kas,


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
Click to expand...
 
Top