topic Re: SAS VA Dual axis bar and line chart overlay in SAS Visual Analytics

SAS VA Dual axis bar and line chart overlay

prsr — Sun, 30 Jun 2024 19:18:56 GMT

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

BrunoMueller — Thu, 04 Jul 2024 11:29:36 GMT

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 — Thu, 04 Jul 2024 20:10:00 GMT

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,

BrunoMueller — Mon, 08 Jul 2024 15:06:24 GMT

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.