Inserting bookmarks in your Word Report Template
You can merge an Excel chart, graph, or table into a Report Template.
This enables your report template to call on that bookmark every time you generate your report.
In your Excel document, highlight all the cells that comprise your table.
(NB: This will be shown in your report template as per your Excel formatting, so make sure it looks great and fits your style.)
Name your highlighted cells.
I named my highlighted cells, "MyExcelTbl"
Hide the sheet.
Hiding the sheet
Insert a bookmark called PreRender_Excel at the very beginning of your RT (Word document).
Place the caret (cursor) at the position in your Word Report Template 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.
Remember to upload your Excel document as a new Report Template. If you do not do this step, your bookmark will not work.
Want to learn how to see your bookmarks clearly in Word? Here is an article showing you how to do that. Setting up Word to see your bookmarks clearly.