exclude zero plot in graph

[Deskpilot]

=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.

 

[Andy Pope]

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

 

[Deskpilot]

Thanks Andy! A lot of copy and paste, all the way down all affected columns
in the Data Range worked EXACTLY as I had hoped.
The graph's final data point for all data is the last entered day with no
drop to ZERO (0) for the future day.
I can see the data plots as the end of day status.

Whish I could attach an image of the graph