Allow formatting and labels to track data points

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.

Supported on: At least Windows 7

Registry HiveHKEY_CURRENT_USER
Registry Pathsoftware\policies\microsoft\office\16.0\excel\options
Value Namecharttrackingrefbased
Value TypeREG_DWORD
Enabled Value1
Disabled Value0

excel16.admx

Administrative Templates (Computers)

Administrative Templates (Users)