Results 1 to 2 of 2

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

  1. #1
    Senior Member
    Join Date
    Jul 2003
    Location
    Reading, Berkshire
    Posts
    1,229
    Thanks
    57
    Thanked
    53 times in 34 posts
    • tfboy's system
      • Motherboard:
      • MSI X470 Gaming Plus
      • CPU:
      • AMD Ryzen 7 2700
      • Memory:
      • 2x8GB Corsair Vengeance LPX)
      • Storage:
      • 512GB Crucial SSD
      • Graphics card(s):
      • 560 Ti
      • PSU:
      • Corsair RM 650W
      • Case:
      • CM Silencio 550
      • Operating System:
      • W10 Pro
      • Monitor(s):
      • HP LP2475w + Dell 2001FP
      • Internet:
      • VM 350Mb

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

    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

    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 values 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?
    Last edited by tfboy; 13-01-2013 at 03:21 PM.

  2. #2
    Senior Member
    Join Date
    Jul 2003
    Location
    Reading, Berkshire
    Posts
    1,229
    Thanks
    57
    Thanked
    53 times in 34 posts
    • tfboy's system
      • Motherboard:
      • MSI X470 Gaming Plus
      • CPU:
      • AMD Ryzen 7 2700
      • Memory:
      • 2x8GB Corsair Vengeance LPX)
      • Storage:
      • 512GB Crucial SSD
      • Graphics card(s):
      • 560 Ti
      • PSU:
      • Corsair RM 650W
      • Case:
      • CM Silencio 550
      • Operating System:
      • W10 Pro
      • Monitor(s):
      • HP LP2475w + Dell 2001FP
      • Internet:
      • VM 350Mb

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

    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

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •