How do I split a y axis in order to display extreme values?

[KGB]

I want to split a y axis so that an extreme value can be displayed without
making the other other values appear too small in the chart.

 

[Andy Pope]

Hi,

Example can be found here, with links to a couple of other explanations.
see http://peltiertech.com/Excel/Charts/BrokenYAxis.html

Cheers
Andy