Code to make a chart in 2010 does not work in 2003

I have the following code I made using Excel 2010...

Please Login or Register  to view this content.

I am trying to implement it in Excel 2003 and it does not work. I tried replacing "ActiveSheet.Shapes.AddChart.Select" with "Charts.Add". It would then make a chart in its own sheet instead of in the sheet I want it in. Any help in correcting what excel 2003 does not like about the above code would be appreciated.