are the errors produced by these changes any different to the ones in your first post in this thread?

I would suggest getting a basic script up and running that simply generates a chart, then add the features you want, as I said you should double check the Microsoft Documentation, to makes sure you are calling things properly.

Another alternative, and I don't like to mention it, but.., it may be feasable to create an excel macro to do what you want, then simply call it from perl. See Re: Running an excel macro from Perl for further details.

If I had access to a Windows machine, I would try as I suggested, take it back to basics, create a stand alone script to simply open Excel then create a basic chart, then start adding chart features/properties until I had what you are looking for, then integrate the working example into your main script.

Martin