The good news is you shouldn't need VBA to make it happen. Check out this article from Dian's newsletter for step-by-step guidance on dynamic charting by date:pubs.logicalexpressions.com/.../LPMArticle.asp