Friday, May 24, 2013

How to Link an Excel 2007 Chart to a PowerPoint 2007


Prepare Your Chart in Excel 2007
1. Open the spreadsheet containing your chart in Excel 2007.
2. Click the chart to select it and then press the 'Ctrl' and 'C' keys simultaneously to copy the chart to the clipboard.
3. Select a blank sheet using the tabs near the bottom of the Excel 2007 window.
4. Press the 'Ctrl' and 'V' keys simultaneously to paste the copied chart into the selected sheet.
5. Save the spreadsheet to confirm the changes.
Link Excel 2007 Chart in PowerPoint 2007
6. Open your presentation in PowerPoint 2007 and then navigate to the slide where you want the chart inserted. If you want to insert the chart within a text box, select the box by clicking it.
7. Select the 'Insert' tab and then click the 'Object' button.
8. Select the 'Create from file' option on the left side of the window.
9. Click the 'Browse' button, locate your Excel 2007 spreadsheet in the resulting window and select it by double clicking its icon.
10. Check the 'Link' box and then click 'OK.'

Blogger news