Chart data

[nikwak1]

I have data for a chart where it works on 'weeks out' going from week 20 (this week) to week 1 (target week). I have set the data up in this way but the chart shows it back to front - in other words it goes from week 1 to week 20 instead of the other way around. I have attached 2 screenshots to show what I mean. How do I change that?

 

[Jon Peltier]

You can reverse the order of the axis. Double click on the axis, and in the Format Axis Task Pane, under Axis Options, (1) select Categories in Reverse Order, and (2) select Vertical Axis Crosses At Maximum Category.

 

[nikwak1]

You can reverse the order of the axis. Double click on the axis, and in the Format Axis Task Pane, under Axis Options, (1) select Categories in Reverse Order, and (2) select Vertical Axis Crosses At Maximum Category.

View attachment 100747

Unfortunately that reverses everything. I want it to be the same as the Data sheet. Reversing simply reverses the whole data sheet. So I need week 20 to show the data at week 20 not at week 1

 

[Jon Peltier]

Oh, then maybe you're not using the Wk column as the X values of the chart.