May 5, 20187 yr 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?
May 5, 20187 yr 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.
May 5, 20187 yr Save and close both files. Place them side by side on your desktop Right click on themHit deleteConfirmGo play guitar. Profit Sent from my iPhone using Tapatalk Pro
May 5, 20187 yr 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, 20187 yr by retread
May 5, 20187 yr 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.
May 5, 20187 yr You could have a third workbook that reads data from the other two. Once the data is in one, make charts.
May 5, 20187 yr 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.
May 5, 20187 yr 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.
May 5, 20187 yr 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.
May 5, 20187 yr 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?
May 5, 20187 yr 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.
May 5, 20187 yr 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.
May 6, 20187 yr 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.