could I have dual scales on the same axis
 

All:

I's trying to three lines on the same axis. However one of the lines has
enormous values while the others are relatively small. Is there anyway to
have dual scales on the same axis?

could I have dual scales on the same axis
 

It's not too hard if you don't mind faking it:

One way:
http://peltiertech.com/Excel/Charts/BrokenYAxis.html

Another way, put the scales in different layers and leave out the separating
lines:
http://peltiertech.com/Excel/Charts/StackedLine.html

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


"Steve" wrote in message
...
All:

I's trying to three lines on the same axis. However one of the lines has
enormous values while the others are relatively small. Is there anyway to
have dual scales on the same axis?