Suppress higher values in y-axis
 

How to get a y-axis which doesn't show any values at its upper half, eg: a
line with tick-marks up to 200 but the values shown in axis is until 100 only
(blank line in upper half of y axis)?

Thank you.

Suppress higher values in y-axis
 

Hi,

You can use a custom number format.

[White][100]General;General

You will have to set the font colour to have transparent background.

Cheers
Andy

Casy wrote:
How to get a y-axis which doesn't show any values at its upper half, eg: a
line with tick-marks up to 200 but the values shown in axis is until 100 only
(blank line in upper half of y axis)?

Thank you.

--

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