Display Labels of Data Points

<< Click to Display Table of Contents >>

Navigation:  Professional > Tools & Charts > XY Charts >

Display Labels of Data Points

Follow the steps below to display data point labels.

 

1.Create the Line Chart.

2.Click Turn On/Off Current Chart Editor tool xy_chart_editor_tool. Click the Edit Style tool xy_chart_editor_edit_style_tool on the Chart Editor toolbar and select a chart series to be edited.

 

xy.edit_style

 

3.Select Text in the Chart Series Style window. Check Display Text and click OK. The Y axis values are displayed as the labels at the data points (see two images at end of this article).

 

xy.edit_style_displayText

 

Notes:

To adjust the font and positions etc. of the labels, modify the properties under Font and Text (see image above).

The highlighted label (70.74) indicates a duplicated value (see image below).

Adding chart labels is conducted to one chart series of the active chart at a time.

Data point labels are not supported in Excel exports, but are included in image file exports.

 

xy.edit_style_displayText_2

 

xy.edit_label