Adding broken y-axis to graph

[flamingrill]

I have a range of values that fall on the extremes. I wanted to create a broken y-axis or a break indicator and can't find how to do it on an excel graph. Any help would be appreciated!

 

[Corticus]

try using a logamarithmic instead of arithmentic scale (its in the axis properties under format axis- scale))for your axis, then have Excel auto-determine the range(or not, helps though).