How to add a break in the axis in a graph for excel?

[Brianna]

Version: 2008
Operating System: Mac OS X 10.5 (Leopard)
Processor: Intel

Hi,
I've just made a scatter plot, and all my data is in the top left part of the graph itself because the data starts at a high number. If you were hand drawing a graph, you could make a break in the axis by putting a squiggle line at the point where the two axis meet before it becomes straight.
So I am wondering, how can I change the graph so that my information is spread out more, instead of being bunched into one small area?

 

[Mike Middleton]

Brianna -

Maybe you can use some of Jon Peltier's methods:
http://peltiertech.com/Excel/Charts/BrokenYAxis.html

Or, Tushar Mehta's tutorial:
http://tushar-mehta.com/excel/newsgroups/broken_y_axis/index.html

- Mike Middleton
http://www.DecisionToolworks.com
Decision Analysis Add-ins for Excel

 

[Officesux]

If ALL your data points are at the top, it is much simpler to change the
y-axis scale than insert a break. Just double click the y-axis and in the
Format Axis box the appears click the Scale tab and check the Minimum box and
enter a number a little less than your lowest data point.