The way i do it is
=IF(C64=0,"",SUM(X64*1000)/C64)
Works for me

"AJ-foster" wrote:

i have a chart which is populated by formulas on a monthly basis but the line
graph reads blank cells which has formulas but not data in as a ZERO value
which makes the line graph drop to zero at which ever point the last monthly
figure goes in is there away of the series fuctiion that reads the range not
read the formula as a value but as a blank