BookmarkSubscribeRSS Feed
Albert0
Quartz | Level 8

Hi All,

 

I'm replicating an excel chart in SAS VA 7.1 using a Bar Line Chart Custom Category. I have attached the screenshot of the report.

 

 

The report requires 1 variable for Category role, 1 variable for Group role and 1 variable for Lattice column role then 2 Measure for the bar and line.

 

But in Custom Category it only accepts a Lattice column role or a Group role. You cannot add both roles.Can anyone suggest another alternative to this so that I could show the same report in the attached screenshot? 

 

I'm using 1 Bar Chart then 1 Line Chart on the Custom Graph.

 

Thanks.

-Albert0

 

image004.jpg

3 REPLIES 3
FredrikE
Rhodochrosite | Level 12

Hi!

First of all, I think that you should redesign that graph from the start, I think it is hard to see the different values along the bars. They all have the same colour and the grouping is not that easy to see. I would have split it into separate graphs instead.

 

Anyhow, I gave it a try and it may give you some ideas 🙂 ?

It does not look exactly as yours thou....:)

 

barchart_line_multiple.png

Albert0
Quartz | Level 8
Hi Fredrike,


Thanks for trying...Yeah it doesn't look the same you can't also add a Group role into it right?

-Albert0
FredrikE
Rhodochrosite | Level 12

No, I think you are right, I forgot that one...:)

//Fredrik

SAS Innovate 2025: Call for Content

Are you ready for the spotlight? We're accepting content ideas for SAS Innovate 2025 to be held May 6-9 in Orlando, FL. The call is open until September 25. Read more here about why you should contribute and what is in it for you!

Submit your idea!

Tips for filtering data sources in SAS Visual Analytics

See how to use one filter for multiple data sources by mapping your data from SAS’ Alexandria McCall.

Find more tutorials on the SAS Users YouTube channel.

Discussion stats
  • 3 replies
  • 1596 views
  • 0 likes
  • 2 in conversation