topic Re: Ordering bars in a bar chart in SAS Visual Analytics

Ordering bars in a bar chart

CJAY — Mon, 25 Jul 2016 23:22:58 GMT

Hi there

Brand new user here. I am trying to change the order of bars in a bar chart. Currently it is sorting by highest count but I want it to sort by year (on the category/x axis). The year is coming from a hieararchy date data item – when I right click on it there is no option to sort. Any ideas?

Re: Ordering bars in a bar chart

Madelyn_SAS — Wed, 27 Jul 2016 23:39:01 GMT

You should be able to left (not right) click on the name of the hierarchy and see a menu with a Sort option. If you do not see it, can you send a screen shot of what you do see?

Re: Ordering bars in a bar chart

CJAY — Thu, 28 Jul 2016 00:54:33 GMT

Hi, when I'm left clicked on the data item, I see a properties box however I am unable to change any of the values in it except for the name. I've attached a screenshot. Thanks for your help!

Re: Ordering bars in a bar chart

kaushalsolanki — Thu, 28 Jul 2016 11:28:23 GMT

Hello Cjay,

After assigning roles in bar chart just go to category value and right click it, It will show you sorting option as you required.

Regards,

Kaushal Solanki

Re: Ordering bars in a bar chart

Madelyn_SAS — Thu, 28 Jul 2016 13:29:00 GMT

At the bottom of the bar chart, hover over the Commencement Date Hierarchy until it turns blue. Then, click on it to see the menu with sorting. If right-click does not work, then try left-click.