I have two tables, each with non-adjacent x and y data columns. I would like to plot both series on one plot as separate series. I have read the pdf help file, and searched through past discussions here. Non of the tips in those locations work.
Any thoughts?
Thanks
Jeff
iMac, OS X Mountain Lion (10.8.2)
I tried that yesterday... but the circle doesn't move. I can't expand the region.
Please see my edited post above. I think the designers didn't test this situation out because it is strange the way it works.
Hi Jeff,
You simplest solution might be to gather the data into adjacent columns on an auxiliary table, created specifically for the purpose of feeding data to the scatter graph.
Regards,
Barry
Yep, thats what I did. It works of course, but seems like extra work that I shouldn't have to do.
Hi Jeff,
What steps do you need to take to do this in Excel?
Why, other than familiarity with those steps, would you not consider them 'extra work'?
Regards,
Barry
Thanks, you are right. I works, but doesn't help if I need to see the data in between.
BTW, it was Barry's solution (gather the data into a separate table) I was seconding.
I will also give a vote for the separate table. You can hide it away on another Sheet if you wish, or just slide it behind the primary data table.
Jerry
Add a second series to a scatter plot.
