+ Reply to Thread
Results 1 to 3 of 3

custom number

  1. #1
    Gklass
    Guest

    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.

  2. #2
    Andy Pope
    Guest

    Re: custom number

    Hi,

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

    and set the font background to be transparent.

    Cheers
    Andy

    Gklass wrote:
    > 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.


    --

    Andy Pope, Microsoft MVP - Excel
    http://www.andypope.info

  3. #3
    Gklass
    Guest

    Re: custom number

    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
    >
    > Gklass wrote:
    >> 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.

    >


+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1