Thread: How do I merge multiple measurements into one series in a scatterplot

Hi, I have two sets of data (the green and yellow area respectively) from multiple sources. I would like merge each set into a single series and display them in the same scatter plot. Right now if I select the green area as data I get four series instead of the merged single one I would like.

Does anyone have a suggestion as to how I could do that?

http://i56.tinypic.com/2s7e5a1.jpg

please, post a WORKBOOK. Nobody wants to type data from a picture or paste text from your post into a spreadsheet as a prelude to helping. To attach a file, push the button with the paperclip (or scroll down to the Manage Attachments button), browse to the required file, and then push the Upload button.