Excel Gantt Chart Not Showing All Data? How to Fix It

If an Excel Gantt chart is not showing all its data, check the chart’s source range, date-axis limits, and filters first; these are common reasons tasks disappear. Then confirm that start dates and durations are valid numbers, and that hidden rows or columns are allowed to appear in the chart.

How an Excel Gantt chart displays data

Excel does not have a dedicated Gantt chart type. A typical worksheet Gantt chart is a stacked bar chart built from task names, start dates, and durations. The first series represents the time between the chart’s beginning and a task’s start; the second represents the task duration. The first series is usually formatted with no fill so only the duration bar is visible. That offset makes each task appear to start at the right date.

This construction helps explain why a task can seem missing even when its row is present. The chart may be plotting the offset series but not the duration series, positioning a bar outside the visible date range, or treating a date or duration as text instead of a number. The underlying task table and the chart’s plotted series are related, but they are not the same thing: a chart displays only the ranges and series it has been told to use.

Check the chart’s source data range

Start by selecting the chart and reviewing its data source. In Excel for Microsoft 365 on Windows, use Chart Design > Select Data. Check the chart data range and the entries under Legend Entries (Series) and Horizontal (Category) Axis Labels. Make sure the source includes every intended task row, the task names, and both date-offset and duration data where applicable.

A chart may have been created while only part of the worksheet was selected. For example, if the original range ended at row 18 and new tasks were added in rows 19 through 25, those tasks might not be included in a chart whose source is a fixed range. In the Select Data dialog, edit the chart data range or the relevant series and category ranges to include the missing rows. Take care not to include totals or blank template rows as tasks.

Check the first and last row of each plotted range, not just the range’s column letters.
Confirm that task names are assigned as category labels rather than plotted as a numeric series.
For a stacked Gantt chart, verify that the start-offset and duration series both cover the same tasks.
If you add tasks often, consider converting the data range to an Excel table with Home > Format as Table. Charts based on table data can expand as table rows are added, although it is still worth checking the chart source after changing its structure.

Excel for Mac has the same general chart-data controls, though the ribbon arrangement can differ by release. Excel for the web also supports chart editing, but some chart-formatting controls may be more limited than in the Windows desktop app.

Look for date-axis bounds that cut off tasks

A date axis can hide bars that start before its minimum or finish after its maximum. Select the horizontal date axis, right-click it, and choose Format Axis. In the Format Axis pane, inspect the Minimum and Maximum bounds under Axis Options. If either has a manually entered value, it may restrict the visible schedule. Clear the custom value or use the reset control beside it, if shown, to return that bound to Auto.

For example, suppose a plan includes tasks running from March 24 through May 16, but the axis maximum is set to April 30. Tasks scheduled only in May will not appear within the plotted window, and tasks that extend into May may look too short. Set the maximum far enough out to include the last planned date. Likewise, a task starting before the minimum can be partly or wholly outside the view.

Also check that the values in the start-date column are actual Excel dates. Excel stores dates as serial numbers and formats those numbers to look like dates. Text that merely looks like a date can be interpreted differently, especially when copied from another system or entered using a different regional date convention. Test a suspicious cell by changing its number format temporarily to General; a real date will display as a number. If it remains text, convert it to a valid date before relying on it in the chart.

Inspect hidden rows, filters, and chart filters

Charts can omit data in hidden or filtered worksheet rows. Select the chart, go to Chart Design > Select Data, and choose Hidden and Empty Cells. If the option is available, enable Show data in hidden rows and columns when you want the chart to include values in hidden rows or columns. This setting is useful when rows are hidden for presentation but should remain part of the schedule view.

Worksheet filters are another likely cause. If a table filter is showing only a subset of tasks, the chart may follow that filtered view. Clear the table filter or review which filter criteria are active. Also look for the Chart Filters button (the funnel icon) beside a selected chart. Open it and check whether any categories or series have been unchecked. A chart filter can hide a task even when the worksheet row is visible.

Hidden columns matter too. If the start-date or duration series is stored in a hidden column, the chart may not use it unless the hidden-data setting permits it. If the chart has been copied from another workbook, do not assume its hidden-data preference matches the current sheet. Confirm the setting directly.

Verify the start-date and duration series

In a standard stacked-bar Gantt chart, the offset series and the duration series must both be numeric and correctly aligned with the task labels. A duration such as 12 should mean 12 days if the chart is intended to use daily units. A value entered as text, a blank duration, or a duration in a different unit can produce a missing or misleading bar. Check a few rows against the schedule rather than assuming that every cell in the column has the same type.

Use Chart Design > Select Data to confirm the series ranges. If the duration series has been removed, add it back; if the start-offset series is missing, the bars may all begin at the chart origin rather than at their planned dates. To make the offset invisible, select the offset series, open Format Data Series, and set its fill to No fill. Do not delete that series: it provides the spacing that positions the visible task bars.

