Three or more Y axis in a graph

Topic

New Reply

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. [

Reply | Quote

Replies

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

Reply | Quote

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

Reply | Quote

Consider formatting your Y axis as logarithmic.

Reply | Quote