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/...Gridlines.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

-----Original Message-----
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?
.

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/
_______

John Mansfield wrote:

John,

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

http://peltiertech.com/Excel/Charts/...Gridlines.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


-----Original Message-----
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?
.