Show "Not empty cell" as "Empty" in a chart

[Brodito]

I am trying to create a chart using the following table:

....A...B...C
1...5.......4
2...3.......3
3...8.......7

Formula used in cell B3 is:
=IF(SUM(B1:B2)=0,"",SUM(B1:B2))

When I create the chart; it returns showing a "zero" value from that cell. Cell B3 is not really "empty"; How can I make the chart to show it as "empty", even when there is a formula?
Thanks in advance.

 

[pbornemeier]

When I recreate your example and B1, B2 are empty (or B1 = 5 and B2 = -5) then B3 appears blank. What is the number formatting for that cell in your spreadsheet (Format | Cells | Number) ? It is set to 'General' for me and it seems to work correctly.

 

[Brodito]

Thanks for replying... B1 and B2 are empty.... B3 contains the formula which is described above.
I want to create a chart using the "TOTAL" information (the chart information range is =A1:C1;A3:C3) ... there is where I get the problem, because B3 is not really empty; therefore is plotted in the chart as zero. However, I found a way by using NA() instead of "" in the formula. Then I used Conditional Formating for ERRORS and displayed the font in "white" color (Same as backgroun). Since Excel does not plot NA cells, the chart came OK. But I still wonder if it is possible to do it in an easir way.
Hope I could explain myself.

CH