Importing data
The truth be told, there is nothing better than the good ol' Copy &
Paste method when it comes to transferring data. PowerPoint, however,
does allow you to transfer a whole Excel datasheet or a range of data
into a presentation.
Create a new chart slide or click on an existing one.
Double-click on the chart to open the datasheet.
Click the cell located in the upper-left corner.
Select Edit menu > Import File.
Find and double-click on the Excel file that you want to import data
from.
On the Import Data Options dialog, choose a sheet or a range of datacells
to import.
When you can create a link between Excel and PowerPoint Graph, everytime
you change a cell in Excel, the corresponding cell in the PowerPoint datasheet
will update automatically.
CAUTION:
This is a one-way link. Changes made in Excel are updated in PowerPoint,
but changes made in PowerPoint's Graph do not update the original
Excel Spreadsheet.
When you link to data in another program, all existing data from the
Microsoft Graph datasheet is deleted.
In Excel select the range of data you want to link to PowerPoint.
From the Excel Edit menu, choose Copy
Switch to the PowerPoint datasheet and double-click on the graph to
open the datasheet.
