Removing "0"s from a chart
 

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 (b30,
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(b30, 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

obrady wrote:
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 (b30,
b3/b6,"")

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

--

Andy Pope, Microsoft MVP - Excel
http://www.andypope.info

That's It

Thanks

"Andy Pope" wrote:

Hi,

Modify your formula to use NA() for zero data.
=If(b30, 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

obrady wrote:
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 (b30,
b3/b6,"")

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

--

Andy Pope, Microsoft MVP - Excel
http://www.andypope.info