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/Cha...tiaryAxis.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
---------------------------
gweny wrote:
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 ?