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.
Registry Hive | HKEY_CURRENT_USER |
Registry Path | software\policies\microsoft\office\16.0\excel\options |
Value Name | charttrackingrefbased |
Value Type | REG_DWORD |
Enabled Value | 1 |
Disabled Value | 0 |