Hi,

This revision will not plot a marker. The line will connect between the
nearest actual data points.
=IF(AE26="",NA(),AE26/SUM(AE26:AF26:AF26))

Cheers
Andy
--

Andy Pope, Microsoft MVP - Excel
http://www.andypope.info
"Deskpilot" wrote in message
...
=IF(AE26="","",AE26/SUM(AE26:AF26:AF26)) in a cell yeilds a "blan k cell:
GOOD
in line graph, lines drop to 0. I just want last value plotted. All values
updated daily. I can't pick up the fin al data for the day as all lines
drop
to 0.