removing zeroes in a graph

**JasonCrow** · 08-15-2009, 05:18 PM

How do i remove all data labels that equal zero, while keeping the negative and postive value data lables on a line or bar graph?

**martindwilson** · 08-15-2009, 09:54 PM

set up so that 0 =n/a
if values in col b then in another col use =if(b1=0,na(),b1) then use that column as your data instead of B

**JasonCrow** · 08-16-2009, 03:05 AM

i did that but the zeroes still show up

**DonkeyOte** · 08-16-2009, 03:50 AM

You will need to post a sample I think.

Martin's point is: Error values don't plot... so if you ensure you're using an error value instead of 0 in your source table then you will get your desired results.

On an aside I am moving this thread to the Charting Forum.

Thanks

**Andy Pope** · 08-16-2009, 06:55 AM

Use a custom number format on the data labels

General;-General;;

**JasonCrow** · 08-16-2009, 02:15 PM

the custom number format worked but how would i do it for currency?

**shg** · 08-16-2009, 07:13 PM

Select you favorie current format, tahn then edit it; e.g., change,

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

or

$#,##0.00 to $#,##0.00;-$#,##0.00;