4 Replies Latest reply on Jan 7, 2019 7:52 AM by Ghazi Muhamamd

# Need Help, creating side by side graphs of different dimensions (x-axis)

Basically got two different data source.

My y-axis data is coming from one data source and the x-axis data is coming from the other data source.

I want to create two different plots using the same the y-axis data ("Count of Business Activity").

However for the the x-axis (WARDS) will be filtered by COUNT(CASE#).

Summary:

Plot 1 : Y-axis: (Count of Business Activity)

X-Axis : WARDS - Filtered by ( Top 5 COUNT(CASE#))

Plot 2 : Y-axis: (Count of Business Activity)

X-Axis : WARDS - Filtered by ( Bottom 5 COUNT(CASE#))

Graph = Plot 1 + Plot 2

This easily accomplish on two separate worksheets (see worksheet 2 & 3). However I need this on the same worksheets.

I'm open to any other graph options, as long it's some type of side by side graph comparison.

• ###### 1. Re: Need Help, creating side by side graphs of different dimensions (x-axis)

Hi Ghazi

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.

Rodrigo

• ###### 2. Re: Need Help, creating side by side graphs of different dimensions (x-axis)

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.

• ###### 3. Re: Need Help, creating side by side graphs of different dimensions (x-axis)

Hi Ghazi

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.

Rodrigo

• ###### 4. Re: Need Help, creating side by side graphs of different dimensions (x-axis)

Please create a multi-plot using these data:

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.