Chart & Visualization Issues

Set Excel Combo Chart X-Axis Labels to Start at Zero

Muhammad TalhaMuhammad Talha Nov 18, 2026 869 views

Question details

Set the horizontal axis labels of an Excel combo chart to start at zero.

Set Excel Combo Chart X-Axis Labels to Start at Zero
Product
Microsoft Excel
Device & OS
not provided
Scenario
A user combines bar and line series and wants the category axis to show labels such as 0, 10, 20, and 30.
Observed behavior
The chart displays labels such as 1, 11, 21, and 31 instead.
Before you start

Check which worksheet column contains the intended category labels and confirm that its first data cell contains 0. Identify the last category cell so you can select the full label range without including a header.

Solution 1Recommended

Select the Correct Category Label Range in Excel

Use this method when the combo chart is displaying the wrong worksheet values as horizontal axis labels.

1
Open the chart data settings

Click the combo chart, then select Chart Design > Select Data.

2
Edit the axis labels

Under Horizontal (Category) Axis Labels, click Edit. Select the cells containing the intended labels, such as A2 through the last category cell, and click OK.

3
Check the crossing position

Right-click the horizontal axis and choose Format Axis. Under Axis Options, set Vertical axis crosses to At category number 1 if needed.

4
Verify the labels

Click OK in Select Data Source and check that the chart starts with 0 and retains both the bar and line series.

Select the Correct Category Label Range in Excel
Label range versus crossing position: The selected source range determines the category labels. The crossing setting controls where the vertical axis meets the category axis; it does not change the label values.
Edit charts in WPS Office

Update Combo Chart Labels in WPS Spreadsheets

Open the workbook in WPS Spreadsheets and select the worksheet cells containing the intended horizontal category labels.

  1. 1. Open the workbook: In WPS Spreadsheets, select Open and choose the workbook containing the combo chart.
  2. 2. Open chart data settings: Click the chart, then use Chart Tools > Select Data to open its data source settings.
  3. 3. Choose the label range: Edit the horizontal category axis labels and select the cells containing the intended values, starting with the cell containing 0.
  4. 4. Confirm the chart: Confirm the selection and check that the axis starts at 0 and that both chart series remain visible.
Choose the source labels for a bar-and-line combo chart.Open and edit Microsoft Excel XLSX and XLS workbooks.Use familiar spreadsheet and chart editing tools.Work with a free, easy-to-use office suite.
microsoft office alternative - wps office

Frequently Asked Questions

Why does my combo chart show 1, 11, 21, and 31?

The chart may be using the wrong cells for its category labels. In Excel, open Chart Design > Select Data and check the range under Horizontal (Category) Axis Labels.

How do I show every tenth category label?

Right-click the horizontal category axis, choose Format Axis, and look for the interval between labels under Axis Options. Set it to 10 if the source contains consecutive categories and you want to display every tenth label.

Will changing the axis crossing make the first label zero?

No. Setting the vertical axis to cross at category number 1 controls its position. To display 0 as the first label, select a category label range whose first cell contains 0.

What if my chart uses a numeric X-axis instead of a category axis?

For a numeric axis, such as an XY scatter chart axis, right-click the axis and choose Format Axis. Under Axis Options, set the minimum bound to 0; category label range settings work differently.