xlsgen > overview > Chart data labels

The chart data labels are floating values associated to the data elements of series.

Here are the following properties of data labels interface :

• Data labels can be accessed either from the chart object (MainDataLabels property), or from a given series (SeriesDataLabels property). In which case, the changes apply to all series of the chart, or to only that series of the chart.
• When accessed through the series interface, data labels can be invididually customized. For instance, you can move or put the emphasis on a particular value.
• Data labels can be either the series name, values or data titles. And the color legend key can be displayed or not.
• Data labels can be individually governed by a formula instead of a flat value.
• Just like pretty much any other object, data labels support the common options.
• Data labels can be placed aside, outside or in other places wrt to the series, which provides a helpful mean to avoid data labels overlapping series themselves (a wellknown use for this is for all pie charts).

Then each individual data label has an interface with the following properties :

• common options.
• data label type and placement
• custom title. The title can be richly formatted.
• custom formula.

Code samples related to charts make an extensive use of those interfaces, especially sample code chart_custom_options.