Line graphs from different Excel workbooks

[jimmyjazz 47137]

I hate Excel.  I have 2 separate workbooks listing measured data as a function of time for two different tests, say "temperature vs time".  The range of time for each workbook is approximately the same, but the actual points in time don't line up exactly between the two workbooks.  I want to plot both sets of data on a single graph.  So, I want to combine a graph of T1 versus t1 with a graph of T2 versus t2.

What's the easiest way to do this?

[jimmyjazz 47137]

Note that the vast majority of examples on the interwebs are for simple problems like pie charts of annual sales of apples, pears, and condoms across 2 different years.  What I am looking at is more complicated, because my independent values are not constant across the 2 sets of data.  Their SPAN is very similar, but the numerical data points are slightly different.

[Handcruser 2815]

Save and close both files.
Place them side by side on your desktop
Right click on them
Hit delete
Confirm
Go play guitar.
Profit


Sent from my iPhone using Tapatalk Pro

[jimmyjazz 47137]

That all worked except for the "profit" part.

[retread 2951]

Here's one guy's take (fyi, it uses scatter charts)

https://peltiertech.com/multiple-series-in-one-excel-chart/

Discussion on superuser.com

https://superuser.com/questions/820242/plotting-multiple-datasets-of-different-lengths-on-the-same-scatter-graph-in-exc/821151#821151

Edited May 5, 2018 by retread

[jimmyjazz 47137]

Yeah, I should have specified scatter charts, not "line graphs".  I did find that Peltier forum but not the blog, I'll check it out.  Thanks.

[CooterBrown 18287]

You could have a third workbook that reads data from the other two. Once the data is in one, make charts.

[jimmyjazz 47137]

I'm about to manually cut and paste all the different series into one spreadsheet.  This is a one time deal for a client.

[Nice Guy Eddie 13727]

30 minutes ago, jimmyjazz said:

I'm about to manually cut and paste all the different series into one spreadsheet.  This is a one time deal for a client.

Good luck,  every time I’ve done something manual, a client will want a change that seems simple, except for the whole manual part.

[jimmyjazz 47137]

Well, this is a summary of output data from a crapton of analytical work, so if he wants "more", he's going to have to pay me a lot more.  These results are what they are.

[Orca of Peace 109]

7 hours ago, jimmyjazz said:

I hate Excel.  I have 2 separate workbooks listing measured data as a function of time for two different tests, say "temperature vs time".  The range of time for each workbook is approximately the same, but the actual points in time don't line up exactly between the two workbooks.  I want to plot both sets of data on a single graph.  So, I want to combine a graph of T1 versus t1 with a graph of T2 versus t2.

What's the easiest way to do this?

can you put up screenshots?

[jimmyjazz 47137]

I beat it into submission by copying both x/y column pairs into the same spreadsheet and putting them on the same scatter chart.  Clumsy, but effective.

[freyguy 4368]

use JMP you mongrel

[Seger78 259]

If you have to do this kind of data visualization on a regular basis you might want to try R. Not too difficult to learn and a lot easier to organize and display data with than using Excel. 

[Orca of Peace 109]

2 hours ago, jimmyjazz said:

I beat it into submission by copying both x/y column pairs into the same spreadsheet and putting them on the same scatter chart.  Clumsy, but effective.

basically merging two datasets then?