I don't think you're missing anything ...I believe he just wanted to know how to do it as something cool to be able to do. But I take it from your suggestions to use the interface tools...that attempting to chart  via VBA can be a pain in the butt?

Ah yes, with the above comment in mind, I just checked out one of JWalk's Excel dev books and do see that VBA Charting is listed under "advanced" techniques. So I'd imagine the best advise here is that messing with charts  is NOT the best way to go about starting to learn Excel VBA! ;-)

But then hey...MY first Word WordBasic project about 12 yrs ago was to tackle an elaborate sales order form in Word with dynamic dialog boxes! HA...what a fool I was to think that one was going to be easy!<g> Granted...it did provide me with a new career after I got the sucker to work. But the learning curve was a bit painful.