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.
Feedback
Coming soon: Throughout 2024 we will be phasing out GitHub Issues as the feedback mechanism for content and replacing it with a new feedback system. For more information see: https://aka.ms/ContentUserFeedback.
Submit and view feedback for