Could you explain a little more about what is the question you want your audience to understand by the side-by-side comparison?
Stacked bars are not very good chart option for comparisons within the bars as the segments inside the bar do not have the same baseline. So it will be important to know what kind of comparison you want to achieve in order for us to propose a way of doing it.
Thanks in advance
Thanks for responding Rodrigo.
Basically just put those two plots on the same graph.
If you feel like the Stacked Bars isn't a correct comparison for this type of analysis, then feel free to improvise.
Also I understand that the baselines aren't the same. That's why I came to this Community Thread for advise and help.
I still don't know what is the question you want to answer with the data. Plotting the data is not a question to be answered.
Please create a multi-plot using these data:
1. COUNT(Business Activity)
2. WARDS - Filtered by ( Top 5 COUNT(CASE#))
3. WARDS - Filtered by ( Bottom 5 COUNT(CASE#))
I'm having issues creating a graph that contain all three variables.
I was only able to create separate plots on different worksheets.
However I need to somehow put these plots on the same worksheets.
So I guess I'm asking for you to create a "Multi-Plot".
Rodrigo, if you having issues creating a multi-plot because the baseline isn't the same, then maybe this problem isn't for you.
I'm pretty sure there's a visualization out there that exist that allow you to capture those two graphs even though there baselines are different.
Once again, I'm open to any multi plot visualization, besides the side-by-side graph.