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.
0 Comments