A template is a wildcard that shows values, name, number and other parameters of a chart component.
Templates are used in:
Data labels of a series point, all points of a series, all points on a chart.
Tooltips for all chart points (except for the %Data template).
To set up label text using a template, click the Template button next to the Text, Tooltip Text or Label box.
Text Templates | Definition |
%Autovalue | Auto format of the value (set by default).
|
%Value | Point value. |
%XValue | X axis point value. |
%YValue | Y axis point value. |
%Part | Stacked value. |
%Percent | Percent shares are ratio of the series point value to sum of values for this point in all series, shown as a percentage. |
%PercentHundredth | Shares are the ratio of the point value to the sum of values of this point over all the series. |
%PercentPart | Stacked parts in percents. |
%PercentPartHundredth | Stacked parts. |
%Data | Custom data format. The format can be set up only using the Fore language. |
%SerieName | Series name. |
%SerieNo | Series number. |
%PointName | Point name. NOTE. If the Source Data dialog box has configured display of points on the category axis, on applying the %PointName template, data labels are shown only for selected points. |
%PointNo | Point number. |
%Computation | Function type in level line label. NOTE. The template is available only for level line label. |
See also:
Data Labels | Tooltips | Setting Up General Chart Parameters | Setting Up Chart Components