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
can you create a break in a chart scale?
Posted by sean on March 15, 2001 9:46 AM
hi there,
I have created a chart of columns representing lengths. One column goes up to 450 on the y-axis. The rest are between 0-59. Can you create a scale break on the y-axis to accomodate this rather than having the lone column stick out like a sore thumb?
thanks
sean
Re: can you create a break in a chart scale?
Posted by Mark W. on March 15, 2001 9:51 AM
No.
Re: can you create a break in a chart scale?
Posted by sean on March 15, 2001 10:12 AM
Re: can you create a break in a chart scale?
Posted by Mark W. on March 15, 2001 10:42 AM
Of course, depending on the nature of your data
you may be able to use a data transformation
such as converting your values to logarithms.
Update
Update from Andre Kemp in June 2006
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.