As in this case you are not providing an associate with the % diff values, you should change the Bar Data<\/strong> property to ‘value’ (or a relevant associate column name). The same column will be used for the comparison feature.<\/p>\n If the new property is filled with a valid comparison ID, the percentage difference values will be calculated using the following formula:<\/p>\n 100 * ((base area indicator value \u2013 comparator value) \/ comparator value)<\/p>\n It is currently not possible to display the calculated % diff values as numbers in a separate column of the Spine Chart.<\/p>\n The default setting of the Spine Chart is still to use an associate called ‘diff’ as the data source for the horizontal bars. This allows the administrator to calculate those values in a different way.<\/p>\n Each target in the Spine Chart properties in the config.xml file has gained a setting called Target X<\/em> Use Comparison Feature <\/strong>(where X<\/em> is the number of the target 1-4). If you enter the code of a comparison area (without the # character), the position of the defined target symbol will be determined by the values of this comparison feature rather than by an associate of the selected base feature.<\/p>\n In most cases, administrators will want the indicator value of the comparison feature to be used rather than an associate value, hence you should enter ‘value’ into the Target X<\/em> Data<\/strong> property (where X<\/em> is the number of the target 1-4). Alternatively, you can pick up associate values of the specified comparison feature. In this case enter the name of the associate column you wish to use.<\/p>\n The Heath Profile configuration can make use of the previous enhancement (see Comparison values shown as targets<\/a>) and utilise a target fed from a comparison feature as the average line around which the shaded ranges are centred.<\/p>\n Additional to setting up the target as described above, the health profile needs to be informed about which comparison feature is to be used for centring the shaded ranges. This is done using an additional parameter in the health(…)<\/strong> function that defines the content of this column:<\/p>\n health(symbolValue:significance,areaValue:value,nationalValue:value,comparisonFeature:national<\/strong>)<\/p>\n As of version 6.10.0 it is possible to include a comparison area into the Spine Chart table as a column, so the national comparison feature can be added to the table by entering its code into the Name<\/strong> column of the Data Columns<\/strong> section in the Spine Chart properties in the Designer.<\/p>\n This is now the new default setup of the Health Profile configuration. Customers of InstantAtlas can download a matching example Excel workbook from here<\/a> (you will be asked to login using your Resource Library account credentials). After upgrading, this Excel workbook can also be found in the installation directory of the InstantAtlas Desktop software in a subfolder called workbooks.<\/p>\n When a minimum and maximum is defined for the y-axis of a chart (using minChartValue and maxChartValue in the Metadata), the values displayed in between the minimum and maximum will be – as much as possible – rounded values, depending on the data and the minimum and maximum values provided.<\/p>\n The image below shows an example of this improvement:<\/p>\n This means that the defined minumum and maximum values might not be part of the axis labels. If it is required to show the actual minimum and maximum values as labels, the property Match Axis to Data?<\/strong> can be used to force this.<\/p>\n For the Bar Chart, if zero is not part of the y-axis labels and hence does not have a horizontal grid line in the chart, a thin, light grey line is now drawn to show the zero position. This is beneficial when plotting positive and negative values in the chart.<\/p>\n![\"\"](\"https:\/\/help.instantatlas.com\/instantatlas-desktop\/wp-content\/uploads\/sites\/31\/2019\/09\/ExcelSpine.png\")
<\/a><\/p>\n<\/a><\/p>\nComparison values shown as targets<\/h3>\n
<\/a><\/p>\n<\/a><\/p>\nHealth Profile: Use comparison values as the centred average line<\/h3>\n
<\/a><\/p>\n<\/a><\/p>\nChart improvements<\/h2>\n
<\/a><\/p>\n