EITHER
Blanks are ignored by AVERAGE
For charts: make chart, click on it; use Tools|Options; open Chart tab; set
"Plot empty cells as" to Interpolate
OR
Use NA() and get average with =AVERAGE(IF(ISNA(A1:A100),"",A1:A100)) but
enter this with Shift+Ctr;+Enter as it is an array function

best wishes
--
Bernard V Liengme
www.stfx.ca/people/bliengme
remove caps from email

"Incoherent" wrote in message
...
Is there any way to create a truely blank cell that is ignored by a chart
AND
by another function e.g AVERAGE or STDEV.
NA() works with charts, but not with AVERAGE. "" works with AVERAGE but
can
not be scatter-plotted.

An old problem perhaps.