custom number

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.
 
A

Andy Pope

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.
 
G

Gklass

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.
 

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

Top