• Create BookmarkCreate Bookmark
  • Create Note or TagCreate Note or Tag
  • PrintPrint

Linking Data

Another way to import data is to link it from an existing spreadsheet file. When you link data, changes you make to the source file are automatically reflected in the PowerPoint datasheet and chart.

To link from a file to a datasheet:

1.
Launch the application that created the source file, and open the file (Figure 4.13).

2.
Select the data to be linked, and choose Edit > Copy.

3.
Switch back to PowerPoint.

4.
Create a new chart slide, double-click the chart placeholder, and then delete the sample data in the datasheet.

5.
Click the first cell of the datasheet.

6.
Choose Edit > Paste Link, and click OK to continue.

7.
Move or close the datasheet to see your new chart.

Figure 4.13. The selected range in a Microsoft Excel spreadsheet will be copied and then paste-linked in a PowerPoint datasheet.


Tip

As long as the chart is open in Graph, changes to the source file instantly reflect in the datasheet and chart.


Tip

If you forget the name or location of the source file, choose Edit > Links to display the Link dialog box (Figure 4.14).


Tip

A fast way to open your source file is to click Open Source in the Link dialog box.


Tip

Use the Change Source option in the Link dialog box if you have moved or renamed the source file.

Figure 4.14. While in the datasheet, choose Edit > Links to display the Link dialog box.



  • Creative Edge
  • Create BookmarkCreate Bookmark
  • Create Note or TagCreate Note or Tag
  • PrintPrint