+ Reply to Thread
Results 1 to 3 of 3

Delete "$-" at zero on Y axis?

  1. #1
    Bob@1800-mail.com
    Guest

    Delete "$-" at zero on Y axis?

    I have a chart with the Y axis formated in dollars, zero cents, and I
    want to get rid of the first dollar sign and dash that appears at the
    zero point on the Y axis.

    Is there a way to do this without changing the minimum value? (And keep
    the dollar format.)


    Thanks!


  2. #2
    Mike Middleton
    Guest

    Re: Delete "$-" at zero on Y axis?

    Bob@1800-mail.com -

    One way is to not use the "Currency Style" button on the formatting toolbar.

    Instead, select the axis, and choose Format Selected Axis | Number |
    Currency, with the appropriate settings.

    - Mike
    www.mikemiddleton.com

    <Bob@1800-mail.com> wrote in message
    news:1144190015.905765.225470@t31g2000cwb.googlegroups.com...
    >I have a chart with the Y axis formated in dollars, zero cents, and I
    > want to get rid of the first dollar sign and dash that appears at the
    > zero point on the Y axis.
    >
    > Is there a way to do this without changing the minimum value? (And keep
    > the dollar format.)
    >
    >
    > Thanks!
    >




  3. #3
    Bob@1800-mail.com
    Guest

    Re: Delete "$-" at zero on Y axis?

    Thanks, that fixed it.

    Mike Middleton wrote:
    > Bob@1800-mail.com -
    >
    > One way is to not use the "Currency Style" button on the formatting toolbar.
    >
    > Instead, select the axis, and choose Format Selected Axis | Number |
    > Currency, with the appropriate settings.
    >
    > - Mike
    > www.mikemiddleton.com
    >
    > <Bob@1800-mail.com> wrote in message
    > news:1144190015.905765.225470@t31g2000cwb.googlegroups.com...
    > >I have a chart with the Y axis formated in dollars, zero cents, and I
    > > want to get rid of the first dollar sign and dash that appears at the
    > > zero point on the Y axis.
    > >
    > > Is there a way to do this without changing the minimum value? (And keep
    > > the dollar format.)
    > >
    > >
    > > Thanks!
    > >



+ 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