Thread: Suppress higher values in y-axis
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.charting
Andy Pope Andy Pope is offline
external usenet poster
  
Posts: 2,489
Default 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
Reply With QuoteReply With Quote