Reference Line Label Format Properties

Use the Reference Line Label Format dialog box to define line label (plot area) and legend text properties.

Table 42. Reference Line Label Format Properties

PropertyDescription
(Text Format for Plot Area or Legend)Formats text for the plot area or legend from the drop-down.

If the “Use the same format in plot area and legend field” is enabled, this option is disabled.

(Custom Format)Specify a custom format for the plot area or legend.

A custom format can combine constant text and generated strings for a statistical function or the value of the reference line.

Constant text accepts the following tags:

  • [FC]—fact name

  • [VL]—value of reference line.

For example, the custom format: “Expected sales = [VL]” could return the results in the label or legend: “Expected sales = $26300000”. If the text for a tag cannot be generated (for example, the format is for an [FN] tag on an axis based reference line), the tag resolves in an empty string, and it is removed.

A custom format can include complex tags combining arbitrary text with one or more simple (and even complex) tags. A complex tag is bounded by curly braces ({}), for example, “{Sales [FN] = }[VL]”. If at least one of the tags inside the complex tag cannot be resolved, all complex tags result in an empty string.

A fact based reference line using the format above might be resolved in a“Sales Average = $126000” string, and for an axis based reference line it could be resolved in a “$126000” string.

The special delimiter tag, [DL] is available. This tag inserts a space in the resulting string if both the left and right tags are successfully resolved.

The complex tag, {; [DL] }inserts custom text as a delimiter. For example, the format “{[FN]([FC])}{ = [DL]}[VL]” may result in one of the following strings depending on conditions:

  • Average(Sales)

  • Average(sales) = $126000

Auto formatThe following Default, Function and Value fields can be enabled to reset the label text to auto-generated text on the line. Each field adds predefined tags to the text format. If no auto-format is enabled you can enter a custom format in the edit box.
DefaultShow the default text: “<Function name>(<Fact name>) = <Value>”
FunctionShows the statistical function in auto-generated text, for example: Average.
ValueShows the value of the reference line, for example: Value = 0.7348.