Chart & Visualization Issues

Bold Individual Category Labels in an Excel Stacked Column Chart

Elise WilliamsElise Williams Nov 18, 2026 868 views

Question details

The user wants to bold selected category-axis labels without bolding every label in a stacked column chart.

How to Bold Individual Category Labels in an Excel 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.
Before you start

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.

Solution 1Recommended

Overlay Selected Axis Labels with Bold Text Boxes

Use text boxes when you need to emphasize a small number of category labels.

1
Insert a text box

Select the chart, then choose Insert > Text Box and draw a box over the category label you want to emphasize.

2
Add and format the label

Type the category name in the text box, select the text, and choose Home > Bold. Match the original label's font size and alignment.

3
Cover the original label

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.

4
Repeat for other labels

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.

Overlay Selected Axis Labels with Bold Text Boxes
Keep text in sync: Typed text does not update automatically. To link a text box to a cell, select its border, enter a reference such as =Sheet1!A2 in the formula bar, and press Enter. Its position still needs manual adjustment.
Work with charts in WPS Spreadsheet

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. 1. Open the workbook: Open WPS Spreadsheet and use Menu > Open to select your Excel workbook.
  2. 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. 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. 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.
Bold selected category labels using chart text boxesOpen and edit Microsoft Excel XLSX and XLS workbooksUse a familiar spreadsheet interfaceWork with a free, lightweight office suite
microsoft office alternative - wps office

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.