Excel chart with breaks?

[Sarah]

suppose I'm trying to chart (columns) several series of
data. One series has a magnitude much larger than the
others. Can excel chart the one with a large magnitue
with break lines in the middle of the chart so that the
other ones don't become too small as a result of the
difference between the magnitudes of various series?
thanks
Arash

 

[Debra Dalgleish]

Jon Peltier has instructions for a broken Y axis:

http://www.peltiertech.com/Excel/Charts/axes.html#Broken

Or, plot the larger series on a secondary Y axis.