G Guest Feb 28, 2005 #1 can I break the y axis to plot three series with total different value on the same line chart and showing their clear paths.
can I break the y axis to plot three series with total different value on the same line chart and showing their clear paths.
G Guest Mar 1, 2005 #2 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.
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.
J Jon Peltier Mar 1, 2005 #3 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/ _______
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/ _______