Removing "0"s from a chart

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I've inheirted a chart that shows a monthly calculation and a year-to-date
figure.

For example:
Jan Feb Mar Apr May Jun Jul ETC.....
YTD
5% 4% 5% 1% 0 0 0
4%

In the example there is no data for May forward. In the source data, an If
statement is used so that if there isn't any data it posts "", ex. =If (b3>0,
b3/b6,"")

What I need, or been asked to do is to remove the "0"s from the graph. Any
ideas?
 
Hi,

Modify your formula to use NA() for zero data.
=If(b3>0, b3/b6,NA())

You may not get the intended result with that formula. What happens when
Mays data arrives and it's zero?

Cheers
Andy
 
That's It

Thanks

Andy Pope said:
Hi,

Modify your formula to use NA() for zero data.
=If(b3>0, b3/b6,NA())

You may not get the intended result with that formula. What happens when
Mays data arrives and it's zero?

Cheers
Andy
Click to expand...
 
Back
Top