Excel Graph

[Kate London]

my data series for a graph is listed 1, 2, 3, 4 but when I creat the graph the bars are in the order 4, 3, 2, 1
How do i change this?

 

[dave3009]

Hi Kate

Welcome to MrExcel

In the chart options there is an option to plot in reverse order.

KR


Dave

 

[Kate London]

Hi - thanks for the prompt reply. Think i must be going blind but where is chart options????

 

[dave3009]

Right click the axis and choose format chat axis, then you will see categories in reverse order.

 

[Kate London]

Thank you very very much!!!