Sort order for a bar chart

User avatar
StuartR
Administrator
Posts: 11044
Joined: 16 Jan 2010, 15:49
Location: London, Europe

Sort order for a bar chart

Post by StuartR »

Is there an easy way to get this bar chart to be sorted in the same order as the data on the spreadsheet, with the first topic on top?
Clustered bar chart.png
You do not have the required permissions to view the files attached to this post.
StuartR


User avatar
HansV
Administrator
Posts: 69393
Joined: 16 Jan 2010, 00:14
Status: Microsoft MVP
Location: Wageningen, The Netherlands

Re: Sort order for a bar chart

Post by HansV »

Double-click on any of the category axis labels.
Tick the check box 'Categories in reverse order'.

S0004.png
You do not have the required permissions to view the files attached to this post.
Regards,
Hans

User avatar
StuartR
Administrator
Posts: 11044
Joined: 16 Jan 2010, 15:49
Location: London, Europe

Re: Sort order for a bar chart

Post by StuartR »

That was simple. Thank you.
StuartR