Targets

The Target screen is used to add target areas or target lines to a chart. These can be a useful way of visualising whether a value is achieving the performance expected.

Click the ‘Targets’ menu at the top of the ‘Edit chart’ screen.

To add a Target, click the ‘Add’ icon beneath the colour palette.

The Target can represent a range of numbers for example, 100 to 200 or can represent a single value e.g., 100. If you specify a different number in the From and To fields, a target area, similar to an Area chart, will be created on the chart. If you specify the same value in the From and To fields, a target line will be created on the chart, similar to a Line chart. 

The drop-down arrows in the From and To sections are used to choose how the Target is displayed.

Value - this allows you to specify a figure that you want to use as the target, type the value that you want to use next to the Value drop-down arrow the maximum value of the bars in the chart, the maximum value will be calculated based on the data values in the chart. You can set the target to be a single line on the Max amount by choosing Max in both the From and To fields or you can use Max in either the From or To fields and choose another option, e.g., Value in the remaining field to create a target area.

Min - this allows you to select the minimum value of the bars in the chart. You can set the target to be a single line on the Min amount by choosing Min in both the From and To fields or you can use Min in either the From or To fields and choose another option, e.g., Value in the remaining field to create a target area.

Avg - the AVG field will work out the average value based on the information in the chart and apply a target at that point. If you only want a single line to appear on the average value, ensure that you select AVG in both the From and To fields

Positive Infinity - This option will extend the target line to the very top of the chart

Negative Infinity - This option will extend the target line to the very bottom of the chart 

Have a look at our video on Target Lines.