View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.charting
Jon Peltier Jon Peltier is offline
external usenet poster
 
Posts: 6,582
Default 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?