Office 2011 for Mac: Copying Excel Charts to Word or PowerPoint

If you're working with Office 2011 for Mac, you’ll be glad to know that it’s easy to move your charts from Excel to Word and PowerPoint. You can even create a chart directly in Word 2011 for Mac and PowerPoint 2011 for Mac. Easy is good!

The process of copying Excel charts into Word or PowerPoint is straightforward. Follow these steps:

  1. Make sure that Excel and the destination application (Word or PowerPoint) are open.

    In Excel, the currently open workbook needs to contain the chart you want to copy to Word or PowerPoint.

  2. Select the chart in Excel by clicking its border.

    The selection indicator is a thick, blue outline replacing the border.

  3. Copy the chart.

    Use any of the usual methods: Click the Copy button on the Standard toolbar, press Command-C, or choose Edit→Copy.

  4. Switch to the Microsoft Word document or PowerPoint presentation.

    Use the Dock or press Command-Tab.

  5. Paste the chart.

    Use any of the usual methods: Click the Paste button on the standard toolbar, press Command-V, or choose Edit→Paste.

  6. Click the small widget in the lower-right corner of the chart.

    A drop-down menu appears. The widget for Word is on the left, and the widget for PowerPoint is on the right.

    image0.jpg
  7. Choose how you want the chart to behave while it's living in your Word document or PowerPoint presentation:

    • Paste as Picture or Picture of Chart: Office converts your chart to a picture, and then pastes a picture of the chart into your document or presentation.

    • Excel Chart (Entire Workbook): Pastes a copy of the entire workbook as an embedded OLE (Object Linking and Embedding) object into the Word document or PowerPoint presentation, displaying the chart. Chart colors and fonts adopt document theme colors of the paste destination.

    • Chart (Linked to Data): This is the default option and pastes a chart object in your document or presentation. The data is linked to the Excel source workbook, which remains an independent Excel file. After updating the chart in Excel, in Word you refresh the chart by choosing Edit→Links→Update Links. PowerPoint links update automatically. Selecting the pasted chart in Word or PowerPoint activates the Charts and Format tabs on the Ribbon.

    • Keep Source Formatting: Word or PowerPoint doesn’t apply its existing document theme but instead retains Excel’s source colors and fonts.

    • Use Destination Theme: This is the default paste. The chart adopts the Word document or PowerPoint presentation’s theme.

  8. Click outside the drop-down list to close the widget.

blog comments powered by Disqus
Advertisement

Inside Dummies.com

Dummies.com Sweepstakes

Win $500. Easy.