How to Edit Horizontal Axis Labels in Excel | Change Chart Text Fast

Horizontal axis labels in an Excel chart are edited through the Select Data dialog: either change the source worksheet cells for automatic updates, or type custom labels directly in the Axis label range box to create static, chart-only text.

Whether you need to fix a misspelled product name, switch the category order, or label months differently, Excel gives you two clear paths. The fastest way is often to edit the cells that feed the chart—but if you want labels that stay put even when your data changes, the chart‑only custom method is your answer. Below you’ll find the exact steps for both, plus the critical difference between category and value axes that trips up most users.

Edit Source Cells (The Automatic Way)

When your chart’s horizontal labels are linked to worksheet data, the simplest edit is to change the cells themselves. The chart updates instantly as you type.

1. Click any cell that contains one of the current label texts.
2. Type the new label and press Enter.
3. Repeat for each label you need to change.

That’s it. The chart reflects the new text immediately, and the link to your worksheet stays intact. This method works for any chart type that uses category labels—column, bar, line, and pie.

Create Custom Labels (Chart Only, No Cell Link)

If you want labels that are independent of your worksheet data (e.g., you don’t want to rearrange a data table just to match a chart), use the Select Data dialog. Note that Microsoft explicitly says this method only works in Excel and breaks the link to the cells.[7]

1. Right‑click the horizontal axis labels (the text below the chart) and choose Select Data.
2. In the dialog that opens, under Horizontal (Category) Axis Labels, click Edit.
3. In the Axis label range box, type the labels you want, separated by commas (e.g., Jan,Feb,Mar).
4. Click OK twice.

The axis now shows the exact text you typed, and those labels will not change if you later modify the original worksheet cells.

How Do You Use a Different Cell Range as Labels?

Instead of typing labels manually, you can point Excel to a different range of cells that already contains the text you want.

1. Right‑click the horizontal axis and select Select Data.
2. Under Horizontal (Category) Axis Labels, click Edit.
3. Click the range‑selection icon next to the Axis label range box.
4. Highlight the cells that contain your new labels (they must be in a single row or column).
5. Click OK twice.

This method keeps the labels linked to the worksheet—changes you make to those cells will appear on the chart automatically.

Important Distinctions: Category vs. Value Axis

The horizontal axis in most Excel charts (column, bar, line) is the category axis. Its labels are text items like months or product names. The numeric scale along the bottom of a chart is the value axis—you don’t “edit” its labels the same way. To change a value axis’s number format (e.g., showing currency signs), right‑click the numbers and choose Format Axis > Number.

Scatter (XY) charts are different. Their horizontal axis is based on X values, not categories. To edit labels in a scatter chart, you must modify the data series itself or add data labels, not the axis label option.

Quick Comparison of Editing Methods

Common Mistakes to Avoid

• Editing the wrong axis. Make sure you right‑click the category labels (the text items), not the value numbers on the side.
• Expecting custom labels to stay linked. Once you type labels directly into the Axis label range box, the connection to the worksheet is broken. Use the cell‑range method if you want updates.
• Forgetting to click Edit. The Horizontal (Category) Axis Labels box in the Select Data dialog is just a display—you must click the Edit button to change it.
• Treating a scatter chart like a category chart. For XY scatter charts, the horizontal axis is numeric; axis label editing doesn’t work the same way. Instead, consider adding data labels or adjusting the series X values.

For the full official procedure, refer to Microsoft’s guide to changing axis labels in a chart.

Finish With the Right Method for Your Situation

• If your chart labels come from a data table you maintain: edit the source cells. It’s the fastest path and keeps everything linked.
• If you need one‑off labels that never change with the data: use the Select Data dialog and type custom comma‑separated text.
• If your labels are in a different range of your spreadsheet: use the cell‑range selection to point Excel to that range.
• If you’re working with a scatter chart: skip the axis label editing workflow; instead modify the X values in your data series.