Change Axis Labels in a Chart: Category Text and Ranges

Category axis labels are not typed onto the chart. They come from the range the chart reads, which is why editing the axis in place rarely works and why renaming a month on the chart seems to have no effect. Once you know that the text lives in the worksheet, changing axis labels in a chart becomes a short, predictable task.

This guide separates the two jobs people mix up, then covers the two equivalent ways to change the category text, the specific problems behind placeholder labels such as 1, 2, 3, multi-level categories that collapse, and the symptoms you see when the axis still shows the old text after an edit. Menu names involved in the source-range route are described as steps to verify, since they vary by version and platform.

How to Change Axis Labels in a Chart: Edit Category Text and Its Source Range

Change Axis Labels in a Chart: Two Different Jobs

There are two jobs on an axis and only one of them is about the text under the bars. Changing the category text means editing the source range. Renaming the axis means editing the axis title, which is a separate text object. This guide handles the first job only.

Job 1: Change the Category Text

The horizontal axis labels come from the category range: the column or row of names the chart was built from. To turn Jan into January, you edit that range — either in the worksheet, or by pointing the chart at a different range.

Job 2: Rename the Axis (A Different Feature)

An axis title describes what the axis represents, for example Revenue by quarter. It sits outside the plot area and is added or edited independently of the category text. If you need one, start from the existing walkthrough on add Excel axis labels in WPS Office or add axis titles in Excel, then return here for the category text.

What You Need Before Editing

An editable chart, not a picture of a chart pasted onto a slide.
The source range still present in the workbook, with no hidden or filtered columns in the middle of it.
Enough empty cells beside the range to add or rename categories without overwriting data.

Two different jobs on one axis

Use Word, Excel, and PPT for FREE

Edit Category Label Text Through the Source Range

There are two equivalent routes: edit the worksheet cells the chart already points at, or re-select a different range. They produce the same result, but the side effects differ, so pick deliberately.

Path A: Edit the Worksheet Cells

Select the chart so the source range highlights in the worksheet.
Find the category range — the row or column of names behind the horizontal axis.
Type the new names over the old ones; the chart updates as you edit.

This is the fastest route, and the one to prefer when only the wording changes. Its side effect is that the chart keeps following the range, so inserting or deleting rows inside it can shift which labels appear.

Path B: Re-select the Range in the Data Source Dialog

Select the chart and open its chart design or chart tools entry.
Open the chart data source dialog.
Locate the horizontal category axis label field and choose the edit option next to it.
Drag over the new category range and confirm.

Treat the exact command names in this path as steps to verify against the official documentation for your version and platform. The concept — pointing the chart at a category range — is the part that does not change.

Check the Series and Category Boxes Separately

In the same dialog, the series box controls the values and the category box controls the labels. Mixing them up is common in a hurry, and it produces a chart whose numbers look correct but whose labels are drawn from the wrong column.

Verify Before You Publish

Compare the label order left to right with the order of the source rows, and check that each label sits under the value it names. An off-by-one label is easy to spot here and embarrassing anywhere else.

Category range feeding the axis labels

Fix Multi-Level, Missing, and Reversed Category Labels

When the axis shows something other than your names, the symptom tells you which fix to apply. Match the symptom first, then make one change at a time.

Symptom: Labels Show 1, 2, 3

This happens when the category range is empty, contains blank cells, or no longer includes the header row the chart expects. Select the full column or row of names, including any header, and point the category range at it again.

Symptom: Multi-Level Labels Collapse

If your source has two category columns, for example region and month, both have to be included in the category range for the hierarchy to show. Select the block that spans both columns and the rows you need, and confirm the order of the levels reads the way you expect.

Symptom: Categories Are Reversed

Reversed order is an axis setting rather than a label problem. That lives in the axis format options, and the current site already covers the relevant axis options separately; adjust the category order there rather than editing the source rows into a different sequence. If a plain reorder is all you need, changing the source row order is the simplest fix.

Symptom: Duplicate Text Appears Twice

A duplicated label usually means the range includes a merged cell that repeats its value, or that the same column was selected twice. Deselect and re-select the range cleanly.

Placeholder labels replaced with category names

Category Labels vs Axis Titles vs Data Labels

Three things on a chart carry text, and they are edited in three different places. Mixing them up is the reason people conclude that an edit "did not work".

