Thread: New Help in Line Chart

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?

Hi,

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

Here are a couple of pages on the subject.

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

Cheers
Andy


Billg wrote:
> 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?
>
>

--

Andy Pope, Microsoft MVP - Excel
http://www.andypope.info

Any...thank you very much your suggestion fix my problem.