Data Labels

After creating a chart, you can change the data labels or their attributes, or add data labels.

 

Using Special Keywords

You can embed special keywords in the DataLabel Text or ToolTipText properties to access chart data such as the coordinates of a data point. The table below lists the keywords available:

 

Keyword

Description

#TEXT

Text property value of chart element.

#XVAL

X data coordinate.

#YVAL

Y data coordinate.

#Y1VAL

Y1 data coordinate.

#Y2VAL

Y2 data coordinate.

#Y3VAL

Y3 data coordinate.

#ISERIES

Data series index.

#IPOINT

Data point index.

 

The keywords are case-sensitive and should be placed in curly brackets. You may include a colon and a standard format string after the keyword. The Visible property must be set to True.

For example:

 

Tooltip = "X={#XVAL}, Y={#YVAL:F2}";

Tooltip = "Series = {#TEXT}; Point = {#XVAL} Value = {#YVAL}";

 

datalabel1

 

 

 

Using Label Collection Editor

 

datalabel2

 

 

 

 

datalabel3