# Thread: Three or more Y axis in a graph

1. ## 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]

2. ## Re: Three or more Y axis in a graph

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

3. ## 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. ## 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
•