linking multiple charts from one xcl workbook

U

User

I have a ppt presentation that uses six different charts that I created in an
excel workbook. I want the charts in the ppt to update every time I enter
data into the excel worksheet but when I use the link function
"insert->object" it ends up putting the same chart on all the ppt slides
rather than the one slide it needs to be on. Any help is appreciated.
 
J

Jon Peltier

Insert Object From File inserts the active sheet at the time the file was
last saved, or the active sheet at the time the object was inserted, if it
is active in Excel at that time.

I would recommend that you copy the chart in Excel, then use Paste Special -
Link in PowerPoint.

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Peltier Technical Services
Tutorials and Custom Solutions
http://PeltierTech.com/
_______
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Embed the same Excel multiple times 0
Visio to Excel 0
Update links 0
One extra x axis item that wont go away - can anyone help? 3
Chart SERIES OFFSET 5
Tracked changes by multiple people modified to one 0
Chart Location Impact On Links When Copying To New Workbook 1
XY scatter plot with more than 32000 rows in Excel 2003 0

Top