Hi all,
As example:
I would like to chart the values of A B C D E on a clustered bar chart by region.
But I would like to combine the bars of B and C to a stacked bar chart, with the different variables still visible.
This is an easy task in other BI tools I've worked with but I can't seem to figure it out in VA 7.4.
Should your chart look like this?
If yes, then you can use the Custom Graph Builder, add two bar charts on top of each other change the group style of the second chart to stack, edit the measure for the two bar charts to allow for multiple data assignments. You also want to adjust discrete offset and maybe bar spacing.
Give it a go.
Should your chart look like this?
If yes, then you can use the Custom Graph Builder, add two bar charts on top of each other change the group style of the second chart to stack, edit the measure for the two bar charts to allow for multiple data assignments. You also want to adjust discrete offset and maybe bar spacing.
Give it a go.
Thanks for your assistance!
This was indeed what I was looking for.
I'm looking to build the same *except* I need both bars to be stacked. -- I'm working in ver. 7.4 and it doesn't seem to be possible... Anyone have any ideas for me??? Thanks in advance!!
As mentioned you can use the Custom Graph Builder to define your own graph type, this will allow to do what you want.
But it also depends on how your data is structured.
So providing sample data and a mockup of your graph would help.
Thank you so much for your reply! -- Yes, I'm using the custom graph builder to drag in two bar graphs and setting them both to stacked vertical.
Ultimately, I wish to make a visualization that depicts the grocery expenditures by department by month YOY of two persons on the same graph (hence the two stacked bar charts).
So, we can look at the visualization and say person A spent more $s in the Dairy dept than person B in the month of June '18.
Cannot figure out how to do this. Thanks in advance for your assistance,'
Ben
Hello elkinsbe, Believe the previous reply was correct. You can use custom graph builder to achieve the desired results. Adjust the settings of Bar Chart 1 and Bar Chart 2 separately, remove a Discrete Legend, and add a Group Shared Role to the bar charts.
Robert T: Thank you so much for your response. Yes, now as your explanation was so clear and included exact instructions I understand how to make this informative double stacked bar chart...further, after re-reading I see the previous response provided a path forward.
Cheers to you for a detailed explanation.
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!
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.