Others

Fix Missing Gantt Chart Bars in Microsoft Project or Excel

Aamir Naveed Akram Oct 14, 2026 871 views

Question details

The user is trying to restore Gantt chart bars that are not displaying correctly or have disappeared entirely in Microsoft Project or Excel.

How to Fix Missing Gantt Chart Bars in Microsoft Project or Excel

Product: Microsoft Excel and Microsoft Project
Device & OS: not provided
Scenario: Reviewing or presenting a project schedule where the Gantt chart bars should visually represent task durations and timelines.
Observed behavior: The Gantt chart bars fail to appear within the chart area, even after formatting the chart elements or adjusting the cell alignments.

Before you start

Before troubleshooting, verify that your project task dates (start dates and durations) are entered correctly without typos and fall within the expected timeframe of your current chart view.

Solution 1Recommended

Recover Missing Gantt Bars in Microsoft Project

Adjust your Project view settings to unhide bars, check your bar styles, and align your timescale to correctly display task dates.

In Microsoft Project, bars can sometimes disappear due to hidden field settings, strict style criteria, or simply because the current timescale is focused on the wrong date range.

Unhide Hidden Bars

Add the 'Hide Bar' field column to your Gantt Chart view. Review the entries and change any 'Yes' values to 'No' for the tasks missing their bars.

Verify Bar Styles Settings

Navigate to the Bar Styles configuration. Check the criteria defined in the 'Show For' column to ensure that your specific tasks meet the requirements to be displayed.

Scroll to Task on Timescale

Select the task row with the missing bar. Go to the ribbon, click on Task > Editing > Scroll to Task. This will automatically jump the timescale to bring the missing bar into your current view.

Recover Missing Gantt Bars in Microsoft Project

Timescale Check: Using 'Scroll to Task' is the fastest way to confirm whether a bar is truly missing or if it was just out of view on your timeline.

Solution 2

Fix Disappearing Gantt Chart Bars in Excel

Ensure your Excel stacked bar chart is referencing the correct data range and that your date and duration formats are valid.

Manage Projects Efficiently

Build and Manage Gantt Charts Easily with WPS Spreadsheet

WPS Spreadsheet provides robust chart tools that allow you to create accurate, visually appealing Gantt charts without the hassle of disappearing data. It fully supports standard Excel chart types, letting you manage project timelines with ease.

1. Enter Project Data: Open WPS Spreadsheet and organize your project data with three columns: Task Name, Start Date, and Duration (in days).
2. Insert a Stacked Bar Chart: Select your Start Date and Duration data. Go to the Insert tab, click the Chart icon, and choose a Stacked Bar Chart.
3. Format Data Series: Right-click the Start Date data series (the first segment of the bars) and set the Fill Color to 'No Fill'. This hides the first segment, leaving only the duration bars to create the Gantt chart look.
4. Adjust the Timeline Axis: Right-click the horizontal date axis, select Format Axis, and adjust the minimum bound to match the numeric value of your earliest project start date.

100% format compatibility with Microsoft Excel (.xlsx) files.Intuitive chart creation and simple data selection tools for project tracking.Lightweight and fast performance, even with complex project datasets.Rich built-in chart customization options for professional presentations.

microsoft office alternative - wps office

Frequently Asked Questions

Why does my Gantt chart in Excel show dates from the year 1900?

This happens when the horizontal axis minimum bound is set to 0, or if your start date cells contain blank values. Excel interprets the number 0 or an empty cell as January 1, 1900. To fix this, change the minimum bound of your date axis to match the numeric value of your project's actual starting date.

Can I use conditional formatting to build a Gantt chart without inserting a traditional chart?

Yes. You can create a timeline grid using spreadsheet columns and apply conditional formatting rules. By entering a formula that checks if a column's date falls between a task's start and end date, the cells will automatically fill with a designated color, functioning perfectly as a lightweight Gantt chart.

How do I make Gantt chart bars show completion progress in a spreadsheet?

To show progress, you can add a secondary 'Completed Days' data series to your stacked bar chart. Apply a darker fill color to this new series and set it to overlap the original duration bar entirely, which visually represents how much of the task is done.

Office Quick Solutions