User guide

© GeoWise Ltd. 2011
Page 92
visualise | communicate | ENGAGE The InstantAtlas Excel Data Manager
g the InstantAtlas Area Profile Template User Guide
© GeoWise Ltd. 2013
E
E
.
.
T
T
H
H
E
E
I
I
N
N
S
S
T
T
A
A
N
N
T
T
A
A
T
T
L
L
A
A
S
S
E
E
X
X
C
C
E
E
L
L
D
D
A
A
T
T
A
A
M
M
A
A
N
N
A
A
G
G
E
E
R
R
E.1. About this Section .................................................................................................................. 94
E.2. The Excel Add-in .................................................................................................................... 94
E.3. The Excel Workbook .............................................................................................................. 97
E.4. The Geography and Filters Worksheet .................................................................................. 98
E.4.1. Entering Codes (Column A) ........................................................................................... 98
E.4.2. Entering Names (Column B) .......................................................................................... 99
E.4.3. Entering Links (Column C) ............................................................................................. 99
E.4.4. Entering Filter Information (Columns D Onwards) ....................................................... 100
E.5. The Datasheets .................................................................................................................... 101
E.5.1. Entering Indicators ....................................................................................................... 102
E.5.1.1. Entering Codes (Column A) ................................................................................. 102
E.5.1.2. Entering Names (Column B) ................................................................................ 102
E.5.1.3. Entering Indicator Values (Columns C Onwards) ................................................ 102
E.5.2. Entering Associate Values ........................................................................................... 106
E.6. The Metadata Worksheet .................................................................................................... 107
E.6.1. Adding Metatext ........................................................................................................... 107
E.6.2. Adding Indicator Display Metadata .............................................................................. 108
E.6.2.1. Setting the Precision for Indicators and Associates............................................. 109
E.6.2.2. Setting a Data Type for Associates ..................................................................... 110
E.6.2.3. Setting Custom Legends ...................................................................................... 110
E.6.2.4. Setting the Chart Axis Minimum and Maximum ................................................... 112
E.6.2.5. Setting Data Table Column Aliases ..................................................................... 112