Thread: custom number
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.charting
Gklass
 
Posts: n/a
Default 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.