SAS Visual Analytics Dual axis Bar Chart with Trend Line

[srinivaschary]

Hi

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

[Lodewijk]

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.

[srinivaschary]

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

Thanks,
Srinivas

[ShivamKS · Accepted solution]

Hi

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: