Is there a way when a formula is 0 that it will leave the cell empty instead
of having the 0? I have a bar chart with a lot of information/values and
most of the time there is no value (0).....but the charts data labels all
have the 0's and it looks really overwhelming. If there is another way to
do this, the information would be greatly appreciated.

Thanks

Pl. note that Excel see a cells format as having four Sections. These are,
from left to right Positive numbers, Negative Numbers, Zero Values and Text
values. Each of these Sections are separated by a semi colon (;).

To achieve what you want, format the cells as Custom and choose something like
#,##0_);[Red](#,##0);

this will show negative nos in RED and within () and zeros as blanks.

"ossa" wrote:

Is there a way when a formula is 0 that it will leave the cell empty instead
of having the 0? I have a bar chart with a lot of information/values and
most of the time there is no value (0).....but the charts data labels all
have the 0's and it looks really overwhelming. If there is another way to
do this, the information would be greatly appreciated.

Thanks

Hi sheeloo,

Thanks very much....worked like a charm.

ossa

Pl. note that Excel see a cells format as having four Sections. These are,
from left to right Positive numbers, Negative Numbers, Zero Values and Text
values. Each of these Sections are separated by a semi colon (;).

To achieve what you want, format the cells as Custom and choose something like
#,##0_);[Red](#,##0);

this will show negative nos in RED and within () and zeros as blanks.

"ossa" wrote:

Is there a way when a formula is 0 that it will leave the cell empty instead
of having the 0? I have a bar chart with a lot of information/values and
most of the time there is no value (0).....but the charts data labels all
have the 0's and it looks really overwhelming. If there is another way to
do this, the information would be greatly appreciated.

Thanks