Policy
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.
d2d40dfc09bc L_ChartRefTrackingEnabled Registry
Copy registry mappings
HKCU\software\policies\microsoft\office\16.0\excel\options\charttrackingrefbased (enabled) = 1
HKCU\software\policies\microsoft\office\16.0\excel\options\charttrackingrefbased (disabled) = 0Policy notes
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.