View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.charting
 
Posts: n/a
Default Delete "$-" at zero on Y axis?

Thanks, that fixed it.

Mike Middleton wrote:
-

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

wrote in message
oups.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!