DataLabels.Propagate method (Excel)

Enables you to take the contents and formatting of a single data label and apply it to every other data label in the series.

Syntax

expression.Propagate (Index)

expression A variable that represents a DataLabels object.

Parameters

Name	Required/Optional	Data type	Description
Index	Required	Variant	The index number of the data label to propagate.

Remarks

If the source data label supports fields that are incompatible with the destination data label, those fields will be inserted as their [FIELD NAME]. For example, if a data label on a pie series with a percentage field is propagated to a data label on a column chart, that percentage field will become an unresolved field showing [PERCENTAGE].

Note

Passing an argument of zero (0) resets the data labels to your current prototype.

Return value

VOID

Support and feedback

Have questions or feedback about Office VBA or this documentation? Please see Office VBA support and feedback for guidance about the ways you can receive support and provide feedback.