Suppress higher values in y-axis

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.
 
A

Andy Pope

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Reversing X axis flips Primary Y axis plot but not Secondary Y axis plot 1
Positioning x axis at bottom of chart with negative values 5
Customised Axis Values 2
One Column on 1st y-axis and 3 lines on 2nd y-axis 1
Editing secondary x-axis 1
Using the full width of an Excel chart with two Y-axes 2
Formatting 'X' Axis -- 2 fundamental differences 7
Gridlines & Tick marks 1

Top