Good guess, though, considering there was no formula in the original post.
Try this:

=IF(H110="",NA(),SUM(K110/H110))

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Peltier Technical Services - Tutorials and Custom Solutions -
http://PeltierTech.com/
2006 Excel User Conference, 19-21 April, Atlantic City, NJ
http://peltiertech.com/Excel/ExcelUserConf06.html
_______

"Tom H" wrote in message
...
Thanks for the quick reply Tushar, but this didn't fix the problem.
The formulae I am using is:- =IF(H110="","",SUM(K110/H110))

Regards Tom H


"Tushar Mehta" wrote:

In article ,
?B?
VG9tIEg=?= <Tom says...
Chart lines drop to zero on last point unless cell is highlighted and
delete
key pressed, which is no good if there is a formulae in the cell.
Anybody
know how to cure this ??


Replace the "" in the formula with NA()

--
Regards,

Tushar Mehta
www.tushar-mehta.com
Excel, PowerPoint, and VBA add-ins, tutorials
Custom MS Office productivity solutions