Unable to merge charts in excel

%3CLINGO-SUB%20id%3D%22lingo-sub-2259389%22%20slang%3D%22en-US%22%3EUnable%20to%20merge%20charts%20in%20excel%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2259389%22%20slang%3D%22en-US%22%3EHey%20I%20need%20some%20help!!%20It's%20urgent!!%20I%20am%20new%20to%20excel%20and%20am%20having%20some%20trouble%20with%20merging%20charts.%20My%20aim%20is%20to%20plot%20a%20combined%20graph%20of%20height(y%20axis)%20vs%20distance(x%20axis)%20for%20No%20drag%3A%20Launch%20velocity%2020m%2Fs%20for%20angle%20varying%3CBR%20%2F%3Efrom%2020%20degrees%20to%2080%20degrees%20in%20step%20of%205%20degrees.%20I%20have%20all%20the%20values%20of%20x%20and%20y%20corresponding%20to%20each%20angle%20of%20projection(%20such%20as%2020%2C%2025%2C%2030%20till%2080).%20My%20individual%20charts%20for%20each%20angle%20are%20coming%20out%20to%20be%20in%20parabolic%20shape%20which%20is%20correct.%20The%20problem%20arises%20when%20i%20try%20to%20combine%20them.%20Since%20I%20am%20new%20to%20excel%2C%20I%20only%20know%20one%20way%20of%20merging%20scatter%20charts%20that%20is%20ctrl%2Bc%20and%20ctrl%2Bv.%20But%20it%20turns%20out%20that%20values%20on%20x%20axis%20keep%20decreasing%20instead%20of%20keeping%20fixed%20and%20my%20overall%20graph%20keeps%20going%20forward%20instead%20of%20coming%20back%20but%20it%20shouldn't%20happen%20because%20when%20angle%20of%20protection%20increases%20beyond%2045%20range%20starts%20decreasing.%20I%20have%20attached%20below%20my%20graph%20and%20the%20desired%20one.%20Can%20somebody%20help%20me%20out%3F%20Many%20thanks.%3C%2FLINGO-BODY%3E
Occasional Visitor
Hey I need some help!! It's urgent!! I am new to excel and am having some trouble with merging charts. My aim is to plot a combined graph of height(y axis) vs distance(x axis) for No drag: Launch velocity 20m/s for angle varying
from 20 degrees to 80 degrees in step of 5 degrees. I have all the values of x and y corresponding to each angle of projection( such as 20, 25, 30 till 80). My individual charts for each angle are coming out to be in parabolic shape which is correct. The problem arises when i try to combine them. Since I am new to excel, I only know one way of merging scatter charts that is ctrl+c and ctrl+v. But it turns out that values on x axis keep decreasing instead of keeping fixed and my overall graph keeps going forward instead of coming back but it shouldn't happen because when angle of protection increases beyond 45 range starts decreasing. I have attached below my graph and the desired one. Can somebody help me out? Many thanks.
0 Replies