Thanks for your response! Actually, the cells aren't empty; they contain
zeroes. Consequently, I wrote an IF statement and they now have N/A in them.

Teri

"Bernard Liengme" wrote:

1) Fill empty cell with =NA(), OR
2) Click on chart to activate; use Tools|Options-Chart and specify how
empty cell are to be treated, OR
c) Use dynamic chart: see the Excel Tips & Tricks page on my website
best wishes
--
Bernard V Liengme
www.stfx.ca/people/bliengme
remove caps from email

"Teri" wrote in message
...
I have two columns, one is 2004 Weekly Sales Revenue and one is 2005 Weekly
Sales Revenue. Obviously, 2004 has data for all 52 weeks. 2005 only has
data for the weeks-to-date. How can I chart this data on a line graph--
showing comparison between the two years--and not chart the zero values?

Thanks!