Copy an Excel chart to a different Workplace program

Copy an Excel chart to a different Workplace program

If you wish to use an Excel chart that you simply created or Excel desk knowledge in a PowerPoint presentation, a Phrase doc, or an Outlook message, you possibly can merely copy it in Excel, after which use the paste choices within the different Workplace applications to insert the copied chart in a lot of methods.

Observe: The instruments for copying Excel knowledge and charts are usually not accessible in Workplace On-line. When you have a desktop model of Workplace, click on Open in [Program Name] in your desktop program to open the doc and comply with the procedures described on this article. If you do not have a desktop model of Workplace, you possibly can strive or purchase the most recent model now.

Newer variations Workplace 2007

What would you want to repeat?

Copy an Excel chart

  1. In Excel, click on the chart that you simply need to copy to a different Workplace program, after which press Ctrl+C.

  2. Open the opposite Workplace program, click on the place you need to paste the chart, after which press Ctrl+V.

  3. Click on the Paste Choices button that seems subsequent to the underside of the chart, and select the way you need to paste it:

    The paste options button in Word, expanded to show the options.

    • Use Vacation spot Theme & Embed Workbook This updates the chart formatting to match the vacation spot formatting.

    • Hold Supply Formatting & Embed Workbook This retains the chart formatting precisely as is.

    • Use Vacation spot Theme & Hyperlink Information This updates the chart formatting to match the vacation spot formatting and retains the chart linked to the unique worksheet. (When you later determine that you simply need to unlink the chart, you may want to repeat it and paste it once more as an embedded chart or as an image.) With the info linked to the unique worksheet, the info within the Phrase doc will replace when the supply Excel worksheet is up to date.

    • Hold Supply Formatting & Hyperlink Information This retains the chart formatting precisely as is and retains the chart linked to the unique worksheet. (When you later determine that you simply need to unlink the chart, you may want to repeat it and paste it once more as an embedded chart or as an image.) With the info linked to the unique worksheet, the info within the Phrase doc will replace when the supply Excel worksheet is up to date.

    • Image This pastes the chart as an image. The chart can’t be edited or up to date, however you possibly can exchange it with one other image and apply image formatting.

Copy Excel knowledge

  1. In Excel, choose the info you need to copy, after which press Ctrl+C.

  2. Open the opposite Workplace program, click on the place you need to paste the info, after which press Ctrl+V.

  3. Click on Paste Choices subsequent to the info, and select the way you need to paste it.

    The paste options button, next to some Excel data, expanded to show the options

    • Hold Supply Formatting This retains the info formatting precisely as is.

    • Use Vacation spot Kinds This updates the info formatting to match the vacation spot type.

    • Hyperlink & Hold Supply Formatting This retains the info formatting precisely as is and retains the info linked to the unique worksheet. (When you later determine that you simply need to unlink the info, you may want to repeat it and paste it once more as unlinked knowledge or as an image.) With the info linked to the unique worksheet, the info within the Phrase doc will replace when the supply Excel worksheet is up to date.

    • Hyperlink & Use Vacation spot Kinds This updates the info formatting to match the vacation spot type and retains the info linked to the unique worksheet. (When you later determine that you simply need to unlink the info, you may want to repeat it and paste it once more as unlinked knowledge or as an image.) With the info linked to the unique worksheet, the info within the Phrase doc will replace when the supply Excel worksheet is up to date.

    • Image This pastes the info as an image. The info can’t be edited or up to date.

    • Hold Textual content Solely This pastes the info as textual content, with every row in a separate paragraph and with tab areas separating the cell values.

What would you want to repeat?

Copy an Excel chart

  1. In Excel, click on the chart that you simply need to copy to a different Workplace program, after which press Ctrl+C.

  2. Open the opposite Workplace program, click on the place you need to paste the chart, after which press Ctrl+V.

  3. Click on Paste Choices Button image subsequent to the underside of the chart, and select the way you need to paste it:

    • To stick the chart with a hyperlink to its supply knowledge, click on Chart (linked to Excel knowledge). (When you later determine that you simply need to unlink the chart, you may want to repeat it and paste it once more as an embedded chart or as an image.)

    • To stick the chart and to incorporate entry to the entire workbook within the presentation, click on Excel Chart (complete workbook). (When you later determine that you simply need to unlink the chart, you may want to repeat it and paste it once more as an unlinked chart or as an image.)

    • To stick the chart as a static image, click on Paste as Image.

    • To stick the chart in its authentic format, click on Hold Supply Formatting.

    • To stick the chart and format it by utilizing the doc theme that’s utilized to the presentation, click on Use Vacation spot Theme.

Copy Excel knowledge

  1. In Excel, choose the info you need to copy, after which press Ctrl+C.

  2. Open the opposite Workplace program, click on the place you need to paste the info, after which press Ctrl+V.

  3. Click on Paste Choices Button image subsequent to the info, and select the way you need to paste it:

    In Phrase and Outlook

    • To stick the info as a desk and use the unique format of the copied knowledge, click on Hold Supply Formatting

    • To stick the info as a desk and use the type of the brand new vacation spot, click on Match Vacation spot Desk Fashion.

    • To stick the info as a static image, click on Paste as Image.

    • To stick a hyperlink to the Excel knowledge in order that the info in vacation spot file is up to date once you change the unique knowledge within the Excel workbook, click on Hold Supply Formatting and Hyperlink to Excel or Match Vacation spot Desk Fashion and Hyperlink to Excel. (When you later determine that you simply need to unlink the info, you may want to repeat it and paste it once more as an unlinked desk or as an image.)

    • To stick the info as textual content, with every row in a separate paragraph and with tab areas separating the cell values, click on Hold Textual content Solely.

    In PowerPoint

    • To make use of the unique format of the copied knowledge, click on Hold Supply Formatting.

    • To make use of the doc theme that’s utilized to the PowerPoint presentation, click on Use Vacation spot Theme.

    • To stick desk knowledge that you simply copied as textual content, click on Hold Textual content Solely.

Notes: 

  • When you do not see the Paste Choices button, you might have to show it on. Click on the Microsoft Workplace Button Office button image , after which click on Phrase Choices. Within the Superior class, underneath Reduce, Copy, and Paste, choose the Present Paste Choices buttons test field.

  • When you paste the info right into a Phrase or PowerPoint desk, the Paste Choices button shows completely different paste choices. You possibly can insert the copied knowledge as a nested desk, merge it with the present desk, insert it as new rows within the current desk, overwrite the cells within the current desk, or paste it as a static image.

See additionally

  • Paste Particular when copying from Excel

  • Create a chart from begin to end

  • Format parts of a chart

  • Join knowledge in one other workbook to your workbook

  • Save a workbook in one other file format

Leave a Reply