 |
 | Home | Contact Us | FAQ | Search & Site Map | Link to Us |
 | Sign In | Join | Other 45 Sites in Network |
| HomeDiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWordDirectoryUser Groups Related Topics Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ... |
MS Office Forum / General PowerPoint Questions / July 2007Creating charts that pull data from Excel spreadsheets
Is it possible to create a template that creates charts and graphs from different spreadsheets. The spreadsheets would have the same name and layout but the values would be different. So the charts and graphs would be different. > Is it possible to create a template that creates charts and graphs from > different spreadsheets. The spreadsheets would have the same name and > layout but the values would be different. So the charts and graphs would be > different. Should be .. You'd create your charts in one spreadsheet, let's call it A.XLS Select the chart, Edit, Copy. Switch to PPT, choose Edit, PasteSpecial and choose to Link. The chart in PPT is now linked to the chart in A.XLS Now copy A.XLS to B.XLS B.XLS contains the original chart data Make changes to A.XLS When you open your PPT the next time, the charts will update from A.XLS Copy B.XLS back to A.XLS and the charts revert. ----------------------------------------- Steve Rindsberg, PPT MVP PPT FAQ: www.pptfaq.com PPTools: www.pptools.com ================================================ |
Reply to this Message |
 Sign In
 Join
 My Latest Posts My Monitored Threads My Blog My Photo Gallery My Profile My Homepage Start New Thread Enable EMail Alerts Rate this Thread
|
©2008 Advenet LLC Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.