1. Attachments are working again! Check out this thread for more details and to report any other bugs.

How to Graph MPG/Temp/Date (3-Axis)?

Discussion in 'Gen 2 Prius Main Forum' started by macmaster05, Nov 21, 2009.

  1. macmaster05

    macmaster05 Senor Member

    Joined:
    Sep 27, 2009
    4,050
    728
    5
    Location:
    USA
    Vehicle:
    2010 Prius
    Model:
    Two
    I'm trying to build a 3-axis graph that shows Date (month) in the X axis, and MPG and outside temperature in 2 Y axis. Then using a second, different colored line, I show the same information with the MPG from the MFD.

    I remember seeing a graph exactly like this in the Priuschat forums. I think the author was Tideland Prius or some admin/super hypermiler here at the forums. I tried searching the forums for the exact thread but had no luck.

    The graph looks like steep mountain peaks and shows how the temperature and yearly cycle influences MPG (valleys during winter and peaks during summer). Well, now I want to make a graph exactly like that.

    1. Can anybody find me that graph (by Tideland?) here in the forums?
    2. How do I create a 3-axis graph in excel?

    Major props to anyone that can help me. Thanks!!
     
    #1 macmaster05, Nov 21, 2009
  2. bwilson4web

    bwilson4web BMW i3 and Model 3

    Joined:
    Nov 25, 2005
    27,134
    15,394
    0
    Location:
    Huntsville AL
    Vehicle:
    2018 Tesla Model 3
    Model:
    Prime Plus
    This is what I have:
    [​IMG]

    [​IMG]



    [​IMG]

    [​IMG]
     
    #2 bwilson4web, Nov 23, 2009
    1 person likes this.
  3. 2009Prius

    2009Prius A Wimpy DIYer

    Joined:
    Mar 25, 2009
    2,705
    510
    63
    Location:
    USA
    Vehicle:
    2009 Prius
    In Excel make an XY (Scatter) chart as usual. Select one of the data series in the chart that you want to put on the right hand side vertical axis. Click "Format", then "Selected Data Series", then the "Axis" tab in the "Format Data Series" window that just popped up, and then click to choose "Secondary axis". Hope this helps. Good luck! :)
     
    #3 2009Prius, Nov 23, 2009
    1 person likes this.
  4. gak27

    gak27 Prius, Take Two

    Joined:
    Jun 18, 2008
    117
    14
    5
    Location:
    Akron, OH
    Vehicle:
    2013 Prius
    Model:
    Four
    ...and depending on your graph settings...

    when you follow 2009Prius' instructions you can get something like this (click to see full size):

    [​IMG]
     
    #4 gak27, Nov 23, 2009
    1 person likes this.
  5. macmaster05

    macmaster05 Senor Member

    Joined:
    Sep 27, 2009
    4,050
    728
    5
    Location:
    USA
    Vehicle:
    2010 Prius
    Model:
    Two
    Thank you all! These graphs are excellent!
     
    #5 macmaster05, Nov 23, 2009
(You must log in or sign up to post here.)