I think you need a dynamic range for the data.

Let me check, where are the formulae that you posted?

--
---
HTH

Bob


(there's no email, no snail mail, but somewhere should be gmail in my addy)



"soconfused" wrote in message
...
I want to stop plotting any points from there.
--
DMM


"Bob Phillips" wrote:

Do you mean that you want to stop plotting any points from there, or that
you want the datapoint to pick up the previous value?

--
---
HTH

Bob


(there's no email, no snail mail, but somewhere should be gmail in my
addy)



"soconfused" wrote in message
...
How do I clear a cell instead of blanking it.

Here is my current formula:
=IF(E5="","",SUM(B4:B5)/SUM(D4:D5))

I am using this for a chart and I don't want to blank the cell becauase
it
causes the chart to look horrible. I just want the data to stop on the
chart.

In other words my chart goes from say 74 down to zero and I just want
the
data point to stop at 74.








--
DMM