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. |
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. |
All times are GMT +1. The time now is 01:03 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com