Sort order for a bar chart

User avatar
StuartR
Administrator
Posts: 12577
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: 78236
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.
Best wishes,
Hans

User avatar
StuartR
Administrator
Posts: 12577
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