chart hide number in Y axis

[petra]

Hello

I would like to do the following :

in the axis of a graph : show the numbers from 1-100, hide
the numbers 100-500 and show 500-600
I have been trying to format the axis but there is no
option for this
I think the only way might be to work wity a secondary y
axis

Any suggestions ?
cheers

 

[Jon Peltier]

Petra -

Do you want to break the axis between 100 and 500? Try my example:

http://peltiertech.com/Excel/Charts/BrokenYAxis.html

or a similar example on Tushar Mehta's site (http://tushar-mehta.com).

Do you want to keep the axis, complete with tick marks and the
proportional spacing? Then scale your axis between 0 and 600, and use
this as the axis tick label custom number format:

[<=100]0;[>=500]0;;

- Jon