Adding 2 graphs side by side

[Nhat_Nguyen]

Hi, I was just wondering if there would be a way to jointly add 2 excel graphs side by side, with the same scale on the y-axis but different names on the x-axis? 

Say, I want to add these 2 together, but side by side, so the y-axis still ranges from 3 to 3.5 (adjustable), and the x-axis would need to show Qual 1, then Qual 2, without showing those number 1 to 30 (the amount of samples for each qualification). The legends should still be the same. I tried messing around with chart but to no avail. Any help would be appreciated. Thanks in advance!

[#2]

add the second graph to the same data set and label it different. when data changes, both graphs changed

[#3]

Hi @Nhat_Nguyen 

I attached a sample image of 2 control charts in parallel hiding the y-axis of the second chart. Data refresh in the chart automatically as you change your data selection.

You can check here for Microsoft Excel & Office 365.

And if you are comfortable with Google Sheets, you can find it here.

Thanks