Adding a Target Line
A target line is a horizontal or vertical line drawn on the chart that generally denotes either an ideal value (goal or threshold) or representative value (average, minimum, etc.). Regions above and below the target value can be assigned independent colors.

To add a target line, follow the steps below:
1. Right-click the Chart, and select 'Properties' from the context menu. This opens the 'Chart Properties' dialog box.
2. Select the Advanced tab of the 'Properties' dialog box. In the 'Target Lines' panel, press the 'Add' button. This opens the 'Add Target' dialog box.
3. Select the Line option.
4. In the 'Field' menu, select the chart measure to which you want to add the target line.
5. In the 'Value' field, type a numerical value at which to place the target line for the selected measure, or choose one of the following options to compute the target value from the data: 'Average', 'Minimum', 'Maximum', 'Median', 'Sum'. (For example, select 'Average' to place the target line at the average value of the selected measure.)

6. (Optional) If you select one of the available target line computations ('Average', 'Minimum', etc.), enable the 'Entire Chart' option to compute the target value based on measure data from the entire chart. Disable the 'Entire Chart' option to compute the target value for each sub-chart based only on measure data from the same sub-chart.
The following illustration demonstrates the effect of the 'Entire Chart' setting ('Value' is set to 'Maximum' in both cases).

7. From the 'Label' menu, select one of the following label options:

a. Select 'Enter a Value' to type a custom label for the target line.
b. Select '(Target Value)' to insert the numerical value of the target line as the label.
c. Select '(Target Formula)' to insert the name of the computation method ('Average', 'Minimum', etc.) as the label, if applicable.
d. Select '(Field Name)' to insert the field name for the selected measure as the label; for example, “Sum(Total)”.
Note: The customized label supersedes any previous selection from the 'Label' menu.
8. (Optional) To further customize the label, press the 'Edit' button next to the 'Label' field. This opens a panel in which you can manually enter the label. Press the green 'Apply' button when you have finished entering the label.

If desired, you can add the target value, target formula, and field name into the label by inserting the corresponding codes ({0},{1},{2}) shown at the bottom of the panel. You can apply formats to the inserted values by using the same syntax for Custom Tooltip. Some examples are shown below:
{1} = {0,number,$#,##0} yeilds “Average = $383,485”
{1} of monthly {2} yeilds “Average of monthly Sum(Total)”
9. Select a 'Line Style' and 'Line Color' in which to display the target line.
10. (Optional) Select a 'Fill Above' color and 'Fill Below' color to fill the regions of the chart above and below the target line respectively.

11. Press 'OK' to close the 'Add Target' dialog box, and press 'OK' to close the 'Chart Properties' dialog box.
By default, the target line appears on the chart even if its value is greater than the largest data point. This may sometimes cause the data points on the chart to be compressed into a small region of the plot area, which makes the chart difficult to read. To correct this, turn off the 'Keep Element in Plot' option in the 'Plot Properties' dialog box. See Plot Property for more information.
See Also
Adding a Target Band, to demarcate a specified data region on the chart.
Adding a Statistical Measure, to display statistical measures on the chart.
| << Chart Properties: Advanced Tab | © 1996-2013 InetSoft Technology Corporation (v11.5) | Adding a Target Band >> |