how to plot a graph in excel 2016 from a table

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.

If you are looking for a comprehensive guide to all things Excel, view our Excel Course offerings here.ĭifference Between Cutting And Embedding An Excel Chart Most importantly, when you change them in Excel, they will change in your Word document automatically without you needing to update them! This will work with excel charts and tables.

This guide uses the most current versions of Microsoft Office (2019) but works with Excel 2016 and Word 2016.

Instead of using the Insert Tab and creating a chart straight into word, this guide will have you put the charts from your own Excel workbook straight into Microsoft Word. This tutorial will show you how to embed your Excel Chart straight into a Word Document.

How to plot a graph in excel 2016 from a table