The Three-Label Table

Label	Where it appears	Where the text comes from	How to change it
Category label	Along the horizontal axis	The category range in the worksheet	Edit the cells or re-select the range
Axis title	Beside the axis, outside the plot	Typed text you add	Add or edit the axis title object
Data label	Next to a data point	The value of that point	Add, remove, rename, or format the label

Where Each One Gets Its Text

Category labels are dynamic: change the worksheet and the chart follows. Axis titles are static text you type. Data labels are usually generated from values, which is why removing or renaming them is its own workflow — see remove data labels from an Excel chart. The full set of available elements, and how to add them, is covered in how to add chart elements in Excel on Mac, and step-by-step label work is shown in how to add axis labels in Excel. This article stays on the first row of the table.

Editing each chart label type

WPS Spreadsheet: Editing Category Ranges in a Chart

Category ranges are a chart concept rather than a product-specific trick, so the same task chain applies when the workbook is open in WPS Spreadsheet.

Open the Chart Data Source Dialog

Select the chart and open its data source settings from the chart tools. You are looking for the same two boxes you use elsewhere: one for the series values and one for the horizontal category labels.

Re-select the Category Range

Open the edit option beside the horizontal category label field.
Select the worksheet range that holds your category names.
Confirm and check the axis labels update.

What Still Needs Verification

Treat the exact menu labels as items to verify against the official documentation for your version, along with whether multi-level category ranges are supported the same way in every chart type. If a step looks different on screen, the concept to look for is the entry that redefines the category range, not a specific button name. WPS Office is available as a free download at wps.com if you want to test the same workbook on another machine.

WPS Spreadsheet insights panel overview

Use Word, Excel, and PPT for FREE

When the Axis Still Shows Old Labels

You changed something and the axis disagrees. These four branches cover almost every case, and each one points at a different layer of the file.

Symptom: Nothing Changed

You probably edited the axis title box rather than the category range, or the chart is a pasted picture. Select the chart and confirm it is a live object with an editable source range.

Symptom: Only Some Labels Changed

Multi-series charts can carry more than one category setup. Open the data source dialog and check each series entry rather than assuming the first one is the only one.

Symptom: Labels Revert After Reopening

The edit was made in a copy, in a shared location you do not own, or in a file that was closed without saving. Reopen the file you actually saved and compare.

Symptom: Print Output Differs

Rotated or truncated labels behave differently on paper, and a print area that cuts the chart will hide labels that are visible on screen. Check the print preview rather than the screen view before you conclude the labels are wrong.

Four reasons old axis labels remain

FAQs

Can I type category labels directly on the axis instead of in the data?

Not as normal labels. Category text is read from the source range. If you need fixed wording that no longer follows the data, replace the category range with a range of typed values.

How do I stop the axis from showing 1, 2, 3 instead of my names?

The category range is empty or incomplete. Select the full column or row that holds your names, including the header, and point the horizontal category label field at it again.

Can I format the category labels as dates or currency?

Yes, but that is display formatting rather than a label text change. Apply the number format to the axis labels and check that the underlying values in the worksheet are unchanged.

Do these steps work in WPS Spreadsheet?

The concept is the same, because category labels always come from the chart source range. Confirm the exact menu names in the official documentation for the version you are running.

Why do my labels appear in the wrong order?

Either the source rows are in another order, or the axis is set to plot categories in reverse. Check the worksheet order first, then the axis options for the reverse setting.

Trustpilot

4.8

WPS Office- Free All-in-One Office Suite

Use Word, Excel, and PPT for FREE, No Ads.
Edit PDF files with the powerful PDF toolkit.
Microsoft-like interface. Easy to learn. 100% Compatibility.
Boost your productivity with WPS's abundant free Word, Excel, PPT, and CV templates.

5,820,008 User

Algirdas Jasaitis

logo

Summary

Category label text always comes from the chart source range, so change the cells or re-select the range rather than editing the axis. Change one thing at a time, keep the series box and the category box straight, and then run three checks before sharing: the label order matches the source rows, the values under each label are the ones you expect, and the printed or exported version shows the same labels as the screen.

Free Excel Editor

Table of Content

Change Axis Labels in a Chart: Category Text and Ranges

How to Change Axis Labels in a Chart: Edit Category Text and Its Source Range