wrong order in displaying horizontal axix in pivot chart

[pierre86]

Hello,

I created a pivot chart, in the filter and the chart itself, I have week 1 to week 52 when the chart is created, I get on the horizontal axis (written vertically here for convinience)
week 1
week 10
week 11
...
week 19
week 20
...
week 20
week 3
week 30
....
end with
week 6
week 7
week 8
week 9

How can I fix?

Pierre

 

[dave3009]

Right click axis>>Format Axis>>Categories in reverse order.

HTH

Dave

 

[sergioMabres]

Hi Pierre,
I think you should make labels look like Week 01 instead of Week 1, here is a workbook that shows you how to do that
https://dl.dropboxusercontent.com/u/23094164/Pierre01.xlsx

 

[dave3009]

Sorry I completely misread that.

 

[pierre86]

Thank you, still a problem, 2 issues, I get week 10, week 11, .... week 52, then at the end week 01, week 02....week 09 his there formating to do on this column?

Worse, now i closed my excel file with the pivot table and chart, when I created it, it seemed to have created another workbook, but now I can't find it. Does excel save it somewhere special?

Pierre

I have win 7 with excel 2007

 

[pierre86]

redid my table from scratch, everything ok now.

 

[sergioMabres]

Good!
I am glad we could help
Regards
Sergio