Suppress higher values in y-axis

  • Thread starter Thread starter Casy
  • Start date Start date
C

Casy

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.
 
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
 
Back
Top