Forum Discussion
Nhat_Nguyen
Mar 02, 2022Copper Contributor
Adding 2 graphs side by side
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!
- Qaiser_jBrass Contributor
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
- cris_22Brass Contributoradd the second graph to the same data set and label it different. when data changes, both graphs changed