Selecting the Data to Label

23.08.2021

1.If the diagram is in a document or a worksheet, double-click on the diagram to open it.

2.Double-click on the curve or its axis label.

3.Click on the Data Labeling tab of the Properties dialog box.

4.In the Fields list, select the items of the data points to be used for labeling.

5.If you choose a field which refers to an additional data set, specify the name of the data set in the Data Set field from which the data to be labeled should originate.

6.In the Text field, arrange the fields as desired and, if necessary, enter additional text that you want displayed in each data label.

7.Select for the Placement mode Relative and in the Start at field, enter the index of the first data point for which a label is to be added. In the Spacing field, specify a spacing for each data point where a label is to be displayed. If you choose Absolute as Placement mode, in the Number field enter the desired number of labels. In the Start at field, enter the position of the first label as a percentage of the distance resulting from the total number.

See Also

Curve

Share article or send as email:

You might be interested in these articles