Use Numeric Values and Text Labels in an Excel Bar Chart
Question details
Use numeric stage values to determine bar lengths while displaying related stage names as chart labels.

- 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.
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.
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.
Select the StageName and StageNumber columns, including their headers, in the worksheet.
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.
Right-click the chart and choose Select Data. Under Horizontal (Category) Axis Labels, click Edit, select the StageName cells, and click OK.
In Select Data, select the data series and click Edit. Make sure the series values refer to the StageNumber cells, then click OK.

Place linked stage names along the Excel value axis
Use linked text boxes when stage names must appear at specific positions along the numeric value axis rather than as category labels.
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. Open the worksheet: Open WPS Spreadsheet and use Open to select the workbook containing your stage data.
- 2. Select the data: Select the StageName and StageNumber columns, including their headers.
- 3. Insert a bar chart: Choose Insert > Chart, select a bar chart, and insert it into the worksheet.
- 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.

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.




