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

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

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

"Anuj" wrote:

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

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/
_______


Anuj wrote:

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