I've had quite a frustrating afternoon trying to embed charts from an Excel spreadsheet into a PowerPoint presentation.

The charts in Excel are driven by a validated list (drop-down list) where the data will change when a new name is selected in Excel. My PowerPoint presentation contains about 40 slides with each individual slide allocated to a unique person who appears in my Excel drop-down list.

Here is the problem; I am able to copy from Excel the chart I want and paste-special into PowerPoint(using the paste special Microsoft Office Graphic Object option). When I insert the next slide into the PowerPoint, return to my Excel file and select the next name from the drop-down list to generate a new chart, copy and paste special Microsoft Office Graphic Object option into PowerPoint, the new chart (with the new person) comes up fine but the first slide with the first person now changes to the 2nd person I just selected.

How can I continue to use the drop down option to select new individuals and generate new charts without changing everybody else? Do I need to generate 40 worksheets within my file for each individual person? (not really wanting to do this but if it's the only option, then I'll have to do it).

Somebody out there must know a better way.