Charting with VBA in an advanced subject and one that even some of the top
MVPs hate to tackle. With that in mind, here are comments from Excel MVP and
Charting guru, Jon Peltier when I asked him about a similar question some
months ago. Take his advise for what it's work. And you might want to also
check some of his charting articles, particularly his FAQ in TechTrax. His
article link is also below...