topic Axis multipliers in VA report line charts in SAS Visual Analytics

Axis multipliers in VA report line charts

Nigel_Pain — Fri, 26 Apr 2019 13:22:25 GMT

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.

Re: Axis multipliers in VA report line charts

utrocketeng — Mon, 06 May 2019 18:33:25 GMT

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.

Re: Axis multipliers in VA report line charts

Nigel_Pain — Tue, 07 May 2019 08:39:49 GMT

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.

Re: Axis multipliers in VA report line charts

ASHISH2525 — Tue, 07 May 2019 10:45:49 GMT

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

Re: Axis multipliers in VA report line charts

Nigel_Pain — Tue, 07 May 2019 11:43:03 GMT

Hi @ASHISH2525

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

Re: Axis multipliers in VA report line charts

ASHISH2525 — Tue, 07 May 2019 11:52:23 GMT

what version of VA are you using ?

Re: Axis multipliers in VA report line charts

Nigel_Pain — Tue, 07 May 2019 13:01:38 GMT

I'm using SAS 9.4 M5, VA 7.4.

Re: Axis multipliers in VA report line charts

ASHISH2525 — Wed, 08 May 2019 04:08:18 GMT

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.