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