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!

(E-Mail Removed) -

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

<(E-Mail Removed)> wrote in message
news:(E-Mail Removed)...
>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!
>

Thanks, that fixed it.

Mike Middleton wrote:
> (E-Mail Removed) -
>
> 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
>
> <(E-Mail Removed)> wrote in message
> news:(E-Mail Removed)...
> >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!
> >