custom number

  • Thread starter Thread starter Gklass
  • Start date Start date
G

Gklass

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.
 
Hi,

How about
[White][<1960]General;[<2002]General;;

and set the font background to be transparent.

Cheers
Andy
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.
Click to expand...
 
Andy Pope wrote:

Yes! I had tried the white, but I never thought of the transparent on
the axis font. I tried it in the number format [White,White]-- didn't work.

Thanks.
[White][=1959]General;[<2002]General;;
Hi,

How about
[White][<1960]General;[<2002]General;;

and set the font background to be transparent.

Cheers
Andy
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.
Click to expand...
Click to expand...
 
Back
Top