Error in graph
Replace the second "" with NA() in your formula
if(sum(c12:c24)="",NA(),sum(c12:c24))
of course it will throw the #N/A which can look ugly in a formula but you
can hide that using conditional formatting and white fonts
--
Regards,
Peo Sjoblom
"ub" wrote in message
...
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
|