axis break

[Guest]

Is there a way to make a break in the y-axis? For instance if I have three
values 10, 30, and 300 on an bar graph the difference between the 10 and 30
value is not as clear because of the 300 value. If there was an axis break,
say breaking from 50-250 the diff between 10 and 30 would be more obvious.

If there isn't this option somewhere, why in the hell not!? I consider this
a major oversight in excel.

 

[Pete_UK]

Follow this link for an explanation of how to do it:

http://www.andypope.info/charts/brokencolumn.htm

Andy also links to other sites with similar solutions.

Hope this helps.

Pete