Jump to content

Recommended Posts

Posted

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?

Posted

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.

Posted

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

  • Like 1
Posted
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.

Posted

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.

Posted
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?

Posted

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.

Posted

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. 

Posted
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?

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.

Guest
Reply to this topic...

×   Pasted as rich text.   Paste as plain text instead

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.



×
×
  • Create New...