I think, your charting task can be accomplished without resorting to VBA. Check out the dynamic charting web site of Tushar Mehta and the links provided therein. There are various charting examples available and you should find a model for your task.

www.tushar-mehta.com/.../index.html

Hope this infomation is of some use to you.