Set Excel Combo Chart X-Axis Labels to Start at Zero
Question details
Set the horizontal axis labels of an Excel combo chart 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.
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.
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.
Click the combo chart, then select Chart Design > Select Data.
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.
Right-click the horizontal axis and choose Format Axis. Under Axis Options, set Vertical axis crosses to At category number 1 if needed.
Click OK in Select Data Source and check that the chart starts with 0 and retains both the bar and line series.

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. Open the workbook: In WPS Spreadsheets, select Open and choose the workbook containing the combo chart.
- 2. Open chart data settings: Click the chart, then use Chart Tools > Select Data to open its data source settings.
- 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. Confirm the chart: Confirm the selection and check that the axis starts at 0 and that both chart series remain visible.

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.




