Chart with multiple series

[officehub]

Can value axis intervals be compressed or eliminated when charting multiple
series with wide value differences?

 

[Jon Peltier]

The usual suggestions are to use a secondary axis, use a logarithmic scale,
or use a hack like this to show a break in the axis:

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

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Peltier Technical Services - Tutorials and Custom Solutions -
http://PeltierTech.com/
2006 Excel User Conference, 19-21 April, Atlantic City, NJ
http://peltiertech.com/Excel/ExcelUserConf06.html
_______