Thread: Excel pros! Need some help.

Results 1 to 4 of 4
  1. #1 Excel pros! Need some help. 
    GXP Level Member
    Join Date
    Mar 2015
    Location
    Tomball
    Posts
    2,633
    Thanks (Received)
    0
    Likes (Received)
    3
    Dislikes (Received)
    0
    Ok,

    So I have a bunch of .csv log files that I want to put into a graph. I have no problem making a graph, but since everything is in a different scale it's really hard to see. Things like O2 voltage are 0-1V while Ignition is -15-60* manifold is -20 Hg to +15 psi, MAF output is from 0-600 or so. So how do I have multiple Y axis with a single X axis for time?

    thanks,

    Jeff
    Reply With Quote  
     

  2. #2 Re: Excel pros! Need some help. 
    GT Level Member mguzzo's Avatar
    Join Date
    Dec 2007
    Location
    Buffalo NY
    Posts
    483
    Thanks (Received)
    8
    Likes (Received)
    27
    Dislikes (Received)
    0
    in excel you can only have two vertical Y axes. select the series you want to put on the second axis. right click and in the properties select axis - secondary
    --
    "Silver Bullet" 98 GTP Coupe: Stock, rust free, and broadsided.
    Old '98 GTP Coupe: VS Cam, 3.0, S2IC, 42.5#, TOGs, N*/LQ4, Corsa. it once ran a 13 flat
    Older '98 GTP Sedan: Pullied, rockered, SSIC, etc. Stock 14.33 @ 96.5 / PB: 13.89 @ 101
    Reply With Quote  
     

  3. #3 Re: Excel pros! Need some help. 
    SE Level Member
    Join Date
    Jan 2015
    Location
    United States
    Posts
    80
    Thanks (Received)
    2
    Likes (Received)
    4
    Dislikes (Received)
    0
    Another thing that will help is to override the automatic scale min and max that Excel defaults to. Right click on the Y axis bar and get into the config window for the axis. Uncheck the auto scale box and force your own min and max values for the axis until you get the data to display the way you want.

    Another option for you is to go with a 3-D bar or line graph. I think that allows you to have different y scales for each data series.

    Or, you can normalize all the data to % instead of actual values. You'd have to keep track of what 100% is for each data series but then it would all display on the same 2D graph.
    Reply With Quote  
     

  4. #4 Re: Excel pros! Need some help. 
    GXP Level Member
    Join Date
    Mar 2015
    Location
    Tomball
    Posts
    2,633
    Thanks (Received)
    0
    Likes (Received)
    3
    Dislikes (Received)
    0
    I couldn't figure it out so I did this:

    http://www.grandprixforums.net/threa...over-goes-lean

    Jeff
    Reply With Quote  
     

Similar Threads

  1. exhaust pros?
    By kyliek23 in forum General Grand Prix Discussion
    Replies: 21
    Last Post: 05-15-2014, 06:02 PM
  2. KYB Excel-G vs GR-2 - interesting discussion with KYB tech.
    By 92bird in forum Brakes/Suspension/Chassis
    Replies: 75
    Last Post: 07-24-2013, 02:31 PM
  3. Excel MAF Worksheet ***RESOLVED***
    By ricksgpgtcolleen in forum PCM Tuning
    Replies: 1
    Last Post: 01-07-2012, 10:51 PM
  4. A Little Help from you Pros.
    By Scott B in forum General Tech Discussion
    Replies: 4
    Last Post: 05-13-2008, 08:31 PM
Bookmarks
Bookmarks
Posting Permissions
  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •