Related:

- Excel: Empty cell in 2007
- Excel date format dd.mm.yyyy - Guide
- Excel free download - Download - Spreadsheets
- Number to words in excel - Guide
- Excel marksheet - Guide
- How to take screenshot in excel - Guide

## 4 responses

mubashir aziz
Posts
190
Registration date
Sunday April 12, 2009
Status
Member
Last seen
February 16, 2010
165

May 28, 2009 at 10:32 PM

May 28, 2009 at 10:32 PM

You just use NA() function and excel chart will treat it as empty cell ..... then you can hide it in printing by File > Page Setup > Sheet > Cell Error <Blank> ...

You can hide Error values by conditional formating by putting this formula =+ISNA(C5) suppose values are in C5 ......

So your formula is

=if((sum(a1:a5))=0,

You can hide Error values by conditional formating by putting this formula =+ISNA(C5) suppose values are in C5 ......

So your formula is

=if((sum(a1:a5))=0,

**NA()**,(sum(a1:a5)))
PicaPica
Posts
1
Registration date
Friday April 17, 2009
Status
Member
Last seen
April 17, 2009
2

Apr 17, 2009 at 11:51 PM

Apr 17, 2009 at 11:51 PM

Did you find an answer?

I have the same problem.

Inan IF-function, I do not know which empty result would make an empty cell.

I have the same problem.

Inan IF-function, I do not know which empty result would make an empty cell.

I had the same problem but the 1st person to post figured out the answer accidently,

=if((sum(a1:a5))=0,"",(sum(a1:a5))) is WRONG

=if((sum(a1:a5))=0," ",(sum(a1:a5))) is RIGHT

i put in the exact formula as him but put " " instead of "" and it works

=if((sum(a1:a5))=0,"",(sum(a1:a5))) is WRONG

=if((sum(a1:a5))=0," ",(sum(a1:a5))) is RIGHT

i put in the exact formula as him but put " " instead of "" and it works

Sep 29, 2009 at 05:57 PM

Brilliant ! I've been struggling with this since yesterday, awesome stuff.

(I used the #N/A method - it still seemed to count " " as Zero)

Ta - Nathan.

Mar 22, 2012 at 02:12 PM

Mar 22, 2012 at 02:22 PM

Found a better solution! Leave your formulas and let them return the zeros.

Then in your chart, add data labels, then format the labels to hide the zeros. Got to Edit Labels, Number options, and use a Custom format and enter 0;;; then click Add. You might have to change the 0 to 0.0 or 0% or whatever is appropriate for your data values.

The format string syntax is:

positive value format; negative value format; zero value format; text value format.

Jun 13, 2012 at 08:56 AM