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