Chart & Visualization Issues

How to Use Data Values as X-Axis Labels in an Excel Bar Chart

Nimra Malik Oct 10, 2026 869 views

Question details

The user wants to replace the default sequential numbers (1, 2, 3...) on the horizontal axis of an Excel clustered column chart with specific data values (bin values) from their worksheet.

How to Use Data Values as X-Axis Labels in an Excel Chart

Product: Excel
Device & OS: not provided
Scenario: Creating a histogram or clustered column chart to show frequency counts for occurrences in particular bins.
Observed behavior: The chart displays default sequential numbers (1 through 8) on the horizontal X-axis instead of using the actual bin values (0 to 3000) from the source dataset.

Before you start

Ensure your chart is already inserted into the spreadsheet and that the column containing your desired X-axis labels (such as bin values or category names) is clearly organized in your worksheet.

Solution 1Recommended

Edit Horizontal Axis Labels via Select Data Source

Use the 'Select Data Source' dialog to manually point the chart's horizontal axis to the specific range of cells containing your preferred labels.

By default, if Excel does not recognize category labels during chart creation, it assigns sequential numbering to the X-axis. You can override this behavior by selecting the exact range of worksheet cells you want to act as your custom labels.

Open the Select Data dialog

Right-click anywhere on your clustered column chart or bar chart and choose 'Select Data...' from the context menu.

Edit the horizontal axis labels

In the 'Select Data Source' dialog box, locate the 'Horizontal (Category) Axis Labels' section on the right side and click the 'Edit' button.

Select the label range

A small dialog box will appear. Click and drag your mouse to select the worksheet range containing your desired Bin values or category names (for example, cells A2:A9).

Apply the changes

Click 'OK' in the Axis Labels dialog, and then click 'OK' again in the main Select Data Source dialog to apply your changes.

Edit Horizontal Axis Labels via Select Data Source

Bulk Assignment: Selecting the entire worksheet range assigns all the labels at once, so you do not need to manually edit each data point individually.

Efficient Charting Tool

Create and Customize Charts Easily with WPS Spreadsheet

WPS Spreadsheet offers powerful data visualization tools, allowing you to quickly customize chart axes, modify data sources, and format your graphs exactly like you would in Microsoft Excel.

1. Insert your chart: Open your data in WPS Spreadsheet, select your data range, and insert your desired chart type from the 'Insert' tab.
2. Access data selection: Right-click the newly created chart and click 'Select Data' from the drop-down menu.
3. Select custom axis labels: Under the 'Category (X) axis labels' section, click the data selection icon, drag to select the cell range containing your custom axis labels, and click 'OK' to apply.

Fully compatible with Microsoft Excel (.xlsx, .xls) file formats.Intuitive chart creation and customization interface.Supports advanced features like custom axis labels, histograms, and pivot charts.Free and lightweight alternative for powerful data analysis.

microsoft office alternative - wps office

Frequently Asked Questions

Why does my Excel chart show 1, 2, 3 instead of my data labels?

When Excel creates a chart without recognizing the intended category labels, it defaults to sequential numbering (1, 2, 3...) for the X-axis. You can fix this by right-clicking the chart, choosing 'Select Data', and editing the Horizontal Axis Labels to point to your specific data range.

Can I use text values as X-axis labels in a column chart?

Yes. Using the 'Select Data' menu, you can select any range of text strings or numerical bins in your worksheet to serve as custom category labels along the X-axis.

How is a clustered column chart different from an XY scatter plot in handling X-axis values?

In an XY scatter plot, the X-axis represents a continuous numerical scale derived directly from the X-values in your data. In a clustered column chart, the X-axis is categorical, meaning it treats the provided values as distinct text labels or 'bins' evenly spaced along the axis, regardless of their actual numerical value.

Excel & Data Problems