Use Text Labels Instead of Numbers on an Excel Chart Axis
Question details
The user wants an Excel chart to display descriptive text labels, such as Quiet, Tolerable, Loud, and Boisterous, instead of numeric axis values.
- Product
- Microsoft Excel
- Device & OS
- not provided
- Scenario
- Creating a chart whose scale or categories need reader-friendly text descriptions rather than numbers.
- Observed behavior
- Excel value axes are numeric by design, so text cannot be directly substituted for value-axis tick marks.
Identify whether the labels are needed on a category axis or on a numeric value axis. Category axes can use text from worksheet cells, while value axes require a chart-label workaround.
Use worksheet cells as text labels on a category axis
Use this method when the chart categories, such as column names or horizontal-axis items, should display descriptive text.
In the worksheet, place the desired labels, such as Quiet, Tolerable, Loud, and Boisterous, in a single row or column next to the related chart data.
Click the chart, then go to Chart Design > Select Data. Under Horizontal (Category) Axis Labels, select Edit.
Select the cells containing the descriptive labels, then click OK. Excel uses those cell values as the category-axis labels.
If the axis is still treated as numeric, change the chart type through Chart Design > Change Chart Type and choose a Column, Bar, Line, or other chart that uses a category axis.
Add custom text data labels for a numeric value axis
Use this workaround when the numeric scale must remain in place but each plotted point or bar needs a descriptive text label.
Add Text-Based Category Labels to Charts in WPS Spreadsheets
WPS Spreadsheets lets you build charts from labeled worksheet ranges and display descriptive category names instead of numeric category labels. For numeric scales, you can keep the plotted values and add labels from cells to make the chart easier to interpret.
- 1. Prepare the chart data: In WPS Spreadsheets, enter your numeric values in one column and the descriptive category names in an adjacent column.
- 2. Insert a category chart: Select the complete data range, then choose Insert > Chart and select a Column, Bar, or Line chart.
- 3. Set the category label range: Click the chart and use the chart data or Select Data option to assign the cells containing your text as the category-axis labels.
- 4. Add labels from cells when using a value scale: Select the data series, open Data Labels or Format Data Labels, and choose the helper cells as the label source when you need text beside plotted values.
Frequently Asked Questions
Can I replace the numbers on an Excel value axis with words?
No. Excel value axes are numeric because they represent measurable values. Keep the numeric axis and use custom data labels from cells to display words beside the relevant data points.
How do I change horizontal chart axis labels to text in Excel?
Click the chart, go to Chart Design > Select Data, and select Edit under Horizontal (Category) Axis Labels. Then select the worksheet cells containing your text labels.
Why does Excel still show numbers after I select text labels?
The chart may be using a value axis, such as an XY (Scatter) chart. Change to a category-based chart such as Column, Bar, or Line, or add custom data labels from cells.
Can I use text labels for bars in a chart?
Yes. Put the text in worksheet cells, select the chart series, add Data Labels, and use Format Data Labels > Value From Cells to choose the text-label range.
