Scatter chart using data from 2 workbooks

[ja2austintx]

I'm sure this has been answered, but I couldn't find it with multiple searches. I have two sets of data (temperature VS time) in two separate workbooks. Each data set comprises 200 points, but the time measurements (independent variable) are slightly different between the two data sets. As an example:

1 0 sec 32 deg
2 1 sec 33 deg
.
.
.
200 200 sec 48 deg


and

1 0 sec 40 deg
2 0.9 sec 43 deg
.
.
.
200 202 sec 54 deg


How do I combine both sets of measurements on a single scatter chart? Most tutorials I see on the web are for simpler examples with common independent variables, usually involving pie charts. I'm not making the leap. Thanks in advance for any help.

 

[thisoldman]

The first workbook's data set goes to approximately 900 seconds:
[TABLE="width: 128"]
<tbody>[TR]
[TD="class: xl63, width: 64"]seconds[/TD]
[TD="class: xl63, width: 64"]°C[/TD]
[/TR]
[TR]
[TD="class: xl63, align: right"]0[/TD]
[TD="class: xl63, align: right"]25[/TD]
[/TR]
[TR]
[TD="class: xl63, align: right"]4[/TD]
[TD="class: xl63, align: right"]31.1[/TD]
[/TR]
[TR]
[TD="class: xl63, align: right"]6[/TD]
[TD="class: xl63, align: right"]36[/TD]
[/TR]
[TR]
[TD="class: xl63, align: right"]8[/TD]
[TD="class: xl63, align: right"]38.3[/TD]
[/TR]
[TR]
[TD="class: xl63, align: right"]10[/TD]
[TD="class: xl63, align: right"]39.6[/TD]
[/TR]
</tbody>[/TABLE]

The second workbook's data set, again extends to roughly 900 seconds.
[TABLE="width: 128"]
<tbody>[TR]
[TD="class: xl63, width: 64"]seconds[/TD]
[TD="class: xl63, width: 64"]°C[/TD]
[/TR]
[TR]
[TD="class: xl63, align: right"]0[/TD]
[TD="class: xl63, align: right"]386.7[/TD]
[/TR]
[TR]
[TD="class: xl63, align: right"]15[/TD]
[TD="class: xl63, align: right"]396.1[/TD]
[/TR]
[TR]
[TD="class: xl63, align: right"]30[/TD]
[TD="class: xl63, align: right"]399[/TD]
[/TR]
[TR]
[TD="class: xl63, align: right"]45[/TD]
[TD="class: xl63, align: right"]400.2[/TD]
[/TR]
[TR]
[TD="class: xl63, align: right"]60[/TD]
[TD="class: xl63, align: right"]400.8
[/TD]
[/TR]
</tbody>[/TABLE]

• Make an embedded scatter chart of the first data set as you would normally.
• Go to the second workbook, select all cells of the second data set and copy with Ctrl+c.
• Go back to the chart. Make sure the chart is selected. On the home tab, beneath the large Paste icon is a small downward pointing arrow. Click that arrow and select "Paste Special..."
• In the Paste Special dialog box that pops up, select:
  • Add cells as New Series
  • Values (Y) in Columns
  • Series Names in First Row
  • Categories (X Values) in First Column

 

[ja2austintx]

Whoa, thanks! Much obliged.

 

[thisoldman]

You're welcome. I'm glad to have helped.