Automation error when creating graphs

Hey I get this automation error when I try to create line charts with three series from a array of ranges. The runtime error is -2147221080

This only happens when I try to create the charts as an object in a worksheet. My macro works fine when creating new sheets.

My chart creation code looks like this

Please Login or Register  to view this content.

Thanks.

Have a look at...

HTML Code: 

Could this be happening in your code - you appear to be working while a chart is active and not a worksheet?

Thanks for your response. I'm reading that link right now.

I guess I had to use activeworksheet.chartobject.chart to modify the properties instead of using activechart.