Bold Individual Category Labels in an Excel Stacked Column Chart
Question details
The user wants to bold selected category-axis labels without bolding every label in a stacked column chart.

- Product
- Microsoft Excel
- Device & OS
- not provided
- Scenario
- Emphasizing specific categories in an Excel stacked column chart.
- Observed behavior
- Excel generally applies font formatting to all category-axis labels together rather than to individual labels.
Identify the category labels you want to emphasize and check the chart background color so replacement labels can blend in. If you use a helper series, keep the category names in worksheet cells.
Overlay Selected Axis Labels with Bold Text Boxes
Use text boxes when you need to emphasize a small number of category labels.
Select the chart, then choose Insert > Text Box and draw a box over the category label you want to emphasize.
Type the category name in the text box, select the text, and choose Home > Bold. Match the original label's font size and alignment.
Select the text box border and use Shape Format > Shape Fill to match the chart background. Set Shape Outline to No Outline, then position the box over the original label.
Add and position another text box for each category you want to bold. Recheck their positions if you resize the chart or change its data.

Use a Helper Series to Recreate Category Labels
Use data labels from cells when you want replacement labels tied to worksheet text.
Emphasize Selected Chart Labels in WPS Spreadsheet
Open your Excel workbook in WPS Spreadsheet and overlay selected category labels with bold text boxes. This provides a visual workaround without changing every axis label.
- 1. Open the workbook: Open WPS Spreadsheet and use Menu > Open to select your Excel workbook.
- 2. Add a text box: Select the stacked column chart, choose Insert > Text Box, and draw a box over the category label you want to replace.
- 3. Format the label: Type the category name, select the text, and click Bold on the Home tab. Match the chart's label size and alignment.
- 4. Position and save: Set the text box fill to match the chart background, remove its outline, and position it over the original label. Use Menu > Save As to save the workbook.

Frequently Asked Questions
Can I bold just one category-axis label directly in Excel?
Excel generally formats category-axis labels as a group. To emphasize one label, overlay it with a bold text box or recreate the labels using a helper series.
Can a chart text box update from a worksheet cell?
Yes. Select the text box border, enter a cell reference such as =Sheet1!A2 in the formula bar, and press Enter. The text can update with the cell, but the box does not reposition itself.
How do I hide the original category labels?
Right-click the horizontal axis, select Format Axis, and set Labels > Label Position to None. Do this after adding replacement labels so the categories remain identifiable.
Why are my helper-series labels not showing at the axis?
Zero-value data labels can be difficult to display or position in some chart configurations. Check Format Data Labels and the label position, or use text boxes if the labels cannot be placed clearly.




