In addition to Nick's suggestion check
Dynamic Charts
http://www.tushar-mehta.com/excel/ne...rts/index.html

--
Regards,

Tushar Mehta
www.tushar-mehta.com
Excel, PowerPoint, and VBA add-ins, tutorials
Custom MS Office productivity solutions

In article , "=?
Utf-8?B?Q3J1aWNrc2hhbmsgQnJvdGhlcnM=?=" <Cruickshank
says...
How can I suppress the plotting of zero values in line charts? The source
cells have a formula that evaluates as zero for future dates in the date
range.