exclude zero plot in graph

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Deskpilot - 24 Apr 2008 05:18 GMT

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

Reply to this Message

Andy Pope - 24 Apr 2008 08:35 GMT

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

Signature

Andy Pope, Microsoft MVP - Excel
http://www.andypope.info

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

Reply to this Message

Deskpilot - 25 Apr 2008 15:19 GMT

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

> Hi,
>
[quoted text clipped - 10 lines]
> > drop
> > to 0.

Reply to this Message