Fix a Missing Text Box in an Excel for the Web Doughnut Chart
Question details
A text box positioned in the center of a doughnut chart is visible in desktop Excel but does not appear when the workbook is opened in Excel for the web.
- Product
- Microsoft Excel for the web
- Device & OS
- not provided
- Scenario
- The user wants to display a value or explanatory text in the center of a doughnut chart in both desktop and web versions of Excel.
- Observed behavior
- A text box docked inside the chart is not displayed in Excel for the web, although it is displayed in desktop Excel.
Open the workbook in both desktop Excel and Excel for the web to confirm that the missing object is a chart-attached text box. Check whether the center value can be represented by a chart data label before changing the chart layout.
Use a doughnut chart data label for the center value
Use this option when the missing text is a number, percentage, or short value that can be displayed through the chart itself.
Chart data labels are generally more reliable than chart-attached text boxes when a workbook is viewed in web-based spreadsheet apps. You may need to adjust the doughnut hole size and label position to create a clear center display.
In desktop Excel, click the doughnut chart that contains the missing center text.
Select Chart Design > Add Chart Element > Data Labels, then choose a label position that works for the doughnut slices.
Right-click a data label and select Format Data Labels. Under Label Options, choose Value, Percentage, Category Name, or a linked value as needed.
Save the workbook, open it in Excel for the web, and verify that the chart labels appear as expected.
Place an undocked text box over the doughnut chart
Use this option when the center content is custom wording, a title, or text that cannot be produced with a standard chart data label.
Create and View Doughnut Charts Reliably with WPS Spreadsheet
If Excel for the web does not display your chart-attached text box correctly, WPS Office provides a free, lightweight spreadsheet alternative with a familiar interface for editing charts, labels, and text objects. Open your existing workbook in WPS Spreadsheet and continue working without a complex migration process.
Frequently Asked Questions
Why does the text box show in desktop Excel but not Excel for the web?
The text box may be docked or attached to the chart, a chart-object behavior that Excel for the web does not fully display. Desktop Excel supports more chart formatting and object-placement features than the web app.
Can I show a number in the middle of a doughnut chart without a text box?
Yes. Select the chart in desktop Excel, then choose Chart Design > Add Chart Element > Data Labels. Use Format Data Labels to choose the value or percentage you want to display.
Will a separate text box work in Excel for the web?
An undocked text box inserted from Insert > Text > Text Box and positioned over the chart is more likely to display online. Its position may need adjustment in different browser or screen sizes.
How do I keep a text box centered over a doughnut chart?
Create the text box as an independent worksheet object, place it over the doughnut hole, and use Shape Format options to set No Fill and No Outline. Then check its placement after opening the workbook in the browser.
