Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Removing "$-" at zero-point of axis
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? |
#2
|
|||
|
|||
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? . |
#3
|
|||
|
|||
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? . |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
the dates to label the x axis on the scatter chart won't print | Charts and Charting in Excel |