MICROSOFT WORD SET UP A GRAPH HOW TO
MICROSOFT WORD SET UP A GRAPH UPDATE

If you want to learn about linking Excel files with your emails, read our guide on how to send an excel file in outlook.Įmbedding an Excel Chart dynamically is a great tool for anyone working with Excel frequently. Using this skill you can start putting any relevant excel chart in a word document! Good use of this will make your word documents more dynamic – as there will be no need to change data manually. The Excel file and Word document are linked, so once you change the original Excel file, the Word file automatically update! If it does not change you can also double click on it and change it manually.

MICROSOFT WORD SET UP A GRAPH UPDATE

The best part of this is when you update the original Excel spreadsheet. Then you need to select it as a Microsoft Excel Worksheet Object and click Ok as shown below.Īnd just like that, you should have an embedded chart or table in a Word document! On the left of this window, you will see two options: Paste and Paste Link. Once you click Paste Special, a dialog box will appear. In the menu that comes down, select the Paste Special option.

Now go to the home ribbon and click on the down arrow next to the paste option. Next, you need to open up the Word document you want to link it to and click where you want the Excel chart to go. When you locate the table, you need to select the area you would like to link to another document and right-click and copy it. If you are expanding your Excel knowledge, why not read our article on How To Use Macros In Excel here.Įmbed An Excel Chart To Your Word Document – Step By Stepįirst of all, you need to open up an Excel workbook and find a table that you would like to put into another document. For example if you are presenting monthly sales, you wont have to copy the chart every time you need the statistics updated – and your presentation process will be streamlined. This is best used when the chart might change. – This is a more complicated way to get your chart through to Word. However when you want the chart to show up on the document, and you need it to change, you can Embed the chart instead. For example, if you are just creating a one time use document, and need data from one days worth of statistics, this method is ideal. – This is a simple way to implement your chart, and ideal for a static chart. When you want to take an Excel chart from your Excel Worksheet, and place it into a Word document, you can just screenshot the chart and place it within the Word document that way. The key difference is Embedding a chart allows the chart to automatically update, while cutting does not. Embed An Excel Chart To Your Word Document – Step By Stepĭifference Between Cutting And Embedding An Excel Chart.Difference Between Cutting And Embedding An Excel Chart.

Microsoft word set up a graph