Line graphs dropping to zero!

[Guest]

I'm drawing a line graph from calendar year output data that contains
formula's and IF statements. My input data stops in September and my output
formula's continue with #DIV/0! results until year end. How can I get my line
graph to stop with the final result of good data, rather than 'plummet' to
zero and make my graph look like a disaster.
Thanks

 

[Frank Kabel]

Hi
change your formula to something like
=IF(B1=0,NA(),A1/B1)

 

[Gord Dibben]

Phil

Make your series dynamic so they read only valid data.

See Tushar Mehta's site for dynamic chart ranges.

http://www.tushar-mehta.com/excel/newsgroups/dynamic_charts/index.html

Gord Dibben Excel MVP