• Create BookmarkCreate Bookmark
  • Create Note or TagCreate Note or Tag
  • PrintPrint
Share this Page URL
Help

Chapter 23. Using Excel Data in Word and... > Using Excel Charts in Word Documents

Using Excel Charts in Word Documents

You can insert an Excel chart into a Word document by copying it from the Clipboard or by choosing Insert, Object in Word. If you paste an Excel chart from the Clipboard into your Word document, the chart arrives in picture format. The smart tag menu that appears gives you the option of switching to an embedded chart object or to a chart object linked to the source file.

As with an Excel table, you can choose Edit, Paste Special in Word to control the format in which your chart is pasted into Excel. If you copied your chart from a chart sheet in your Excel document, your format choices are Microsoft Excel Chart Object, Picture, Bitmap, and Picture (Enhanced Metafile). Pasting the Object format embeds the entire Excel document, not just the chart sheet, so this option has the potential to enlarge your Word document dramatically (particularly if your workbook includes a lot of information in addition to the chart you copied). The other three options generate pictures. The Picture format consumes the least amount of memory, but you should experiment to see which generates the most satisfactory image in your Word document. If you copy from an embedded chart (you must first select the chart's Chart Area to do this), the Picture and Bitmap options become unavailable.


PREVIEW

                                                                          

Not a subscriber?

Start A Free Trial


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