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

Posted by Mark W. on March 15, 2001 9:51 AM

No.

Posted by sean on March 15, 2001 10:12 AM

Rats.

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 from Andre Kemp in June 2006

Update

A solution to this problem is in this free chapter: of Stephen Bullen's book.