Excel for Microsoft 365 Word for Microsoft 365 Outlook for Microsoft 365 PowerPoint for Microsoft 365 Excel 2021 Word 2021 Outlook 2021 PowerPoint 2021 Excel 2019 Word 2019 Outlook 2019 PowerPoint 2019 Excel 2016 Word 2016 Outlook 2016 PowerPoint 2016 More...Less
If you want to use an Excel chart or Excel data in a PowerPoint presentation, a Word document, or an Outlook message, you can simply copy it in Excel, and then use the paste options in the other Office programs to insert the copied content in a number of ways.
Note:The tools for copying Excel data and charts are not available in Office Online. If you have a desktop version of Office, click Open in [Program Name] in your desktop program to open the document and follow the procedures described in this article. If you don’t have a desktop version of Office, you can try or buy the latest version now.
What would you like to copy?
-
In Excel, click the chart that you want to copy to another Office program, and then press Ctrl+C.
-
Open the other Office program, click where you want to paste the chart, and then press Ctrl+V.
-
Click the Paste Options button that appears next to the bottom of the chart, and choose how you want to paste it:
-
Use Destination Theme & Embed Workbook This updates the chart formatting to match the destination formatting.
-
Keep Source Formatting & Embed Workbook This keeps the chart formatting exactly as is.
-
Use Destination Theme & Link Data This updates the chart formatting to match the destination formatting and keeps the chart linked to the original worksheet. (If you later decide that you want to unlink the chart, you'll need to copy it and paste it again as an embedded chart or as a picture.) With the data linked to the original worksheet, the data in the Word document will update when the source Excel worksheet is updated.
-
Keep Source Formatting & Link DataThis keeps the chart formatting exactly as is and keeps the chart linked to the original worksheet. (If you later decide that you want to unlink the chart, you'll need to copy it and paste it again as an embedded chart or as a picture.) With the data linked to the original worksheet, the data in the Word document will update when the source Excel worksheet is updated.
-
Picture This pastes the chart as a picture. The chart cannot be edited or updated, but you can replace it with another picture and apply picture formatting.
-
-
In Excel, select the data you want to copy, and then press Ctrl+C.
-
Open the other Office program, click where you want to paste the data, and then press Ctrl+V.
-
Click Paste Options next to the data, and choose how you want to paste it.
-
Keep Source Formatting This keeps the data formatting exactly as is.
-
Use Destination Styles This updates the data formatting to match the destination style. If you want to keep the gridlines this is usually the best way to do it.
-
Link & Keep Source Formatting This keeps the data formatting exactly as is and keeps the data linked to the original worksheet. (If you later decide that you want to unlink the data, you'll need to copy it and paste it again as unlinked data or as a picture.) With the data linked to the original worksheet, the data in the Word document will update when the source Excel worksheet is updated.
-
Link & Use Destination Styles This updates the data formatting to match the destination style and keeps the data linked to the original worksheet. (If you later decide that you want to unlink the data, you'll need to copy it and paste it again as unlinked data or as a picture.) With the data linked to the original worksheet, the data in the Word document will update when the source Excel worksheet is updated.
-
Picture This pastes the data as a picture. The data cannot be edited or updated.
-
Keep Text Only This pastes the data as text, with each row in a separate paragraph and with tab spaces separating the cell values.
-
See also
-
Paste options
-
Mail merge using an Excel spreadsheet
-
Mail merge in PowerPoint
-
Create a chart from start to finish
-
Format elements of a chart
-
Save a workbook in another file format
Need more help?
Want more options?
Discover Community
Explore subscription benefits, browse training courses, learn how to secure your device, and more.
Microsoft 365 subscription benefits
Microsoft 365 training
Microsoft security
Accessibility center
Communities help you ask and answer questions, give feedback, and hear from experts with rich knowledge.
