Skip Navigation

Darton State College

Darton State College

Home  » Office of Information Technology

Helpful Hints

Linking Word, Excel, and Power Point:

  1. Open the Word file "Link file"
  2. Open the Excel file "Charts"
  3. Select cell F10 on the Chart Data worksheet, it is the total sales for all quarters
  4. Copy the cell
  5. Switch to the Word "Link file"
  6. Place the insertion point in front of the period for the first sentence
  7. Paste the annual total
  8. Switch back to the Excel spreadsheet
  9. Press the "Esc" key
  10. Select "chart all quarters"
  11. Click you mouse in the white chart area
  12. Copy the selected chart
  13. Switch to the Word "Link file"
  14. Place the insertion point a couple of lines below the text
  15. Select "Edit" from the menu
  16. Select "Paste Special"
  17. Select "Past Link" and "Excel Chart Object"
  18. Click "OK"
  19. Switch back to the Excel spreadsheet
  20. Press the "Esc" key
  21. Select cell C6 (Quarter 2 for Main)
  22. Type 10,000
  23. Switch to the Word "Link file"
    Notice that the chart reflects the change, but the total in the first sentence does not. For automatic updates, you must use the "Edit" "Past Special" with "Past Link"
  24. Save the file