What if the numbers are in the middle of a scatter chart - Have data 0 to 100
and then 900 to 1000? I would like to cut out the middle numbers - 200 to
800...
"Andy Pope" wrote:
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