How do I chart two separate sets of x and corresponding y values .

T

The Bewildered

I would like to chart two sets of x and y values with each set of x values
corresponding to its own set of dependant y values. The two sets of x values
for the ordinate are entirely different. It seems like I can only chart two
sets of data on the same graph with the same values for x and two separate
sets of dependant values for y. Is there any way possible to get around this
problem?
 
D

David Biddulph

Select your first set of X&Y data, Insert/ Chart (Chart type XY, & choose an
appropriate sub-type)/ other options as appropriate.
Now select your second set of X&Y data, Copy, select your chart, Edit/ Paste
Special/ New Series/ X values in first column, other options as applicable.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Make Y-axis values correspond to x- axis value 1
Excel 2010 - Line Chart with Mulitiple Data Sets 1
Dynamic charts with named range Windows 8.1 0
Changing the setting of X,Y axes 0
charting multiple identical x values overlapping 0
Conditional number format of x-axis based on value? 2
Getting data point from an accel chart 0
Source data - have X and Y values for 1 series 4

Top