MrExcel Publishing
Your One Stop for Excel Tips & Solutions

combining two charts in Excel


Posted by Ravi on December 06, 2001 1:01 PM

Hi I have two different data ranges and I want to combine the two different charts that I get onto one.
Ex:
X Y X1 Y1
10 1 1 10
20 2 2 20
30 3 3 30
40 4 4 40
50 5 5 50
60 6 6 60
70 7 7 70

I have two charts, onw with x,y and the other with x1,y1, I want to combine these two onto one. Is this possible, Any help would be greatly apppreciately.

Thanks
Robert.


Posted by Mark W. on December 06, 2001 1:15 PM

Use an XY (Scatter) Chart type.