3 of 4 Y axes

[Kelly McFaul]

I have a chart that has a Y axis on the left and on the right side of the
chart. Is there any way to have 2 Y axes on the left and 2 on the right? I
would like to be able to compare 4 sets of data at the same time and the
range of values might be much different.
Thanks in advance,
Kelly

 

[Jon Peltier]

Kelly -

You can extend this technique to a quaternary axis:

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

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Peltier Technical Services
Tutorials and Custom Solutions
http://PeltierTech.com/
_______