Datasheet source document

  • Thread starter Thread starter Leona
  • Start date Start date
L

Leona

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?
 
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?
Click to expand...

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.
 
Back
Top