Adding 2 graphs side by side

%3CLINGO-SUB%20id%3D%22lingo-sub-3241128%22%20slang%3D%22en-US%22%3EAdding%202%20graphs%20side%20by%20side%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-3241128%22%20slang%3D%22en-US%22%3E%3CP%3EHi%2C%20I%20was%20just%20wondering%20if%20there%20would%20be%20a%20way%20to%20jointly%20add%202%20excel%20graphs%20side%20by%20side%2C%20with%20the%20same%20scale%20on%20the%20y-axis%20but%20different%20names%20on%20the%20x-axis%3F%26nbsp%3B%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20image-alt%3D%22Nhat_Nguyen_2-1646227994987.png%22%20style%3D%22width%3A%20400px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F352366iA1556D7328A6A331%2Fimage-size%2Fmedium%3Fv%3Dv2%26amp%3Bpx%3D400%22%20role%3D%22button%22%20title%3D%22Nhat_Nguyen_2-1646227994987.png%22%20alt%3D%22Nhat_Nguyen_2-1646227994987.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20image-alt%3D%22Nhat_Nguyen_3-1646228002443.png%22%20style%3D%22width%3A%20400px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F352367i8C1C78CF03CDED14%2Fimage-size%2Fmedium%3Fv%3Dv2%26amp%3Bpx%3D400%22%20role%3D%22button%22%20title%3D%22Nhat_Nguyen_3-1646228002443.png%22%20alt%3D%22Nhat_Nguyen_3-1646228002443.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%3CP%3ESay%2C%20I%20want%20to%20add%20these%202%20together%2C%20but%20side%20by%20side%2C%20so%20the%20y-axis%20still%20ranges%20from%203%20to%203.5%20(adjustable)%2C%20and%20the%20x-axis%20would%20need%20to%20show%20Qual%201%2C%20then%20Qual%202%2C%20without%20showing%20those%20number%201%20to%2030%20(the%20amount%20of%20samples%20for%20each%20qualification).%20The%20legends%20should%20still%20be%20the%20same.%20I%20tried%20messing%20around%20with%20chart%20but%20to%20no%20avail.%20Any%20help%20would%20be%20appreciated.%20Thanks%20in%20advance!%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-3241128%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-3241366%22%20slang%3D%22en-US%22%3ERe%3A%20Adding%202%20graphs%20side%20by%20side%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-3241366%22%20slang%3D%22en-US%22%3Eadd%20the%20second%20graph%20to%20the%20same%20data%20set%20and%20label%20it%20different.%20when%20data%20changes%2C%20both%20graphs%20changed%3C%2FLINGO-BODY%3E
New Contributor

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? 

Nhat_Nguyen_2-1646227994987.png

Nhat_Nguyen_3-1646228002443.png

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!

 

 

 

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