Problem in creating chart using VBA macro

[buvanesh]

Hi All,

I have created chart using Excel VBA in the version 2010.
The following is the code. This has been working fine in my system which has 2010.

Please Login or Register  to view this content.

But, when i tried running this in Excel 2003.
I am hitting the "object doesn't support this property" error.
The error is hitting in this line of code.-ActiveSheet.Shapes.AddChart.Select

Please help me to understand whether this is the issue with the Excel versio.
also, please help to get resolved of this issue.

Moderator Note:

Pls use code tags around your code next time as per forum rules.

[Decar]

Hey,

found the answer in another post.

"There was no Shapes.AddChart method in 2003. Use CHarts.Add and then:"

Please Login or Register  to view this content.

here is the link to the original post and all credit for the solution goes to romperstomper

[AlphaFrog]

Another method for what it's worth.

Please Login or Register  to view this content.

[buvanesh]

Thanks for the help, Alphafrog!!
This is working for me well.