Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
Home
DiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWord
DirectoryUser Groups
Related Topics
Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ...

MS Office Forum / General PowerPoint Questions / February 2008

Tip: Looking for answers? Try searching our database.

Datasheet source document

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
Leona - 27 Feb 2008 18:34 GMT
I'm trying to find a way to use an Excel table as the source document for
PowerPoint chart datasheets.  I am often combining the work of several
individuals into one cohensive document -- and it'd just be easier to work
from their Excel tables.  Any help?
Steve Rindsberg - 27 Feb 2008 20:02 GMT
> I'm trying to find a way to use an Excel table as the source document for
> PowerPoint chart datasheets.  I am often combining the work of several
> individuals into one cohensive document -- and it'd just be easier to work
> from their Excel tables.  Any help?

The best solution might be to use Excel to create the charts rather than PPT,
but if that's not practical, you can copy the data from Excel then doubleclick
the chart in PPT and use Edit, Paste Link to paste a link to the Excel data
into the chart.

From then on, changes to the original Excel data will be updated in the chart
whenever the chart is activated.

Using Excel charts instead would give you charts that update themselves
whenever the PPT file is opened, no need to activate each one individually.

-----------------------------------------
Steve Rindsberg, PPT MVP
PPT FAQ:  www.pptfaq.com
PPTools:  www.pptools.com
================================================
 
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.