Hi all,
Usually I know how to produce multiple scatters on the same graph - I would simply have three columns, named, say X, A and B. Then I will get two scatters on the same graph - A against X, and B against X.
However, what I have now is a situation where I need to plot four scatters on the same graph, and each of them has their OWN distinct values for X. I can't use X as a 'common' column for each scatter...
Help!
Anthony
can you provide a data sample? You can upload a file by clicking "Go Advanced" below and then the paper clip icon.I can't use X as a 'common' column for each scatter...
teylyn
Microsoft MVP - Excel
At Excelforum, you can say "Thank you!" by clicking theicon below the post.
Avoid pie charts with more than two data points. Why? See here (pdf, 559 kb). The only acceptable pie chart is here.
Hiya,
OK, I've attached the data to this message as an excel file. Hope you can help! It should be pretty obvious what I'm trying to do from the arrangement.
Anthony
Like this maybe?
Look at the individual series source data for the x and y values
teylyn
Microsoft MVP - Excel
At Excelforum, you can say "Thank you!" by clicking the
Yes! That's exactly what I want!
But I don't know how to do that!
PLEASE TELL!
THANKYOU!
Anthony
Sure.PLEASE TELL!
Start out with the first data set and create a XY scatter chart. I assume that's not a problem.
Then, select the chart and on the Chart Tools ribbon click "Select Data"
Click "Add" to bring up the "edit series" dialog, where you see three fields.
Click in the first one (Series Name), then click in your spreadsheet to select the cell with the series name.
Click in the second one (Series X values), then click in your spreadsheet to select the range for the X values for your new series.
Click in the third one (Series Y values), delete the "={1}" and then click in your spreadsheet to select the range for the Y values for your new series.
Click OK
rinse and repeat for the other series.
FWIW, in Excel 2003 you'd click the Chart menu, then Series data, then the Series tab to find the Add button and the fields mentioned above.
hth
teylyn
Microsoft MVP - Excel
At Excelforum, you can say "Thank you!" by clicking the
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Reply With Quote
Bookmarks