Keep in mind that Charts in Excel are complicated and involve two different objects: Chart and ChartObject. In Excel when working with the chart, you seldom run into a problem. But in VBA there are properties and methods that "should work" but do not, because they are not specific to Chart or ChartObject.
If you do much work with charts, then consider buying the book Excel Charts by John Walkenbach. It is the best investment you can make. Not only does he cover all the usual chart issues, he shows you how to do chart things that are consiered impossible. And he gives 4 chapters on creating charts with VBA.
old, slow, and confused
but at least I'm inconsistent!