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

WORD AND EXCEL

Keep an Excel Chart Updated in a Word Document

The Annoyance:

My department keeps its production data in an Excel spreadsheet with a chart that gives a quick idea of how things are going. I need to put that chart in our Monday-and-Thursday report for a visual update. So far, I've been copying the chart and pasting it into the Word document. This works fine, but it means that to make sure it's up to date, I need to paste in the chart about five seconds before I print the document—which feels more than a little tense.

The Fix:

It sounds as though you'd do better to link the chart to your report template. Each time you create a new report based on the template, it'll pull in the latest version of the chart. Follow these general steps:


PREVIEW

                                                                          

Not a subscriber?

Start A Free Trial


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