Stacked Bar Chart Excel Gantt: Build a Task Timeline

Charts & pivot tables · Updated November 20, 2026

Yes. In Excel, a Gantt chart can be made from a stacked bar chart by plotting each task’s start date as an invisible first series and its duration as a visible second series. The visible bars then begin at the correct dates and show how long each task lasts.

How a stacked bar chart becomes a Gantt chart

A standard stacked bar chart places series beside or on top of one another; a Gantt chart uses that stacking to create a timeline. The first series is the offset from the chart’s starting point to a task’s start date. The second series is the task duration. Once the offset series is made transparent, only the duration bars remain visible, apparently floating at the right places along the date axis.

Excel stores dates as serial numbers, so the start dates can position the bars on a numeric horizontal axis. A task that starts later has a larger start-date value and therefore a larger invisible offset. Its duration value extends the visible bar from that point. This is a chart-formatting technique, not a dedicated Gantt chart type: Excel’s chart gallery does not include a native Gantt chart option.

The result is useful for project plans, editorial calendars, implementation schedules, and other timelines where the main question is when work begins and ends. It is a visual schedule rather than a project-management system: it does not automatically calculate dependencies, assign resources, or reschedule tasks when a predecessor changes.

Prepare the task data

Set up the chart source in three adjacent columns. Put task names in column A, start dates in column B, and durations in column C. You can keep finish dates in column D for reference. For example, enter task names in A2:A5, start dates in B2:B5, and finish dates in D2:D5. Format the date columns as dates so they are easy to read.

With start dates in B2:B5 and finish dates in D2:D5, enter =D2-B2 in C2 and fill it down. This calculates elapsed calendar days: a task from June 2 through June 5 has a duration of 3 days, so its bar ends on June 5 when the chart starts at June 2. If your schedule counts both the start and finish dates as full days, use =D2-B2+1 instead; that same example returns 4. Choose one convention and use it consistently, since the extra day changes every bar’s length.

For a small example, a research task might start June 2 and finish June 5, while a draft starts June 4 and finishes June 10. The second task’s start date positions its bar two days after the first task’s start, and its duration determines the bar’s length. Use real Excel date values, not date-looking text; text may not position correctly on the value axis.

  • Use one row per task and include a clear header row.
  • Keep the chart series simple: task name, start date, and duration.
  • Decide whether durations mean elapsed calendar days or inclusive days before building the chart.
  • Remember that these durations include weekends unless you calculate working days separately; a basic stacked bar chart does not automatically skip weekends.

Create the stacked bar chart

  1. Select the task names, start dates, and durations, including their headers—for example, A1:C5.
  2. On the ribbon, choose Insert > Insert Column or Bar Chart > 2-D Bar > Stacked Bar. Choose Stacked Bar, not 100% Stacked Bar: the 100% version scales each task to the same total length and does not represent a real timeline.
  3. If Excel assigns the wrong labels or series, right-click the chart and choose Select Data. Confirm that Start is one series, Duration is the other, and the task names are the category labels. Use Switch Row/Column if Excel has interpreted rows and columns the wrong way.
  4. Click a bar in the Start series, right-click, and choose Format Data Series. In the Format Data Series pane, open Fill & Line, then Fill, and select No fill. If an outline remains, set Border to No line as well.

At this point, the invisible start series still occupies space in the chart, but it no longer appears. The colored Duration series forms the Gantt bars. If the first series disappears from the legend only after you delete its legend entry, that is fine; avoid deleting the data series itself, because its values are what position the visible bars.

Put tasks in a useful order

Excel may display the first task at the bottom of a horizontal bar chart. To put the first worksheet task at the top, right-click the vertical task-name axis and choose Format Axis. Under Axis Options, select Categories in reverse order. This reverses the displayed category order without rearranging the source table.

Reversing categories can also change where the horizontal date axis crosses the task list. If the date labels move to an inconvenient side, use the axis-crossing options in the same Format Axis pane to adjust their position. The exact available controls can depend on the chart’s axis settings, so check the result in the chart rather than assuming the task order and axis position are independent.

Format the date scale and bars

The horizontal axis is a numeric value axis based on Excel’s date serials. If it displays numbers rather than dates, right-click that axis and choose Format Axis. In the pane’s Number section, choose a date format or enter a suitable custom format such as a day and abbreviated month. The axis remains numeric underneath; the number format changes only how its values are displayed.

Make the scale cover the period readers need to see. An automatically chosen range may include too much empty time before the first task or after the last one. In Axis Options, adjust the horizontal axis bounds if needed, using date values corresponding to the schedule’s start and end. If the controls are difficult to interpret, begin with automatic bounds and change one boundary at a time. Major units control the spacing of date labels; weekly labels often suit a short plan, while monthly labels may be clearer for a long project.

