Three line charts on same chart

[Chris]

can I break the y axis to plot three series with total different value on the
same line chart and showing their clear paths.

 

[John Mansfield]

Chris,

These sites might help:

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

http://andypope.info/charts/brokencolumn.htm

These examples deal with columns but you can easily apply the same concepts
to line charts.

 

[Jon Peltier]

Chris -

Here's another option:

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

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