How do you split the Y-axis on an Excel chart?

RickiRebel · Dec 14, 2004

I've seen this done where the Y-axis is "split" to accommodate a big leap to
a high number (outlier).

Barb Reinhardt · Dec 14, 2004

Take a look at Jon Peltier's Broken Y axis documentation and see if it
helps.

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

simple chart	0	Jul 16, 2016
Scatter chart with categories on x-Axis	2	Feb 28, 2013
Excel 2010 - Line Chart with Mulitiple Data Sets	1	May 7, 2012
Outlier data point for Chart in Excel	1	Apr 7, 2009
Chart distorts secondary axis when the x-axis is logarithmic	5	Jan 4, 2010
One Column on 1st y-axis and 3 lines on 2nd y-axis	1	May 4, 2010
How do I plot multiple LINES vs a Y Axis on a BAR Chart ?	4	Jul 17, 2009
Positioning x axis at bottom of chart with negative values	5	Feb 25, 2010

Ask a Question