Forum Discussion

Nhat_Nguyen's avatar
Nhat_Nguyen
Copper Contributor
Mar 02, 2022

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_j's avatar
    Qaiser_j
    Brass 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_22's avatar
    cris_22
    Brass Contributor
    add the second graph to the same data set and label it different. when data changes, both graphs changed

Resources