Skip to content

Help with Excel 2010: plotting graph 2 data sets where x axis sample points differ

Featured Replies

I've searched around the net a fair bit and cannot find a way of doing this.

I'm generally OK with excel, but do find their graphs the most infuriating system out there. A gazillion options to make it pretty but nothing that helps you translate the data from tables to graphs. :think:

My problem is this: I have two different sets of data I want to put on a single graph (they're dyno plots from my car). I've used some great open source tools like engauge and plotdigitizer to create data value from scanned print outs.

Unfortunately, the x axis (rpm) isn't to the same scale on both drawings, so I have data but where the sampling on the x axis differs, yet it relates to the same variable (rpm).

The only way I can think of doing it now it going over both graphs and picking out the same sample points on the x axis so that they "tie up" when brought into excel.

But surely there has to be a way of "merging" data on the same axis from two different data sets?

Any ideas?

  • Author

OK, I've thought of a workaround: bring all the data into the same sheet then sort by rpm. I've now five columns: rpm, HP 1, torque 1, HP 2, torque 2 and have sorted by rpm. I now have one continuous increasing rpm range with the four data sets spread out across the rev range. Seems to work :)

  • Author

Result! :rofl:

2317642000&k_jrFwbc8-O.png

Create an account or sign in to comment

Recently Browsing 0

  • No registered users viewing this page.

Account

Navigation

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.