User guide

Page 101

visualise | communicate | ENGAGE The InstantAtlas Excel Data Manager

g the InstantAtlas Area Profile Template User Guide

Figure 124

You can have multiple filters in a report (Figure 125). For example you

might add a second filter designed to group post code sectors with the

same political affiliation.

Figure 125

This would give you a filter menu in the report with two filters (Figure 126).

Figure 126

You can add as many filters as you wish. Filters can be geographic or

non-geographic.

E.5. The Datasheets

In addition to the ‘Geography and Filters’ worksheet, you must have at

least one datasheet in your workbook. Datasheets are where you enter the

actual data values that will ultimately be displayed in your report. A

worksheet becomes an active datasheet when its name starts with

‘iadatasheet’. To rename a worksheet in Excel, you simply right click on

the worksheet name and select ‘Rename’. You can put all of your data

values in one datasheet or spread them between two or more datasheets.

Your workbook can contain one or more active datasheets. Note that

worksheet names must be unique in Excel. So if your workbook contains

more than one active datasheet you could, for example, name them

iadatasheet1, iadatasheet2, iadatasheet3 and so on. The number of active