How to Make an Excel Chart Axis Start at Zero
Question details
The user wants to format an Excel chart's horizontal (X) axis to start at zero instead of one.
- Product
- Excel
- Device & OS
- not provided
- Scenario
- Creating a data visualization where the horizontal axis represents numeric values or time intervals.
- Observed behavior
- The chart's horizontal axis defaults to starting at 1 instead of 0 because it treats the data as categorical labels rather than a continuous numeric scale.
Ensure your dataset contains actual numeric values or valid time formats before adjusting the chart settings.
Change the Chart Type to an XY (Scatter) Chart
Line, column, and bar charts use a category axis where items are sequentially numbered starting from 1. Using a Scatter chart changes the horizontal axis to a true numeric value axis that can start at 0.
By switching to an XY (Scatter) chart, Excel evaluates the horizontal axis as continuous numerical data. This allows you to set custom minimum and maximum bounds for the axis. You can format the scatter chart to have connecting lines so it visually resembles a standard line chart.
Select your chart and navigate to the Chart Design tab on the ribbon.
Click on Change Chart Type and select X Y (Scatter) from the list of options.
Choose a scatter chart style with straight or smooth lines, then click OK.
Double-click the horizontal axis on your new chart to open the Format Axis pane on the right.
Under Axis Options, locate the Bounds section and type 0 into the Minimum value box.
Create a Custom Interval Column for Time Values
If your data involves time values or sequential numeric intervals, you can create a helper column to act as the true X-axis values for a scatter chart.
Easily Make Chart Axes Start at Zero in WPS Spreadsheet
WPS Spreadsheet provides an intuitive and powerful chart editor. You can easily switch chart types to scatter plots and format axis bounds to start at zero without struggling through hidden menus.
- 1. Open your dataset: Launch WPS Spreadsheet and open the file containing your chart data.
- 2. Insert a Scatter Chart: Highlight your data, go to the Insert tab, and choose the Scatter chart option to ensure a numeric X-axis.
- 3. Format the Axis: Double-click the horizontal axis to open the right-side configuration pane.
- 4. Set Minimum Bound: In the Axis Options menu, set the Minimum Bound to 0 and press Enter to apply the changes.
Frequently Asked Questions
Why does my Excel line chart automatically start at 1?
Line, column, and bar charts in Excel utilize a category axis for the horizontal plane. Instead of plotting numerical values on a continuous scale, Excel treats the data points as distinct text labels (categories), automatically numbering the first item sequentially as category 1.
Where can I find 'More Horizontal Axis Options' in newer Excel versions?
In newer versions of Excel, the older Layout tab has been replaced. You can access axis settings by double-clicking the horizontal axis on your chart, or by right-clicking the axis and selecting Format Axis, which opens the configuration pane on the right side of your screen.
Can I keep my line chart and just change the axis numbers?
If you are using a standard line chart, you cannot change the underlying category axis to a true numeric value axis that scales from 0. However, you can format a Scatter chart with connecting lines, which visually looks identical to a line chart but allows full numeric scaling starting at zero.
