Data table in charts

[edmundo1971]

Hello everyone!!!

The attached spreadsheet show the problem I have.

I have two tables of data into which the sales of the three items listed are entered (Cells D3:O5 and Cells D9:OO11). A third table automatically totals the corresponding values from the two tables abiove it and feeds the chart shown.

Thing is, although I've programmed the formulas in the third table to show "blank" if there are "blanks" in the corresponding cells, the data table in the chart shows £0 against the corresponding months (presumably because the cells contain a formula).

But I REALLY don't want it to.

I'm aware that linking the chart to either of the two other tables would result in the data table showing "blank" against the corresponding months but it's important that the chart shows only the totals.

Is this do-able???

Thanks

Ed

[Kaper]

If you care more about graph than sheet then change formula from:
=IF(OR(D3="",D9=""),"",SUM(D3,D9))
to
=IF(OR(D3="",D9=""),NA(),SUM(D3,D9))

in empty cells you will get #N/A
but in the table there will be blanks

PS. You can hide #N/A! in spreadsheet with conditional formatting using ISERROR function and gray font color.