Adding Charts and Excel Tables to eaDocX

Navigation:  eaDocX and Excel >

Adding Charts and Excel Tables to eaDocX

Previous pageReturn to chapter overviewNext page


In the section Creating Reports, you saw how to take EA data, pull it into an Excel worksheet, then produce charts.

But if you are using eaDocX to create documents, you don't want to have to send your readers a document AND and spreadsheet. You would have to make sure that the document and the spreadsheet were both up-to-date, with the same version of your EA model. If you have a one-off report, which will never be used again or updated, the a simple copy/paste from Excel to your eaDocX Word document will be OK.

However, if, as with other eaDocX documents, it WILL be updated and used again, then it would be much clearer to put the charts into the documents, and have everything update together. That way, eaDocX can do the work, and add version information as it would for a normal eaDocX document.

Creating an eaXL Section

If you have eaDocX Corporate Edition, then on the eaDocX | Insert | Report menu, you will have an additional option: Excel Report.

This allows you to add either a single Excel chart, or a single Excel Named Range. A named range is block of an Excel worksheet, to which you can give a name. It's a standard feature of Excel, but one you might not have used.

To add an eaXL Chart to your eaDocX Document:

1.Position your cursor in the eaDocX document, at a suitable place to add a section

2.Select eaDocX | Insert | Report | Excel Report



Choose Spreadsheet

'Find' to select the spreadsheet which contains the chart or named range you want to add

'Open' opens that spreadsheet, to see what it contains

Choose Chart or Named Range

eaXL will show you the Charts and Named Ranges which are available in the Excel spreadsheet you chose above

Formatting Options

This section lets you choose what the chart/range looks like

Chart Scaling (Charts only)

Allows you to reduce or increase the size of the chart  as it appears in the eaDocX Document.

Report Name

This will appear as a title, above the chart

Heading Level

Sets the heading level of the Report Name


Free-form text. This will appear immediately below the Report Name, using the inline, paragraph text word style


Tick this to make the whole eaDocX section appear in a Landscape-format page. This includes the Heading and figure number/description.

Use this where charts or tables are especially wide, and can't be scaled-down

Add figure number

Puts a sequential figure number - consistent with the figure numbers used for EA diagrams - underneath the chart or named range.

Uses the 'diagram style' word style

Figure title

Text which follows the Figure number.

If 'figure number' is not selected, this will not be shown.

Uses the 'diagram style' word style

Figure detail

Additional free-form text, added under the figure number and title.

If 'figure number' is not selected, this will not be shown.

Uses the 'diagram text' word style