WORD - Merge an Excel chart or graph

You can merge an Excel chart, graph, or table into a Report Template.

 

Step 1

In your Excel document, highlight all the cells that comprise your table.

Highlighted cells

 

Step 2

Name your highlighted cells.

I named my highlighted cells, "MyExcelTbl"

 

Step 3

Hide the sheet.

Hiding the sheet

 

Step 4

Insert a bookmark called PreRender_Excel at the very beginning of your RT (Word document).

 

Step 5

Place the caret (cursor) at the position you would like your Excel chart or graph to appear at and add a bookmark called PreRender_Excel_ChartTitle where:

ChartTitle is the name you gave your Excel chart in Step 2.

 

Step 5

Upload your Excel document as a new Report Template.