Please Note: This article is written for users of the following Microsoft Excel versions: 2007, 2010, and 2013. If you are using an earlier version (Excel 2003 or earlier), this tip may not work for you. For a version of this tip written specifically for earlier versions of Excel, click here: Embedding an Excel Chart in a Word Document.
Most of the time, Microsoft Office applications work fairly well together. For instance, you might be creating a report for a presentation, and you need to include a chart along with the report. Fortunately, you can embed an Excel chart directly within a report you happen to be creating in Word. This is done in the following manner:
Figure 1. The Paste Special dialog box in Word.
ExcelTips is your source for cost-effective Microsoft Excel training. This tip (10427) applies to Microsoft Excel 2007, 2010, and 2013. You can find a version of this tip for the older menu interface of Excel here: Embedding an Excel Chart in a Word Document.
Solve Real Business Problems Master business modeling and analysis techniques with Excel and transform data into bottom-line results. This hands-on, scenario-focused guide shows you how to use the latest Excel tools to integrate data from multiple tables. Check out Microsoft Excel 2013 Data Analysis and Business Modeling today!
Charts can either be embedded in a worksheet or take up an entire sheet by themselves. Changing from one type of chart to ...
Discover MoreFiguring out how to get the data points in an X-Y scatter plot labeled can be confusing; Excel certainly doesn't make it ...
Discover MoreWant the title of your chart to change based upon what is placed in a worksheet cell? It's easy; just add a formula to ...
Discover MoreFREE SERVICE: Get tips like this every week in ExcelTips, a free productivity newsletter. Enter your address and click "Subscribe."
2018-03-26 04:32:59
Neil
If you want to paste in a report that you regularly update (say a monthly report) then is better to use "Paste Link" and the desired format. This is simply a matter of right clicking on the object(s) to do an update. Have been doing this for years very effectively.
2014-09-24 05:54:27
Richard
What an excellent tip! I had previously accepted the default type by clicking Paste, and wondered why I had to Paste again when the chart changed. Thanks.
2014-09-20 04:56:54
Chris Buchanan
Hi. I've done this so many times. However, it's not a picture: you can double click it and then alter it. The only to make sure it's a picture is to use the Word picture Paste Option (in 2013, 5th one along)
Got a version of Excel that uses the ribbon interface (Excel 2007 or later)? This site is for you! If you use an earlier version of Excel, visit our ExcelTips site focusing on the menu interface.
FREE SERVICE: Get tips like this every week in ExcelTips, a free productivity newsletter. Enter your address and click "Subscribe."
Copyright © 2019 Sharon Parq Associates, Inc.
Please Note:
This article is written for users of the following Microsoft Excel versions: 2007, 2010, and 2013. If you are using an earlier version (Excel 2003 or earlier), this tip may not work for you. For a version of this tip written specifically for earlier versions of Excel, click here: 
Comments