Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations Mike Lewis on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Using Linked Charts in PowerPoint Presentations

Tips and Tricks

Using Linked Charts in PowerPoint Presentations

by  Garridon  Posted    (Edited  )
You may want to use a bar chart that automatically updates based on information when it is updated in a spreadsheet, such as financial information.

In Excel, highlight the data you want to use in your chart. Select Insert>Chart. The wizard takes you through a number of steps. On Step 4, you can select a different sheet to put the chart on if you don't want it to be on the same page as the data.

After you've created the chart, select Edit>Copy from the menu bar to copy it.

Open PowerPoint. Select Edit>Paste Special.

The Paste Special dialog box opens. Choose the Paste Link option, which will display a list that includes Microsoft Chart Object. Make sure that is selected and choose OK. Now, when you open the presentation, it will ask you if you want to update the links.
Register to rate this FAQ  : BAD 1 2 3 4 5 6 7 8 9 10 GOOD
Please Note: 1 is Bad, 10 is Good :-)

Part and Inventory Search

Back
Top