BookmarkSubscribeRSS Feed
🔒 This topic is solved and locked. Need further help from the community? Please sign in and ask a new question.
Thanuja
Obsidian | Level 7

Hi,

 

I am in the process of designing a bar chart to show 60 ranks(category) on X-axis and their probabilities(Measure) on Y-axis. When I view the report in report viewer, I noticed that the X-axis is cluttered as it has 60 values to be displayed. Is there any way I can limit the number of values displayed on the X-axis as 1,5,10,15,...60 without affecting the 60 ranks in the chart.So, I want 60 bars with their respective probabilities in the viz, but I want X-axis values to be 1,5,10...60 so the viz looks clean. Current view and expected look as shown in attached.

 

Thanks in advance,

Thanuja

1 ACCEPTED SOLUTION

Accepted Solutions
PetriRoine
Pyrite | Level 9

Hello @Thanuja ,

 

I suggest you try a Needle Plot and adjust Line thickness  (from Options > Needle Plot) to somewhere between 3 and 6 to get a preferred look. You could also do this with Vector Plot, but this is a more straightforward approach.

Comm_Capture.PNG

I hope this helps.

 

Best regards,

Petri

 

 

 

 

 

View solution in original post

4 REPLIES 4
Sam_SAS
SAS Super FREQ
Hello Thanuja,

Because the variable on the category axis is a character variable, the chart cannot thin the axis tick values in the way you want.

Depending on the version of VA that you have, if you view the options for the bar chart, you might see a Tick Values option under an X Axis Options grouping. If you uncheck that box, then all of the axis tick values will be hidden. Having no tick values at all might be preferable, depending on what you are looking for.

Depending on how your data is structured, you might be able to display this data as a scatter plot if you convert the category to a measure. This would look cleaner but obviously would be a lot different from a bar chart.

Sam
Thanuja
Obsidian | Level 7
Hi Sam,

Thanks for the response, I use SAS VA 7.4 and didn't see the tick values option in the properties for bar chart.

-Thanuja
Sam_SAS
SAS Super FREQ

Yes, the axis options were added later. Oh, well.

PetriRoine
Pyrite | Level 9

Hello @Thanuja ,

 

I suggest you try a Needle Plot and adjust Line thickness  (from Options > Needle Plot) to somewhere between 3 and 6 to get a preferred look. You could also do this with Vector Plot, but this is a more straightforward approach.

Comm_Capture.PNG

I hope this helps.

 

Best regards,

Petri

 

 

 

 

 

SAS INNOVATE 2024

Innovate_SAS_Blue.png

Registration is open! SAS is returning to Vegas for an AI and analytics experience like no other! Whether you're an executive, manager, end user or SAS partner, SAS Innovate is designed for everyone on your team. Register for just $495 by 12/31/2023.

If you are interested in speaking, there is still time to submit a session idea. More details are posted on the website. 

Register now!

Tips for filtering data sources in SAS Visual Analytics

See how to use one filter for multiple data sources by mapping your data from SAS’ Alexandria McCall.

Find more tutorials on the SAS Users YouTube channel.

Discussion stats
  • 4 replies
  • 885 views
  • 0 likes
  • 3 in conversation