Have you tried Importing, instead of Cutting+Pasting?

Insert > Object > Create From File (tab) > Browse to Spreadsheet containing Chart (here you can choose to link to file - that way the chart will change if the Excel spreadsheet changes) > OK

I don't have a copy of 2000 at hand to play with, but I think it still had the capability to do this, have a go and let me know how you get on!