Results 1 to 4 of 4
  1. #1
    2 Star Lounger
    Join Date
    Apr 2002
    Location
    Houston, Tx, USA
    Posts
    121
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Three or more Y axis in a graph

    Is there a way I can have a third Y axis to plot in a scatter plot or line plot?

    I have three series of data. Each series has its own scaling and units, and plotting against one or two Y axis, always leaves one of the series off scale, or almost flat against the X axis.

    Thanks. [[img]/forums/images/smilies/wink.gif[/img]
    Guillermo

  2. #2
    4 Star Lounger
    Join Date
    Jan 2001
    Location
    Kortrijk, Belgium
    Posts
    571
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Three or more Y axis in a graph

    I don't think there is a way to have a third Y-axis.

  3. #3
    Star Lounger
    Join Date
    Jan 2001
    Location
    Newcastle, New South Wales, Australia
    Posts
    81
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Three or more Y axis in a graph

    The only way you can have 3 scales on an XY graph is to do the scaling manually.
    Multiply the 3rd Y range by something that will bring it in line with the 2nd Y range, say all by 100 or whatever is appropriate.
    Then I would also create a "fake" axis by making a range with the same X values and with each Y value the point at which you want the "tickmark" to appear. eg if the maximum X value is just under 100, then you could put X=110. Use the plus sign for the symbol and connect by lines, and there's your 3rd Y axis displayed. Then you have to put Data Labels beside them with the "real" values not the scaled values; and also a text box for the label.

    Is this any help?
    Ruth

  4. #4
    2 Star Lounger
    Join Date
    Dec 2000
    Posts
    140
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Three or more Y axis in a graph

    Consider formatting your Y axis as logarithmic.

Posting Permissions

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