Allow formatting and labels to track data points
| Registry value | charttrackingrefbased |
| Group Policy | Allow formatting and labels to track data points |
| German version | Formatierung und Beschriftungen zum Nachverfolgen von Datenpunkten zulassen |
| Intune settings catalog | Allow formatting and labels to track data points (User) |
| Scope | User · HKCU |
| ADMX | excel16.admx · L_ChartRefTrackingEnabled |
Group Policy path
Registry
| Value | Data |
|---|---|
HKCU\Software\policies\microsoft\office\16.0\excel\options | |
| charttrackingrefbased | Enabled = 1 · Disabled = 0 |
Not configured = the value does not exist – the application default applies and users may change the setting.
PowerShell
Check the current value (read-only)
# --- Settings ---
$root = 'HKCU:' # other signed-in user (elevated): 'Registry::HKEY_USERS\<SID>'
$key = "$root\Software\policies\microsoft\office\16.0\excel\options"
foreach ($name in @('charttrackingrefbased')) {
try { '{0} = {1}' -f $name, (Get-ItemPropertyValue -Path $key -Name $name -ErrorAction Stop) }
catch { '{0}: not configured' -f $name }
}Admin rights needed: HKCU\Software\Policies is read-only for standard users. An elevated session writes to the admin's own HKCU – to set it for another signed-in user, change $root to Registry::HKEY_USERS\<SID>.
Enable
# --- Settings ---
$root = 'HKCU:' # other signed-in user (elevated): 'Registry::HKEY_USERS\<SID>'
try {
$key = "$root\Software\policies\microsoft\office\16.0\excel\options"
if (-not (Test-Path $key)) { New-Item -Path $key -Force -ErrorAction Stop | Out-Null }
New-ItemProperty -Path $key -Name 'charttrackingrefbased' -PropertyType DWord -Value 1 -Force -ErrorAction Stop | Out-Null # Enabled
'Done.'
}
catch { Write-Error "Failed: $($_.Exception.Message)" }Disable
# --- Settings ---
$root = 'HKCU:' # other signed-in user (elevated): 'Registry::HKEY_USERS\<SID>'
try {
$key = "$root\Software\policies\microsoft\office\16.0\excel\options"
if (-not (Test-Path $key)) { New-Item -Path $key -Force -ErrorAction Stop | Out-Null }
New-ItemProperty -Path $key -Name 'charttrackingrefbased' -PropertyType DWord -Value 0 -Force -ErrorAction Stop | Out-Null # Disabled
'Done.'
}
catch { Write-Error "Failed: $($_.Exception.Message)" }Reset to Not configured
# --- Settings --- $root = 'HKCU:' # other signed-in user (elevated): 'Registry::HKEY_USERS\<SID>' $key = "$root\Software\policies\microsoft\office\16.0\excel\options" Remove-ItemProperty -Path $key -Name 'charttrackingrefbased' -ErrorAction SilentlyContinue 'Policy values removed (Not configured).'
Intune (settings catalog)
Allow formatting and labels to track data points (User)
Settings catalog → Add settings → search for the name above.
Intune Settings Catalog Viewer ↗
Alternative: custom profile (OMA-URI)
| OMA-URI | ./User/Vendor/MSFT/Policy/Config/excel16v2~Policy~L_MicrosoftOfficeExcel~L_ExcelOptions~L_Advanced/L_ChartRefTrackingEnabled |
| Data type | String |
| Value | <enabled/> · <disabled/> |
Cloud Policy
Cloud Policy (config.office.com → Customization → Policy Management) offers many user policies of the Microsoft 365 Apps – search for Allow formatting and labels to track data points. It also applies to unmanaged devices and wins over GPO and Intune for the same setting.
Microsoft explanation
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.
Same category: Microsoft Excel 2016 › Excel Options › Advanced
- Number of folders in the Recent Folders listmax display
- Default sheet directiondefaultsheetr2l
- Cursor movementcursorvisual
- Show control characterscontrolcharacters
- Microsoft Excel menu or Help keymenukey
- Transition navigation keysfisi_33_1
- Ignore other applicationsfddeenabled_6_1
- Zoom on roll with IntelliMousefrollzoom_98_1
- Show namesfshowchartnames_96_1
- Show valuesfshowcharttipvalues_97_1
- Edit directly in cellfnoincell_66_1
- Enable fill handle and cell drag-and-dropfdisabledman_36_1
All policies in this category · All 173 policies of excel16.admx