Chart & Visualization Issues

Fix Excel Sunburst Chart Label Settings Disabled Issue

John Wilson Oct 9, 2026 871 views

Question details

Users are unable to modify individual data labels and text boxes when working with sunburst charts in Excel.

How to Fix Disabled Label Settings in Excel Sunburst Charts

Product: Excel for Microsoft 365
Device & OS: not provided
Scenario: Attempting to customize data labels and apply specific formatting to a newly created sunburst chart.
Observed behavior: Individual label formatting options and text-box settings are entirely disabled or grayed out.

Before you start

Verify that your Microsoft 365 subscription is active and ensure that the worksheet containing your sunburst chart is not currently password-protected.

Solution 1Recommended

Change to a Supported Chart Type

Convert the sunburst chart to a sector chart or another supported type to unlock advanced individual label settings.

Microsoft Excel natively limits the customization of individual data labels and text boxes within Sunburst charts. To access these specific formatting features, you need to change your visual to a different chart type that supports them.

Select your chart

Click anywhere on the existing sunburst chart to reveal the Chart Design tools on the top ribbon.

Change the chart type

Navigate to the 'Chart Design' tab and click on the 'Change Chart Type' button located on the right side of the toolbar.

Select a sector chart

Choose a 'Pie' or 'Doughnut' chart from the list of available options, then click 'OK' to apply the change.

Format your labels

Right-click the specific data labels in your newly formatted chart and select 'Format Data Labels' to access the previously disabled settings.

Design Limitations: Certain hierarchical charts like Sunburst and Treemap have fixed layout algorithms, which is why manual text-box adjustments are restricted.

Solution 2

Disable Worksheet Protection

Remove worksheet protection that might be globally blocking object and chart formatting.

Solution 3

Reset Chart Formatting and Update Excel

Clear corrupted formatting states and ensure your Excel application has the latest feature patches.

Free Microsoft Office alternative

Create and Customize Complex Charts with WPS Office

If you frequently encounter formatting limitations in Microsoft Excel, try WPS Office. It is a highly compatible, free, and lightweight Office suite that provides excellent data visualization tools without restrictive chart formatting issues.

1. Download and Install: Get WPS Office for free from the official website and easily install it on your device.
2. Open Your Spreadsheet: Launch WPS Spreadsheet and open your existing .xlsx workbook.
3. Customize Your Charts: Select your data, go to the Insert tab, insert your preferred chart, and freely customize your data labels.

Fully compatible with Microsoft Excel (.xlsx) file formatsExtensive chart library with highly customizable data labelsLightweight application design that runs smoothly on most devicesFamiliar user interface requires no learning curve for smooth migration

microsoft office alternative - wps office

Frequently Asked Questions

Why are data labels grayed out on my Excel Sunburst chart?

Microsoft Excel natively restricts individual label formatting and text-box modifications for Sunburst charts to maintain the integrity of their hierarchical visual layout. The options are grayed out by design.

Can I format individual text boxes in a Sunburst chart?

No, individual text-box settings are typically unavailable for Sunburst charts in Microsoft 365. You must temporarily convert the visual to a supported chart type, such as a pie chart, to enable those settings.

Does worksheet protection affect chart formatting?

Yes. If your worksheet is protected, most chart formatting and object manipulation options will be completely disabled. You can regain access by navigating to the Review tab and clicking Unprotect Sheet.

Excel & Data Problems