Linking Excel Charts to Powerpoint

Following an Advanced Powerpoint course with yourselves I have been trying to set up a Powerpoint document that links to an Excel document containing several charts that are used in a Powerpoint presentation that we update monthly. Obviously this is intended to save time with updating the Powerpoint presentation by ensuring that all the graphs are updated automatically.

However, I have found that when I link different slides of the Powerpoint presentation to various different graphs within a specific worksheet in Excel this doesn't work properly. Whenever you update links the document updates all the graphs attached to that worksheet to the first Excel chart on the worksheet and not to the individual chart that I had referenced when I set up the link. It is as if Powerpoint cannot differentiate between different charts on the same worksheet and can only cope with one at a time.

This could be solved by rearranging the Excel spreadsheet so that there is a separate worksheet for every Excel chart that I wish to link to. However my question is whether this is necessary or whether there is a way to solve the problem and to get Powerpoint to select a specific chart within a worksheet containing numerous charts?

Thanks

Dan