Chart & Visualization Issues

How to Remove Extra Dates from an Excel Gantt Chart

Steve K Oct 10, 2026 868 views

Question details

The user needs to trim unnecessary dates that extend beyond the project's actual end date on a Gantt chart.

How to Remove Extra Dates from an Excel Gantt Chart

Product: Microsoft Excel
Device & OS: not provided
Scenario: Formatting the timeline of a project management Gantt chart.
Observed behavior: The horizontal axis displays dates that go beyond the completion date of the project because the maximum bound is set too high.

Before you start

Determine the exact numeric serial value of your project's end date in Excel, as dates are stored as sequential numbers (for example, December 31, 2028 is stored as 47118).

Solution 1Recommended

Adjust the Horizontal Axis Maximum Bound

Manually set the maximum bound of the horizontal axis to match the numeric serial value of your project's end date to remove excess timeline display.

Excel handles dates as serial numbers. When creating a Gantt chart using a stacked bar chart, Excel may automatically set the axis bounds higher than necessary, causing the timeline to stretch too far into the future. You can fix this by explicitly defining the end date in the axis options.

Open Axis Options

Right-click on the horizontal axis (the dates at the top or bottom of your Gantt chart) and select 'Format Axis' from the context menu.

Locate the Bounds Settings

In the 'Format Axis' pane that appears on the right side of the screen, navigate to the 'Axis Options' tab (represented by a bar chart icon) and find the 'Bounds' section.

Set the Maximum Bound

Click inside the 'Maximum' field and type the numeric serial value corresponding to your desired end date (e.g., enter 47118 to end the chart in December 2028).

Apply and Verify

Press Enter to apply the change. The Gantt chart will instantly update, removing the extra dates from the end of the timeline.

Adjust the Horizontal Axis Maximum Bound

Finding Date Serial Numbers: If you don't know the numeric serial value of your end date, type the date into a blank cell in your spreadsheet, select the cell, and change its number format from 'Date' to 'General'. The displayed number is what you should enter into the axis bounds.

Create and Format Gantt Charts in WPS Spreadsheet

Manage Project Timelines Easily with WPS Office

WPS Spreadsheet provides robust charting tools, allowing you to create customized Gantt charts, easily adjust axis bounds, and manage project dates without hassle.

1. Open Your Project Chart: Launch WPS Spreadsheet and open the document containing your Gantt chart.
2. Access Object Formatting: Double-click the horizontal date axis on your Gantt chart to open the Object Formatting pane on the right.
3. Navigate to Axis Options: Click the Axis Options icon and expand the 'Bounds' settings.
4. Adjust the Bounds: Input your specific numeric end date into the Maximum bound field to immediately trim the excess dates from your chart.

Seamlessly format horizontal and vertical axes for precise timelinesFully compatible with Microsoft Excel (.xlsx) formatsLightweight application with intuitive charting toolsFree built-in templates for project management and planning

microsoft office alternative - wps office

Frequently Asked Questions

Why does my Gantt chart start much earlier than my project start date?

This happens when the Minimum bound of the horizontal axis is set too low or left on 'Auto'. Just like setting the Maximum bound, you can fix this by changing the Minimum bound in the Axis Options to the numeric serial value of your actual project start date.

Will my axis bounds update automatically if my project end date changes?

No. When you manually type a number into the Maximum bound field (such as 47118), it overrides the 'Auto' setting and becomes a fixed value. If your project timeline extends beyond this date, you will need to manually adjust the Maximum bound again to reflect the new end date.

Can I format the dates on the Gantt chart axis to show only the month and year?

Yes. Right-click the horizontal axis, select 'Format Axis', and scroll down to the 'Number' section in the Axis Options pane. Enter a custom format code like 'mmm yyyy' and click 'Add' to display only the month abbreviation and the year.

Excel & Data Problems