Allow formatting and labels to track data points

Supported on: At least Windows Server 2008 R2 or Windows 7

Registry

HKCU software\policies\microsoft\office\16.0\excel\options

Value name: charttrackingrefbased

Enabled: charttrackingrefbased = 1

Disabled: charttrackingrefbased = 0

Description

This policy setting governs how custom formatting and data labels react to data changes in a chart. If you enable or do not configure this policy setting, when the user creates a new workbook, custom formatting and data labels follow data points as they move or change in any chart in the workbook. If you disable this policy setting, custom formatting and data labels do not follow data points, but instead follow data point indices.