User guide

© GeoWise Ltd. 2011
Page 112
visualise | communicate | ENGAGE The InstantAtlas Excel Data Manager
g the InstantAtlas Area Profile Template User Guide
© GeoWise Ltd. 2013
E.6.2.4. Setting the Chart Axis Minimum and Maximum
By default the bar chart and time series chart adjust their minimum and
maximum depending on the data the chart shows. This might not be
suitable e.g. when using a time animation. To set the chart minimum and
maximum to a fixed value for each theme or indicator you can use the
metadata elements ‘minChartValue’ and ‘maxChartValue’ (Figure 138).
Figure 138
Please note that these two properties are depended on each other
which means you can only use them together. Just setting the
‘maxChartValue’ without having the ‘minChartValue’ defined will not have
any effect.
If your indicator names are not unique, you can address this by adding the
theme name in front of the indicator name in column B. Both must be
separated by a pipe symbol, e.g. ‘Theme 1|Male’.
E.6.2.5. Setting Data Table Column Aliases
For each individual theme, indicator or time period, you can define the
column aliases that will be displayed in the data table. By default, the
report will display the global alias settings defined in the data table
properties in the config.xml file. If you wish the column headers to be
different for different themes/indicators/time periods, you can overwrite the
global settings from the config.xml file. To do this, define the columns
headings by using the metadata element ‘alias_indicator’ for the indicator
column heading and ‘alias_{associateName}’ for associate column
headings. Figure 139 shows an example for both cases.
Figure 139
If your indicator names are not unique, you can address this by adding the
theme name in front of the indicator name in column B. Both must be
separated by a pipe symbol, e.g. ‘Theme 1|Male’.
Please note that it is currently not possible to change the aliases of
columns containing the confidence limits ‘ul’ and ‘ll’. Also this functionality
is not supported for the Double Map Template
E.6.2.6. Defining Additional Data Table Columns
It is also possible to define on a theme, indicator or time period basis
additional data table columns. You should define all columns which will be
displayed for all themes, indicators and time periods globally in the data
table properties in the config.xml file. Additional columns, which are
specific for one or more of the themes/indicators/time periods, can then be
Defining table column aliases on a theme, indicator or time period
basis in HTML reports is only possible through completely re-
defining the table columns, see E.6.2.6. Defining Additional Data
Table Columns’.