| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.charting
|
|||
|
|||
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. |
|
#2
Posted to microsoft.public.excel.charting
|
|||
|
|||
|
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 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Want to show only values higher than'x' from otehr column? | New Users to Excel | |||
| Suppress X Axis Scaling | Charts and Charting in Excel | |||
| Configuring a cell to take higher values only | Excel Discussion (Misc queries) | |||
| How do I change z-axis value from zero to a higher number (eg 4)? | Charts and Charting in Excel | |||
| suppress zero values in line charts? | Charts and Charting in Excel | |||
Linear Mode
