software

How do you not have the chart calculate cells that have formulas which
caluclate to zero. I have a chart that show sales by month for one
year, data is input from Sept to March while the range is Sept to June.
In April the line dive to 0. How do I do this with out having to
readust the source data each month?--
Billg
------------------------------------------------------------------------
Billg's Profile: www.excelforum.com/member.php...oamp;userid=33514
View this thread: www.excelforum.com/showthread...hreadid=533061Hi,

If the cell contains a formula then use NA() instead of quot;quot;.

Here are a couple of pages on the subject.

www.stfx.ca/people/bliengme/E...issingData.htm
processtrends.com/pg_charts_missing_data.htm

Cheers
AndyBillg wrote:
gt; How do you not have the chart calculate cells that have formulas which
gt; caluclate to zero. I have a chart that show sales by month for one
gt; year, data is input from Sept to March while the range is Sept to June.
gt; In April the line dive to 0. How do I do this with out having to
gt; readust the source data each month?
gt;
gt;

--

Andy Pope, Microsoft MVP - Excel
www.andypope.info


Any...thank you very much your suggestion fix my problem.--
Billg
------------------------------------------------------------------------
Billg's Profile: www.excelforum.com/member.php...oamp;userid=33514
View this thread: www.excelforum.com/showthread...hreadid=533061