Removing "$-" at zero-point of axis

  • Thread starter Thread starter John Holland
  • Start date Start date
J

John Holland

I've got a line chart with dollar values on the y-axis. When the axis
starts at zero, excel puts a "$-". With a simple arithmetic scale,
it's implicit that the zero-point is actually zero, and I want to get
rid of this "$-".

Any ideas?
 
John,

Please take a look at these instructions on John Peltier's
site:

http://peltiertech.com/Excel/Charts/ArbitraryGridlines.html

In your case, the labels would be numbers formatted as
text with the exception of zero. For example, labels
would be formatted as " 0, $10, $20, $30", etc. You
would need to use the chart tool to add the labels to the
chart.

Regards,

John Mansfield
 
No, it's easier than that. It looks like a currency number format, which, if you
select it in the Number tab of the Format <Whatever> dialog and then select the
Custom box in the list, would look something like this:

_($* #,##0.00_);_($* (#,##0.00);_($* "-"??_);_(@_)

Never mind the details. There are four entries in this format statement:

[positive];[negative];[zero];[text]

Since you want to omit zeros, remove the third entry:

_($* #,##0.00_);_($* (#,##0.00);;_(@_)

If the first two entries are somewhat different, you leave them as they are, and
still remove the third.

For more about number formats:

http://peltiertech.com/Excel/NumberFormats.html

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Peltier Technical Services
Tutorials and Custom Solutions
http://PeltierTech.com/
_______
 
Back
Top