Exploring, modeling, predicting and reporting with SAS Visual Analytics and SAS Visual Statistics

Ordering bars in a bar chart

Accepted Solution Solved
Reply
New Contributor
Posts: 2
Accepted Solution

Ordering bars in a bar chart

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?

 


Accepted Solutions
Solution
‎07-28-2016 07:12 PM
SAS Super FREQ
Posts: 381

Re: Ordering bars in a bar chart

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.

 sorting.jpg

View solution in original post


All Replies
SAS Super FREQ
Posts: 381

Re: Ordering bars in a bar chart

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?

New Contributor
Posts: 2

Re: Ordering bars in a bar chart

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!

Attachment
Solution
‎07-28-2016 07:12 PM
SAS Super FREQ
Posts: 381

Re: Ordering bars in a bar chart

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.

 sorting.jpg

Contributor
Posts: 55

Re: Ordering bars in a bar chart

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.

 

Sort Option On Category value.jpg 

 

Regards,

Kaushal Solanki

Post a Question
Discussion Stats
  • 4 replies
  • 278 views
  • 1 like
  • 3 in conversation