Omitting Part of the Y-Axis

[Dave McGuire]

Hi,

I'm creating a chart with some values very high (hundreds of thousands),
and some of the values quite low (hundreds) and would like them
displayed so that their relative values are clear, but don't want a
massive graph with a large blank space in the middle.

How can I omit some of the y-axis values and replace with perhaps a
zig-zag line as you might if you were sketching a similar graph?

Cheers,

Dave

 

[Andy Pope]

Hi,

Have a look at this explanation. There are also links to other examples
at the end of the page.
http://www.andypope.info/charts/brokencolumn.htm

Cheers
Andy

 

[Dave McGuire]

Hi,

Thanks for this. I thought it was going to be easy. I might just split
into two seperate charts.

Thanks for the help anyways.

Dave