How do I clear a cell

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

soconfused - 05 Mar 2008 16:11 GMT

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.

Signature

DMM

Reply to this Message

Bob Phillips - 05 Mar 2008 16:23 GMT

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?

Signature

---
HTH

Bob

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

> How do I clear a cell instead of blanking it.
>
[quoted text clipped - 7 lines]
> In other words my chart goes from say 74 down to zero and I just want the
> data point to stop at 74.

Reply to this Message

soconfused - 05 Mar 2008 16:31 GMT

I want to stop plotting any points from there.

Signature

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?
[quoted text clipped - 10 lines]
> > In other words my chart goes from say 74 down to zero and I just want the
> > data point to stop at 74.

Reply to this Message

Pete_UK - 05 Mar 2008 16:41 GMT

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 <soconfu...@discussions.microsoft.com>
wrote:

> I want to stop plotting any points from there.
> --
[quoted text clipped - 27 lines]
>
> - Show quoted text -

Reply to this Message

Bob Phillips - 05 Mar 2008 19:27 GMT

I think you need a dynamic range for the data.

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

Signature

---
HTH

Bob

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

>I want to stop plotting any points from there.
>
[quoted text clipped - 14 lines]
>> > the
>> > data point to stop at 74.

Reply to this Message