Insert an Excel Table for Charts

Enhance Word Document with Excel Table

  • Although Word tables allow you to apply some simple calculations by clicking on Formula in the Data group on the Layout tab, the formula will not automatically re-calculate when one of input number in the table changed. This can be easily lead to documents that have inaccurate data

  • Creating an Excel worksheet will help to keep the calculation to be accurate in Word document

 

Insert an Excel Table in Word Document

1.   From the Menu Bar, go to Insert menu > click Object…

2.   The Insert as Object dialog box will open, select the file you wish to open


3.   The information is added and if you move your mouse over the numbers you can see that it is an object

4.   Double click on the object and a Excel document with the information will be opened

5.   Any changes made in the Excel document will be reflected in the Word document