User guide

Page 103

visualise | communicate | ENGAGE The InstantAtlas Excel Data Manager

g the InstantAtlas Area Profile Template User Guide

In an Excel worksheet, one cell can be made to span a number of columns

by merging. You can merge cells in a spreadsheet by doing the following:

1. Select the cells you want to merge by clicking and dragging so that

they are highlighted

2. Right-click your selection

3. Choose Format Cells… from the context menu.

4. Click the Alignment tab

5. Tick the box labelled Merge cells

6. Click OK

Row 3

Row 3 is used to provide links to files of your choice. These are the files

that will open when the notes icon for an indicator or time period (lowest

hierarchy level) is clicked in the data explorer of a report (Figure 128). This

is usually used to link to indicator-related metadata. You can specify a

different link for each indicator or time period.

Figure 128

In the example workbook, ‘notes.htm’ has been entered for every indicator.

This means that when the notes button is clicked, a file called ‘notes.htm’

located in the report folder will open. You can type in any links you like

(Figure 129). The pathnames you enter can be absolute or relative. The

following image shows examples of some alternative links that you might

enter.

Figure 129