Powerpoint Opens Wrong Spreadsheet

Question

Hello:

PowerPoint 2010

Windows XP SP3

• I have 7 charts embedded into a single PowerPoint presentation.
• The data is maintained in Excel.
• As the information changes monthly, I have to edit the spreadsheet that contains the data.
• To up-date the chart in PowerPoint, I click on it and choose "Edit Data" from the Ribbon's "Chart Tools."
• Excel opens and I make my edits.
• To up-date the data I'd like presented in Powerpoint, I click the chart and choose "Select Data" from the Ribbon's "Chart Tools."
• I then select the new information.

The above works with all but the newest chart I've added to the Powerpoint presentation.  When I attempt to "Edit Data" on this new chart, it opens its own Excel spreadsheet that looks like this...

	Series 1	Series 2	Series 3
Category 1	4.3	2.4	2
Category 2	2.5	4.4	2
Category 3	3.5	1.8	3
Category 4	4.5	2.8	5
	To resize chart data range, drag lower right corner of range.

What do I have to do to link the presentation to the correct spreadsheet?

Thanks in advance!

Kevin

Answer 1

You may refer to the link given below to change the data in an existing chart and check if it helps:

http://office.microsoft.com/en-us/powerpoint-help/change-the-data-in-an-existing-chart-HA010338374.aspx?CTT=3