Contact US

Log In

Come Join Us!

Are you a
Computer / IT professional?
Join Tek-Tips Forums!
  • Talk With Other Members
  • Be Notified Of Responses
    To Your Posts
  • Keyword Search
  • One-Click Access To Your
    Favorite Forums
  • Automated Signatures
    On Your Posts
  • Best Of All, It's Free!

*Tek-Tips's functionality depends on members receiving e-mail. By joining you are opting in to receive e-mail.

Posting Guidelines

Promoting, selling, recruiting, coursework and thesis posting is forbidden.

Students Click Here

Microsoft: Office FAQ

Tips and Tricks

Using Linked Charts in PowerPoint Presentations by Garridon
Posted: 3 Apr 01

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.

Back to Microsoft: Office FAQ Index
Back to Microsoft: Office Forum

My Archive

Close Box

Join Tek-Tips® Today!

Join your peers on the Internet's largest technical computer professional community.
It's easy to join and it's free.

Here's Why Members Love Tek-Tips Forums:

Register now while it's still free!

Already a member? Close this window and log in.

Join Us             Close