- Mark as New
- Bookmark
- Subscribe
- Mute
- RSS Feed
- Permalink
- Report Inappropriate Content
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.
- Mark as New
- Bookmark
- Subscribe
- Mute
- RSS Feed
- Permalink
- Report Inappropriate Content
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.
- Mark as New
- Bookmark
- Subscribe
- Mute
- RSS Feed
- Permalink
- Report Inappropriate Content
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.
- Mark as New
- Bookmark
- Subscribe
- Mute
- RSS Feed
- Permalink
- Report Inappropriate Content
you can manually set maximum and minimum values for y axis using properties menu (7.4). it can achieve what you want.
- Mark as New
- Bookmark
- Subscribe
- Mute
- RSS Feed
- Permalink
- Report Inappropriate Content
Hi @ASHISH2525
Setting the maximum and minimum only does that. It doesn't set how the value labels appear:
- Mark as New
- Bookmark
- Subscribe
- Mute
- RSS Feed
- Permalink
- Report Inappropriate Content
what version of VA are you using ?
- Mark as New
- Bookmark
- Subscribe
- Mute
- RSS Feed
- Permalink
- Report Inappropriate Content
I'm using SAS 9.4 M5, VA 7.4.
- Mark as New
- Bookmark
- Subscribe
- Mute
- RSS Feed
- Permalink
- Report Inappropriate Content
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.