Application.ChartDataPointTrack Property (Word)

Office 2013 and later

Contribute to this content

Use GitHub to suggest and submit changes. See our guidelines for contributing to VBA documentation.

Returns or sets a Boolean that specifies whether charts use cell-reference data-point tracking. Read-write.

expression .ChartDataPointTrack

expression A variable that represents a Application object.

In cell-reference data-point tracking, data labels track the cell reference that contains the value of the data point, rather than the index number of the data point. Doing so helps to preserve custom formatting applied by the user, even when a chart is sorted or filtered. Setting ChartDataPointTrack to True specifies that charts use cell-reference data-point tracking.