Archive of Mr Excel Message Board

Check out Bill's new book on Charts and Graphs for Microsoft Office Excel 2007

Back to Charting for Excel archive index
Back to archive home

Split Y-Axis

Posted by Patricia on September 26, 2001 8:33 AM
Does Excel have the ability to split a Y-Axis? What I'm thinking of is when your data points suddenly have a very wide gap -- and in the old graphing classes, you could simply insert to hash marks on the axis and skip over the un-needed data points.

I really needed this capability a couple of weeks ago and couldn't come up with the solution after a lot of research. However, now that I've found this forum, I'd thought I would toss out the question to you guys.


I dont think excel can do axis breaks

Posted by Eric on September 27, 2001 9:09 AM
Have you considered plotting the low range data on 1 series, and the high range data on a second, then have the second series plot on a second Y axis? You could adjust the range of the two Y axes so that they appeared to give you an axis break.

This archive is from the original message board at
All contents © 1998-2004
Visit our online store to buy searchable CD's with thousands of VBA and Excel answers.
Microsoft Excel is a registered trademark of the Microsoft Corporation.
MrExcel is a registered trademark of Tickling Keys, Inc.