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