Exploring, predicting and reporting with SAS Visual Analytics and SAS Visual Statistics

SAS Visual Analytics Dual axis Bar Chart with Trend Line

Accepted Solution Solved
Reply
Occasional Contributor
Posts: 13
Accepted Solution

SAS Visual Analytics Dual axis Bar Chart with Trend Line

Hi

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

 

Data 

ProductGRO-PremSA%
A20561000004%
B795010000016%
C44501000009%
D85255000017%
E884910000018%

 

in SAS:

In SAS.PNG

Expected:

 

Expected result.png

 

 

Srinivas


Accepted Solutions
Solution
‎03-14-2017 12:50 AM
Occasional Contributor
Posts: 14

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

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

 

Line Chart mod.PNG 

 

Bar Chart: On Roles Tab of Custom Chart

 

bar chart mod 1.PNGbar chart mod 2.PNG

 

The final assignement of roles on the custom chart:

 

final roles.PNG

 

Will give you the required result:

 

Final chart.PNG

View solution in original post


All Replies
Occasional Contributor
Posts: 16

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

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.

Occasional Contributor
Posts: 13

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

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

 

 

Thanks,
Srinivas

Solution
‎03-14-2017 12:50 AM
Occasional Contributor
Posts: 14

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

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

 

Line Chart mod.PNG 

 

Bar Chart: On Roles Tab of Custom Chart

 

bar chart mod 1.PNGbar chart mod 2.PNG

 

The final assignement of roles on the custom chart:

 

final roles.PNG

 

Will give you the required result:

 

Final chart.PNG

☑ This topic is solved.

Need further help from the community? Please ask a new question.

Discussion stats
  • 3 replies
  • 563 views
  • 0 likes
  • 3 in conversation