Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.charting
User
 
Posts: n/a
Default linking multiple charts from one xcl workbook

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.
  #2   Report Post  
Posted to microsoft.public.excel.charting
Jon Peltier
 
Posts: n/a
Default linking multiple charts from one xcl workbook

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/
_______


"User" wrote in message
...
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.



Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Excel Charts do not update when workbook recalculated duane Excel Discussion (Misc queries) 1 December 29th 05 02:11 PM
sharing a workbook and incorporating changes from multiple users mprible Excel Worksheet Functions 0 July 27th 05 07:34 PM
multiple pie of pie charts Nerissa Charts and Charting in Excel 1 June 11th 05 06:02 AM
how do I arrange multiple worksheets from the same workbook skytags Excel Discussion (Misc queries) 2 April 28th 05 06:46 PM
How to search multiple worksheets in a workbook for information? medic2816 Excel Discussion (Misc queries) 2 March 29th 05 02:41 PM


All times are GMT +1. The time now is 03:03 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"