Hi
I have graph that takes value from sheet in my workbook.
The sheet has some Excell functions that calculate values.
Example for the week of Dec 22 a cell has formaula sum(c12:c24) which is 0,
because I have not put any values in cell c12:c24. But on my graph for the
week of Dec 24 , it plots value 0.
I changed the formaula in cell , if(sum(c12:c24)="","",sum(c12:c24)) to get
a blank value in cell, so that my graph does not capture the 0 value, but it
still keeps on caturing 0 and plots value in my graph.
I have changed the setting on Tools-options-Chart-plot empty cells as not
plotted, but it does not work.

Please advise what to do so that, the cells in my sheet that have a formula
but the value is 0 or "" (blank), do not plot as value 0, but leave them as
not plotted because no value exist for that cell.

Regards

Happy Holidays