Graph Help

[Bart]

I am using a line graph for 12 months (Oct-Sept.). I have
formulas built in to update as the months change. My
problem is the graph will display zeros in the months that
have not taken place. I do not want it to graph the zeros.
I tried this for Feb : =if(date>Feb 01, A1, ""). Not
exactly this, but if it was not the date then I tried to
have it be blank text yet it will still graph a zero for
that month. If anyone knows a solution it would be greatly
appreciated.

Thanks.

 

[Frank Kabel]

Hi Bart

if you want the chart change dynamically look at
http://www.tushar-mehta.com/excel/newsgroups/dynamic_charts/index.html
http://peltiertech.com/Excel/Charts/Dynamics.html

Frank

 

[Sandy Mann]

Bart,

Try
=if(date>Feb 01, A1, #N/A)

HTH

Sandy