Three line charts on same chart
 

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

Chris,

These sites might help:

http://www.peltiertech.com/Excel/Cha...okenYAxis.html

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

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

----
Regards,
John Mansfield
http://www.pdbook.com

"Chris" wrote:

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

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/
_______

John Mansfield wrote:

Chris,

These sites might help:

http://www.peltiertech.com/Excel/Cha...okenYAxis.html

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

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

----
Regards,
John Mansfield
http://www.pdbook.com

"Chris" wrote:


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