break the y axis

[m.tamas]

Hey Guys,

my problem is, I would like to break / cut out a piece of/from the y axis, as I only have data on with relatively low and with high values, nothing on the middle.
Therefore I want to avoid to use space showing useless part of the graph.
I found support for the way in previous excel version but not in 2010.

Could anyone assist please?
Regards,
Tamas

[Andy Pope]

The approach for xl2010 should be the same as previous versions. The dialog boxes for setting axes limits may have changed but the principle is the same.

http://www.andypope.info/charts/brokencolumn.htm