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

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

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

Change your formula to this:

=IF(E5="",na(),SUM(B4:B5)/SUM(D4:D5))

This will give you #N/A errors where column E is blank, and these
errors will not affect your graph. If you don't want to see #N/A in
the cells, you can apply conditional formatting to the cells to print
white on a white background (thus making them appear blank).

Hope this helps.

Pete

On Mar 5, 4:31*pm, soconfused
wrote:
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- Hide quoted text -

- Show quoted text -

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