exclude zero plot in graph
 

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

exclude zero plot in graph
 

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.

exclude zero plot in graph
 

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

"Andy Pope" wrote:

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.