Archive of Mr Excel Message Board
|Check out our Excel Charting Resources
Back to Charting for Excel archive indexBack to archive home
Split Y-AxisPosted 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 breaksPosted 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 www.MrExcel.com.
All contents © 1998-2004 MrExcel.com.
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.