topic SAS Visual Analytics Dual axis Bar Chart with Trend Line in SAS Visual Analytics

SAS Visual Analytics Dual axis Bar Chart with Trend Line

srinivaschary — Mon, 13 Mar 2017 10:16:54 GMT

Could you please help me quickly while am building dual axis bar chart...trend line showing at bottom, not trend pls help

Data

Product	GRO-Prem	SA	%
A	2056	100000	4%
B	7950	100000	16%
C	4450	100000	9%
D	8525	50000	17%
E	8849	100000	18%

in SAS:

Expected:

Srinivas

Re: SAS Visual Analytics Dual axis Bar Chart with Trend Line

Lodewijk — Mon, 13 Mar 2017 14:47:22 GMT

You have to make sure that GRO-prem and SA both share the left-hand y-axis, and the %-age measure needs to use the right-hand y-axis. Right now GRO-prem and SA define the axes, and that pushes the percentage line to the bottom.

Re: SAS Visual Analytics Dual axis Bar Chart with Trend Line

srinivaschary — Mon, 13 Mar 2017 16:14:20 GMT

Thanks for reply, Am trying to the same way but % should come line chart. Gro-Pre and SA should come bar charts,

Thanks,
Srinivas

Re: SAS Visual Analytics Dual axis Bar Chart with Trend Line

ShivamKS — Mon, 13 Mar 2017 17:11:28 GMT

In your custom bar line chart, change the axis of the line chart to Right Y-axis and ensure to edit the role of the bar chart to have "Allow multilple Data assignement" selected.

Line Chart: On Properties Tab of custom chart

Bar Chart: On Roles Tab of Custom Chart

The final assignement of roles on the custom chart:

Will give you the required result: