SAS VA Dual axis bar and line chart overlay

[prsr]

Hi there,

Pls assist.

I am trying to achieve dual axis bar and line chart in SAS VA.

AS IS: My graph looks as below - 

TO BE: I am trying to overlay the above with a line based on the count. Something like below - 

Thanks in advance

RP

[BrunoMueller]

This is possible using the SAS Graph Builder.

In the SAS Graph Builder you will find a "template" called "Dual Axis Bar-Line Chart"

Use it as starter, add the group role to the the bar chart

The default for group display is cluster, as you need it.

Save the graph template, you will be asked to remove the data driven lattice roles.

In a SAS Visual Analytics report import the graph template

You are now ready to use the graph template like any other object

[prsr]

Hi Bruno, Thanks for your reply. I really appreciate your time. 

I tried the way you mentioned, Is there a way to -

1) apply data labels for the bars and line

2) apply group scale to "Normalize groups to 100%"

Thanks,

RP

[BrunoMueller]

I see. These options are not currently available for custom graphs, but can be set while building the custom graph.

Here are the basic steps:

• create a new custom graph using the "New Custom Graph" button
• From the elements on the left add bar chart
• Go to the options of the bar chart on the right, set grouping scale and data label as shown
  
• Add the group role to the bar chart as shown before
• Add a line graph on top of the bar chart
• Set options of the line chart accordingly (choose right Y axis for the line chart)
  
• Maybe rename the "shared" role to category
• Check what you would like to have in the legend
  

Proceed as mentioned before (save custom graph, import it, use it).

It will look like this:

If you need to make changes to the custom graph. Delete it from the object window. Make the changes. Import it again. Build new report object.