Excel Chart: Add a Gap Between the First Column and the Axis
Question details
The user needs to create a narrow visual gap between the vertical axis and the first column in a column chart while keeping the other columns together.
- Product
- Microsoft Excel chart
- Device & OS
- not provided
- Scenario
- The chart should have separation only between the vertical axis and the first column, with no additional gaps between the remaining columns.
- Observed behavior
- The first column appears directly next to the vertical axis, and the user wants a small white space without changing the spacing between other columns.
Open the workbook and select the column chart you want to adjust. Confirm that the vertical value axis is visible and that you can access its formatting options.
Format the vertical axis as a narrow white line
Use this method when you want a small visual gap before the first column without changing the spacing between the data columns.
A white axis line can visually mask the area next to the first column and create the appearance of a narrow gap. The exact result may vary slightly by Excel version, chart style, and background color.
Click the chart, then click the vertical value axis along the left side of the plot area.
Right-click the selected vertical axis and choose Format Axis. In some Excel versions, you can also use the Format Selection button on the Chart Format tab.
In the Format Axis pane, open Fill & Line or Line, select Solid line, and set the line color to White.
Set the line width to approximately 5 pt. Adjust the value slightly if the gap appears too wide or too narrow.
Create a First-Column Gap in WPS Spreadsheets Charts
WPS Spreadsheets lets you format the chart's vertical axis line directly. Set it to a solid background-colored line and adjust its width to create a narrow gap before the first column while preserving the spacing between the remaining columns.
- 1. Open the chart: Open the workbook in WPS Spreadsheets and click the column chart to activate the chart tools.
- 2. Select the vertical axis: Click the vertical value axis on the left side of the plot area, then right-click it and choose Format Axis.
- 3. Change the axis line: In the formatting pane, open the line or border settings, choose a solid line, and set its color to white or to match the chart background.
- 4. Adjust the width: Set the line width to about 5 pt, then click outside the chart to review the gap between the axis and first column.

Frequently Asked Questions
Will formatting the axis change the spacing between all columns?
No. Formatting the vertical axis line only affects the visual area beside the axis. The spacing between the remaining columns stays unchanged.
What line width should I use for the gap?
Start with approximately 5 pt. Increase or decrease the width in the Format Axis pane until the space beside the first column looks correct.
Why does the gap not appear when I use a white axis line?
The chart background may not be white, or the axis line may be set to No line. Select the vertical axis, choose Solid line, and use the same color as the chart background.
Can I use this technique in WPS Spreadsheets?
Yes. Select the chart's vertical axis, open Format Axis, set the axis to a solid background-colored line, and adjust its width to create the visual gap.




