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?


--
Billg
------------------------------------------------------------------------
Billg's Profile: http://www.excelforum.com/member.php...o&userid=33514
View this thread: http://www.excelforum.com/showthread...hreadid=533061

New Help in Line Chart
 

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

New Help in Line Chart
 

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


--
Billg
------------------------------------------------------------------------
Billg's Profile: http://www.excelforum.com/member.php...o&userid=33514
View this thread: http://www.excelforum.com/showthread...hreadid=533061