Changing Excel link in Powerpoint

  • Thread starter Thread starter Ray Maas
  • Start date Start date
R

Ray Maas

Hi all,

I have about 100 Excel spreadsheets, each representing the financial
status of an individual group within our organization.

I have created a graph with an area chart showing last year's finances.
Superimposed on this is a bar chart showing this year's finances, and
finally a line graph to show funding targets. I want to have a chart for
each spreadsheet, but I don't want to have to create 100 charts from
scratch.

The spreadsheets are all identical - that is, they have the same number
of lines, the same number of colums, the same headers - only the actual
money amounts in the cells are different, depending on which group they
represent.

I tried duplicating the slide, and just linking it to another
spreadsheet. Problem is, when I do this, my nice graph reverts to a default
cheesy-looking bar graph and I have to set up everything all over again

Is there some way in PowerPoint to just change the name of the
spreadsheet the graph is linked to? Where is this information stored and
how do I get to it?

Thanks in advance,
Ray Maas
 
Back
Top