Delete "$-" at zero on Y axis?

[Bob]

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!

 

[Mike Middleton]

(e-mail address 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

 

[Bob]

Thanks, that fixed it.

(e-mail address 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