I've created a VA report with a line chart, which is looking quite nice. However, the range of the Y values is into the millions and the value labels are displayed as single digits with "(Millions)" appended to the overall axis label. I can't find a way to alter or turn this off. I'm already using the comma format for the Y values, so the values should be easy enough to read without a multiplier.
Many thanks.
perhaps, create a new column for your continuous variable that is divided by 1,000,000. Name it something like X_Million. then plot that new value. i feel that would remove the '000,000' from the axis.
Hi @utrocketeng
Thanks, but what I want to do is the reverse. VA is currently applying the million multiplier so that the value labels appear as 1, 2, 3, etc. and the axis label has "(millions)" appended to it. I want the value labels to appear as 1,000,000, 2,000,000, 3,000,000, etc. without the addition to the axis label.
you can manually set maximum and minimum values for y axis using properties menu (7.4). it can achieve what you want.
Hi @ASHISH2525
Setting the maximum and minimum only does that. It doesn't set how the value labels appear:
what version of VA are you using ?
I'm using SAS 9.4 M5, VA 7.4.
For removing millions you can simply unchecked the show label box for Y Axis in properties. it will not display your label it self. i hope it will work for you.
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.
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.