axis break
 

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.

axis break
 

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

On Oct 30, 10:52 pm, biowonk
wrote:
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.