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

How do I put words as the Y axis values? 0
Customised Axis Values 2
Positioning x axis at bottom of chart with negative values 5
Editing secondary x-axis 1
Formatting 'X' Axis -- 2 fundamental differences 7
Y-axis tick marks 2
Gridlines & Tick marks 1
How do I specify X,Y axis and Series values in a line graph? 5

Top