Axis multipliers in VA report line charts

[Nigel_Pain]

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.

[utrocketeng]

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.

[Nigel_Pain]

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.

[ASHISH2525]

you can manually set maximum and minimum values for y axis using properties menu (7.4). it can achieve what you want.

[Nigel_Pain]

Hi @ASHISH2525 

Setting the maximum and minimum only does that. It doesn't set how the value labels appear:

[ASHISH2525]

what version of VA are you using ?

[Nigel_Pain]

I'm using SAS 9.4 M5, VA 7.4.

[ASHISH2525]

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.