software

Hi
I am plotting data such as the following on a simple line chart...

Jan Feb Mar Apr May June
10 11 12 0 0 0

The future month (Apr, May , June) each contain a formula which returns
either zero or quot;quot; as no data is available.

The problem is that I don't want the future months to be plotted as
zero, which is what happens. There is an option in Excel to avoid
plotting 'empty' cells - but these cells are not empty as they contain
a formula.

Of course, I could simply choose Jan:Mar as the chart range and update
it each month, but I know I'll forget to do it. Alternatively, I could
delete the formula and paste them in each month, but that's still
relying on me to remember.

Thanks--
germullen
------------------------------------------------------------------------
germullen's Profile: www.excelforum.com/member.php...oamp;userid=30626
View this thread: www.excelforum.com/showthread...hreadid=531874germullen:

Here is a link to a post that I have on handling missing data.

processtrends.com/pg_charts_missing_data.htm

In your If formula, replace your quot;quot; with NA(). This will place a #N/A in
your future cells. Excel recognizes #N/A and will not plot them. that should
solve your problem.

Bernard Liengme also has a post on handling missing data..

www.stfx.ca/people/bliengme/E...issingData.htm...Kellyquot;germullenquot; gt; wrote
in message ...
gt;
gt; Hi
gt; I am plotting data such as the following on a simple line chart...
gt;
gt; Jan Feb Mar Apr May June
gt; 10 11 12 0 0 0
gt;
gt; The future month (Apr, May , June) each contain a formula which returns
gt; either zero or quot;quot; as no data is available.
gt;
gt; The problem is that I don't want the future months to be plotted as
gt; zero, which is what happens. There is an option in Excel to avoid
gt; plotting 'empty' cells - but these cells are not empty as they contain
gt; a formula.
gt;
gt; Of course, I could simply choose Jan:Mar as the chart range and update
gt; it each month, but I know I'll forget to do it. Alternatively, I could
gt; delete the formula and paste them in each month, but that's still
gt; relying on me to remember.
gt;
gt; Thanks
gt;
gt;
gt; --
gt; germullen
gt; ------------------------------------------------------------------------
gt; germullen's Profile:
gt; www.excelforum.com/member.php...oamp;userid=30626
gt; View this thread: www.excelforum.com/showthread...hreadid=531874
gt;

That's brillant, thanks a lot

Ger--
germullen
------------------------------------------------------------------------
germullen's Profile: www.excelforum.com/member.php...oamp;userid=30626
View this thread: www.excelforum.com/showthread...hreadid=531874