creating a graph with three " Y" axis"

[gweny]

Hi there,

I am trying to create a line graph with three " Y" axis - I can create
two using the secondary option but it does not allow for the third. Am
I using the wrong graph option? What am I doing wrong ?

 

[Bernie Deitrick]

gweny,

You are limited to two - if you want to use a 'third', you really need to scale your data to fit one
of the other two, then change the axis label to note that "line ??? is x10" or whatever....

HTH,
Bernie
MS Excel MVP

 

[Bill Martin]

Excel can't do what you want directly, but...

Jon Peltier has a very interesting set of web pages on making Excel charts do
things they were never intended to do. Below is a link to his page that shows
you one way to get what you want:

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

If you do a lot of charting, I'd recommend you spend half an hour just browsing
through all Jon's web pages to get an idea of some of the surprising things you
can make Excel charts do. Then if you ever come across a need for a speedometer
chart, you'll know where to find it.

Bill