3rd Y Axis on chart

[22strider]

Hello Friends

Is it possible to add 3rd Y Axis to a chart?

I need to plot three series with different scales. One series is plotted as column and other two are line charts. I was able to create a secondary Y Axis but I can't create thrid axis though.

I am using Excel 2003

Thanks for your time.
Rajesh

 

[pgc01]

Hi Rajesh

A terciary axis is not recommended. In fact, a secondary axis is not always a good practice.

Jon Peltier had a page where he showed how to create such an axis but removed it. You can read articles about this and also alternatives here:

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

If you will still want it you can do it adding a vertical line with custom labels and changing the input data by a scale factor. Search Jon Peltier site if you have difficulties.