+ Reply to Thread
Results 1 to 2 of 2

Graphs with two Y-axes ?

  1. #1
    Registered User
    Join Date
    09-08-2006
    Posts
    2

    Graphs with two Y-axes ?

    Hi,

    Is it possible to get a graph with two Y-axes in Excel?

    I have the following data:
    X Y1 Y2
    0.1 10,000 10
    0.1 15,000 16
    0.2 31,000 34
    ...

    I would like to scatter plot both Y1 and Y2 on the same graph. But the problem is that numbers in Y1 are substantially higher than those in Y2.

    Is there an Excel graph which would allow me to have two Y-axis, and which could draw the data into one graph so that all is properly visible.

    I have seen such graphs in other applications, but was not able to find it in Excel. Do I need some special Excel AddIn or something?

    Thanks for any comments

  2. #2
    Registered User
    Join Date
    09-08-2006
    Posts
    2
    I found out how to do that:

    http://peltiertech.com/Excel/Charts/TertiaryAxis.html

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1