Click a visible duration bar to format the whole series. In Format Data Series, adjust Fill and Border, then use Gap Width to control the space between task bars. A smaller gap produces thicker bars; a larger gap makes separate tasks easier to distinguish. Use a high-contrast bar color and avoid overly decorative effects that obscure dates or make overlapping tasks hard to read.

For a milestone, use a zero-duration value only if the chart and scale make that point visible; a bar with no length may be too small to notice. A practical alternative is to add a separate milestone series and format its marker, or annotate the chart with a shape. For a simple schedule, a short one-day duration can also make the milestone visible, but label it clearly so readers do not mistake it for a full task period.

Improve readability and maintainability

Give the chart a specific title, such as “Website launch schedule,” and keep the task names concise. Remove unnecessary chart elements, but retain enough date labels and gridlines to help readers estimate timing. If the plan spans several months, avoid squeezing every day onto the axis; choose a sensible major unit and let the bar positions convey the detail.

For a schedule that will change, convert the source range to an Excel table with Insert > Table. Tables can expand as rows are added, although chart series do not always pick up every change exactly as expected if the chart was created from a fixed range. After adding tasks, verify the chart’s source through Chart Design > Select Data and extend the series ranges if required. Keep task names unique where possible; duplicate names can make a chart difficult to interpret even when the plotted values are correct.

To show progress, do not simply replace duration with percent complete: that changes the meaning of the timeline. One option is to add another series representing completed days and use a second color, while preserving the full duration as the planned total. That setup takes more careful series design. For a basic status view, a separate progress column or a label beside each task may be clearer than trying to pack too much information into one bar.

Common problems and fixes

  • Bars all begin at zero: The Start series may be missing, or the chart may be a clustered bar chart. Confirm that both Start and Duration appear in Select Data and that the chart type is Stacked Bar.
  • Bars start at the right date but the offset is visible: Format the Start series and set Fill to No fill and Border to No line. Do not remove the series from the chart.
  • Every bar has the same apparent length: Check that you did not choose 100% Stacked Bar and that Duration contains numeric day counts rather than text.
  • The chart shows large numbers on the date axis: Apply a date number format to the horizontal value axis. Confirm that the source start dates are actual Excel dates.
  • Task order looks upside down: Use Categories in reverse order on the vertical category axis, then review where the date axis crosses.
  • Bars appear one day too long or short: Confirm whether the duration calculation is elapsed days or inclusive days. For an inclusive count, the duration includes an added day.

Also distinguish calendar-day schedules from working-day schedules. A basic chart treats dates as a continuous timeline, so weekends remain part of the axis and a Friday-to-Monday task spans the weekend. If you need bars that exclude nonworking days, calculate the schedule around a working-day calendar and consider whether a simple date axis still communicates it honestly. Do not hide weekends by changing bar lengths without making the schedule’s convention clear.

When this method is a good fit

A stacked-bar Gantt is a good choice when you need a quick, readable timeline that can be edited in a worksheet and shared as part of a report. It is flexible in appearance and uses familiar Excel data. It works especially well for a modest number of tasks with straightforward start dates and durations.

For large plans with dependencies, shifting baselines, resource allocation, or automated workday scheduling, a spreadsheet chart may become cumbersome. Dedicated project-planning software can handle those relationships more directly. Excel remains useful for a presentation view or a lightweight plan, but the chart itself does not enforce a project’s logic. If you only need to compare totals across categories rather than show timing, a regular stacked bar chart is more appropriate; the invisible-start technique is specifically for a timeline.

Frequently Asked Questions

Can Excel make a Gantt chart without a template?
Yes. Create a stacked bar chart from task names, start dates, and durations, then set the Start series to No fill. A template can save setup time, but it is not required.

Why use a stacked bar chart instead of a regular bar chart?
A regular bar chart starts each bar from the same baseline. The stacked chart uses the first, hidden series as an offset, allowing each visible duration bar to begin at its own start date.

Should I use Stacked Bar or 100% Stacked Bar?
Use Stacked Bar. The 100% option converts each row into a percentage of its total, so the visible bars no longer show the actual relative timing and duration.

Can I show weekends in an Excel Gantt chart?
Yes. The normal date axis includes weekends as calendar days. That is often useful for elapsed-time schedules, but it does not mean work is planned on every weekend. For working-day schedules, calculate dates and durations using an appropriate work calendar.

Will new tasks appear automatically when I add rows?
They may if the chart references an expanding Excel table, but check the chart source after adding rows. Choose Chart Design > Select Data and confirm the task labels and both series include the new records.

Related

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.