For a concrete check, imagine a task starting on April 8 and lasting 5 days. The chart needs an offset that places its bar at April 8 and a duration value of 5. If the duration cell is blank, that task has no visible duration bar. If the offset is plotted as text or belongs to a different row than the task label, the bar may land in the wrong place or fail to display as expected.

Check category labels, order, and chart layout

When some task names seem absent, inspect the vertical category axis as well as the date axis. In a bar chart, task names are categories. Excel may show the first category at the bottom, which can make users think the earliest tasks are missing when they are simply lower in the chart or outside the current chart area. Select the category axis, open Format Axis, and review Categories in reverse order. Changing this option can put the first task at the top, but it does not add or remove data.

A chart that is too short can also make categories difficult to read. Enlarge the chart or reduce unnecessary whitespace, and check whether the category labels are clipped. If the chart is embedded near the top of a worksheet, scroll through the full chart area rather than assuming it ends at the last visible task in the window. In a printed worksheet, page breaks and print areas may clip the chart even though the on-screen chart contains the data.

If the task list contains many rows, consider making the chart larger or using a separate schedule view for printing. Deleting tasks or compressing labels is not a reliable fix for a chart that is simply too small to display all categories legibly.

Fix blank cells and inconsistent source data

Blank cells can represent different things: a task with no duration, an incomplete record, or a deliberate gap. Excel cannot draw a duration bar when the duration value is absent. Find blank cells in required columns and decide whether to fill them with correct schedule information or exclude those rows from the chart’s source. Avoid putting a zero in every blank cell unless zero truly means the task has no duration; doing so can make an incomplete schedule appear complete.

Check for inconsistent entries such as numbers stored as text, dates with mixed formats, spaces in task names, and formulas returning an empty string. A formula that returns an empty string looks blank, but its behavior in a chart can differ from a genuinely empty cell. In Chart Design > Select Data > Hidden and Empty Cells, review the available settings for how empty cells are shown. This will not correct invalid date or duration values; it only controls how the chart treats gaps in its source.

When task data comes from a pasted report, check for merged cells or repeated headings within the task range. A chart expects a consistent table-like structure. One row per task, with a name, start date, and duration, is easier to chart and troubleshoot than a layout with section headings mixed into the data.

Refresh or rebuild the chart when needed

Most ordinary charts update when values in their source cells change. If a value is edited but the picture seems stale, confirm that calculation is not set to Manual under Formulas > Calculation Options, then recalculate the workbook. You can press F9 on Windows to recalculate. On a Mac, use Fn+F9 if the function keys are configured for system controls; otherwise use the equivalent recalculation command available in Excel.

If the source range, series assignments, and axis bounds are badly tangled, creating a fresh chart can be faster than repeatedly adjusting it. Select a clean data range containing task names, offsets, and durations, then use Insert > Insert Column or Bar Chart > 2-D Stacked Bar. Confirm the category labels and series in Select Data, set the offset series to No fill, and format the horizontal axis as a date scale. Compare the new chart with the old one before deleting anything; the old chart may contain useful formatting or manual settings.

Save a copy before making extensive changes if the workbook contains important planning data. A chart edit usually does not change the underlying dates, but restructuring ranges or deleting series can make it harder to restore the intended view.

Frequently Asked Questions

Why is my Excel Gantt chart missing new tasks?
New rows may fall outside the chart’s source range. Select the chart and use Chart Design > Select Data to include the added task rows. A chart based on an Excel table may expand with new table rows, but verify the source if it does not.

Why does my Gantt chart show bars but not task names?
The category-label range may be missing or assigned incorrectly, or the chart may be too small to show its labels. In Select Data, check Horizontal (Category) Axis Labels and make sure that range contains the task-name cells.

Why do some tasks appear only partly in the chart?
The horizontal date-axis minimum or maximum may cut off the start or finish. Open Format Axis and clear restrictive custom bounds, then check that each start date is a real Excel date and that the duration is correct.

Can Excel make a Gantt chart automatically?
Excel does not include a dedicated Gantt chart type. A common approach is to create a stacked bar chart from a start-date offset and a duration series, then hide the offset series and format the date axis.

Why does a filtered task disappear from the chart?
The chart may follow worksheet filters, or its own Chart Filters may exclude the task or series. Clear the relevant worksheet filter and inspect the funnel-shaped Chart Filters button beside the selected chart.

A reliable order for troubleshooting

To avoid changing several settings without knowing which one mattered, troubleshoot in a consistent order. First check whether the missing task exists in the source table and whether its date and duration cells contain valid values. Next confirm the chart includes that row and both required series. Then inspect worksheet filters, chart filters, and the hidden-data setting. Finally, adjust axis bounds and chart size. This sequence moves from the data itself to the chart’s display, making it easier to find the cause and preserve the rest of the schedule.

Try it: the Percentage Formula Generator: percent of, percent change, increase and decrease, with the formula.

More in Charts & pivot tables

Sources: Function behaviour and menu paths: Microsoft Support documentation for Excel. Method & sources

Spotted an error in this guide? Let us know.