cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
oldhasbeen Regular Visitor
Regular Visitor

Sorting by legend on a bar chart

I've created a bar chart from some Further Education data, showing how students from 3 different subjects fare: 

 

FE8.PNG

 

Problem is that the bars are in the wrong order - I want to get them in the logical order of:

Started course
Retained after 8 weeks
Completed year 1
Completed year 2

 

The only way I can see to do this is a bodge, i.e. concatenate the stage reference with stage name - but it's ugly

 

FE901.PNG

 

The query can be found at https://1drv.ms/u/s!AmxJyApgEAcYgo8w2xQKFiMzMkt7xQ

 

Any better ideas?

 

Thanks for your help

1 ACCEPTED SOLUTION

Accepted Solutions
dedelman_clng New Contributor
New Contributor

Re: Sorting by legend on a bar chart

On the Modeling tab there is a button "Sort By Column".  Click on the Stage Name column in your Field selector, click "Sort By Column" and choose "Stage Reference".  Then when you choose to sort by Stage Name it will go ascending or descending based on S5, S6, etc.

 

Hope this helps

David

2 REPLIES 2
dedelman_clng New Contributor
New Contributor

Re: Sorting by legend on a bar chart

On the Modeling tab there is a button "Sort By Column".  Click on the Stage Name column in your Field selector, click "Sort By Column" and choose "Stage Reference".  Then when you choose to sort by Stage Name it will go ascending or descending based on S5, S6, etc.

 

Hope this helps

David

Highlighted
oldhasbeen Regular Visitor
Regular Visitor

Re: Sorting by legend on a bar chart

Fixed!

 

Thanks Dedelman