Jump to content
View in the app

A better way to browse. Learn more.

Surly Horns

A full-screen app on your home screen with push notifications, badges and more.

To install this app on iOS and iPadOS
  1. Tap the Share icon in Safari
  2. Scroll the menu and tap Add to Home Screen.
  3. Tap Add in the top-right corner.
To install this app on Android
  1. Tap the 3-dot menu (⋮) in the top-right corner of the browser.
  2. Tap Add to Home screen or Install app.
  3. Confirm by tapping Install.

Featured Replies

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?

  • Author

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.

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

  • Author

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.

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

  • Author

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

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.

  • Author

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.

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?

  • Author

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.

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. 

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...

Configure browser push notifications

Chrome (Android)
  1. Tap the lock icon next to the address bar.
  2. Tap Permissions → Notifications.
  3. Adjust your preference.
Chrome (Desktop)
  1. Click the padlock icon in the address bar.
  2. Select Site settings.
  3. Find Notifications and adjust your preference.