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