Hi,

Here are some examples of split axis.

http://peltiertech.com/Excel/Charts/BrokenYAxis.html
http://tushar-mehta.com/excel/newsgr...ial/index.html
http://www.andypope.info/charts/brokencolumn.htm

Cheers
Andy

otyokwa wrote:
I am trying to make a scatter graph with some high values and some low values
-say 0 to 100 and 900 to 1000. Is there a way to have the y-axis display 0
to 100 then a line with values 900 to 1000 above the line?

--

Andy Pope, Microsoft MVP - Excel
http://www.andypope.info