anyway to 'break' a y-axis scale?

[mcgew]

I want to display some data in bar chart form - the majority have y-values between 0-100, then a handful have y-values of 10,000-30,000. the scaling means that the majority of the bars values are really small in comparison.

is there a way of breaking the scale so that all bars are easily visible (i don't want a log scale).
eg. y axis scale goes: 0; 20; 40; 60 ; 80; 100; break; 10,000; 20,000; 30,000


Thanks,
Grace

 

[Juan Pablo González]

Try this:

http://www.peltiertech.com/Excel/Charts/axes.html#Broken