How do I create more than two Y axis in a chart?

[Anuj]

I need to assign data series to 3 or more y axis. I can only see upto
secondary axis option. Is there a way I can add parallel lines that show more
than 2 y axis scales.
Many thanks

 

[bj]

you can only do two y axis on one chart, but
you can overlay charts and play with positioning and sizes to get what you
want. (this is awkward)

or

Scale your data so that they all fit within a given range,
add a text box or picture with the correct ranges that look like they are
part of the Y axis labels

 

[Jon Peltier]

You can add any number of pseudo axes using this technique:

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

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