View Single Post
  #2   Report Post  
John Mansfield
 
Posts: n/a
Default

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