Chart & Visualization Issues

Use Numeric Values and Text Labels in an Excel Bar Chart

Chanuka GeekiyanageChanuka Geekiyanage Nov 14, 2026 868 views

Question details

Use numeric stage values to determine bar lengths while displaying related stage names as chart labels.

Use Numeric Values and Text Labels in an Excel Bar Chart
Product
Microsoft Excel
Device & OS
not provided
Scenario
A worksheet contains StageNumber values and corresponding StageName text for a bar chart.
Observed behavior
The chart should plot numeric values and show meaningful stage names. A value axis does not directly accept custom text labels like a category axis.
Before you start

Arrange StageName and StageNumber in separate columns, with each name on the same row as its numeric value. Decide whether the names should label the bars as categories or replace labels at specific positions on the numeric value axis.

Solution 1Recommended

Use stage names as category labels in an Excel bar chart

Use this approach when each stage name should identify a bar and its StageNumber should control the bar length.

1
Select the chart data

Select the StageName and StageNumber columns, including their headers, in the worksheet.

2
Insert a bar chart

Go to Insert > Bar Chart and choose a bar chart. Check that the bars use the StageNumber values and the category axis shows the stage names.

3
Correct the label range if needed

Right-click the chart and choose Select Data. Under Horizontal (Category) Axis Labels, click Edit, select the StageName cells, and click OK.

4
Check the numeric series

In Select Data, select the data series and click Edit. Make sure the series values refer to the StageNumber cells, then click OK.

Use stage names as category labels in an Excel bar chart
Category labels versus value-axis labels: Stage names identify the bars on the category axis. The value axis remains numeric and shows the scale used for bar lengths.
Create charts in WPS Office

Create a bar chart with stage names in WPS Spreadsheet

Use WPS Spreadsheet to plot numeric stage values as bar lengths and display the corresponding stage names as category labels.

  1. 1. Open the worksheet: Open WPS Spreadsheet and use Open to select the workbook containing your stage data.
  2. 2. Select the data: Select the StageName and StageNumber columns, including their headers.
  3. 3. Insert a bar chart: Choose Insert > Chart, select a bar chart, and insert it into the worksheet.
  4. 4. Check the chart labels: Confirm that stage names appear as category labels and StageNumber values determine bar lengths. If needed, select the chart and use Select Data to adjust the label and series ranges.
Show stage names alongside bars based on numeric valuesOpen and edit Microsoft Excel XLSX and XLS filesCreate and adjust charts in a familiar spreadsheet interfaceUse a free, lightweight office suite
microsoft office alternative - wps office

Frequently Asked Questions

Can an Excel value axis show stage names instead of numbers?

A value axis does not directly accept custom text labels like a category axis. Hide its labels using Format Axis > Labels > Label Position > None, then place linked text boxes at the desired positions.

How do I change the category labels on an existing chart?

Right-click the chart, choose Select Data, and click Edit under Horizontal (Category) Axis Labels. Select the cells containing the desired names and click OK.

Will linked text boxes move when I change the chart scale?

The linked text updates when its source cell changes, but the text box does not automatically track an axis value. After changing the scale or chart size, reposition the boxes manually or use a custom VBA macro.

Can I make the bars use numbers while their labels use text?

Yes. Put the names and numbers in separate columns, select both columns, and insert a bar chart. In Select Data, use the numeric cells for the series values and the text cells for the category labels.