Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.charting
|
|||
|
|||
custom number
In order to adjust the spacing of a scatterplot line away from the Y
axis, I use a custom number format (applied to the axis) to hide the first (nonploted) year on the X-axis scale. thus I specify the scale with 1959 as a minimum value but use a custom format like: [1959];;;; So that the 1959 is not displayed. Now, I would like to do the same thing on the other end of the scale, (at the same time)so that 2002 is not displayed. But I can't figure out how to specify the formula. [1959]General;[<2002]General;; doesn't work. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How Do I Assign a Toolbar Button to a Custom Number Format I creat | Excel Discussion (Misc queries) | |||
Strange Result using custom number format | Excel Discussion (Misc queries) | |||
Custom number format button | Excel Discussion (Misc queries) | |||
Custom Number Formats | Excel Discussion (Misc queries) | |||
Custom Number Format... | Excel Worksheet Functions |