Compression of Y axis
 

I have a data set which has values grouped in two areas, one below 2,000units
and the other above 50,000units. I do not wish to use two axis on account of
requiring the data lines to be shown accurately above each other. I am aware
that when drawing graphs by hand it is possible to indicate a break on the
axis by use of a zigzag line and was wondering if it was possible to do
something similar in Excel
Eg: 0, 2000, /\/\/\/, 50000, 52000, 54000, 56000 etc

Any ideas would be much appreciated.

Compression of Y axis
 

Yes. http://peltiertech.com/Excel/Charts/BrokenYAxis.html
--
David Biddulph

"Moonpanther" wrote in message
...
I have a data set which has values grouped in two areas, one below
2,000units
and the other above 50,000units. I do not wish to use two axis on account
of
requiring the data lines to be shown accurately above each other. I am
aware
that when drawing graphs by hand it is possible to indicate a break on the
axis by use of a zigzag line and was wondering if it was possible to do
something similar in Excel
Eg: 0, 2000, /\/\/\/, 50000, 52000, 54000, 56000 etc

Any ideas would be much appreciated.