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

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

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

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