Excel to PowerPoint Gantt Chart: Create and Share It

To put an Excel Gantt chart in PowerPoint, build it in Excel as a stacked bar chart, select the chart, and copy it; in PowerPoint, choose whether to embed it, link it to the workbook, or paste it as a picture. The best choice depends on whether you need to update the slide when the schedule changes or simply show a stable snapshot.

What an Excel-to-PowerPoint Gantt Chart Is

A Gantt chart displays tasks as horizontal bars positioned along a time axis. Excel does not have a dedicated Gantt chart type in its standard chart gallery, but a stacked bar chart can represent one: the first series creates the bar’s start position, while the second series sets its visible length. The first series is then hidden, leaving bars that appear to begin on their scheduled dates.

PowerPoint can display that Excel chart in several ways. An embedded chart carries its own copy of the chart data, a linked chart refers back to the Excel workbook, and a picture is a fixed visual with no chart data to edit. These are different from importing an entire worksheet: copying the chart itself generally gives you a cleaner slide and avoids bringing along unused cells.

Prepare the Excel Task Data

Set up a simple table in Excel for Microsoft 365 on Windows. Use one row per task and include a task name, a start date, and a duration. For example, a website project might have Discovery starting April 1 for 5 days, Design starting April 4 for 8 days, and Development starting April 10 for 12 days. The overlapping dates show that some work can proceed in parallel.

Enter real Excel dates in the Start column, rather than date-looking text.
Enter duration as a number of days. Decide whether your schedule uses calendar days or working days and apply that convention consistently.
Keep task names concise enough to fit beside the chart bars on a slide.
Use a separate table for owners, notes, or status if those details would make the chart hard to read.

A date-based chart’s time axis represents calendar dates. If a task takes eight working days, its bar will span the calendar interval between its start and finish; weekends do not automatically disappear from the axis. For a high-level presentation this may be acceptable. If the distinction matters, create a schedule with appropriate start and finish dates or use a project-planning tool designed to handle working calendars.

Build the Gantt Chart in Excel

Select the task names, start dates, and durations, then choose Insert > Insert Column or Bar Chart > 2-D Bar > Stacked Bar. If the columns are not adjacent, select the task-name column and the two value columns while holding Ctrl on Windows. Check the chart’s data series before formatting: it needs Start and Duration as the two stacked series, with task names as the category labels.

Click the chart, then choose Chart Design > Select Data if you need to correct the series or category labels.
Click a bar belonging to the Start series. Right-click and choose Format Data Series, then set its fill to No fill and its border to No line. This hides the offset series without removing its positioning effect.
Right-click the vertical task axis and choose Format Axis. Under Axis Options, enable Categories in reverse order if you want the first task at the top. Excel’s axis settings can also place the horizontal axis at the top or bottom, so check the result after reversing categories.
Format the horizontal date axis to show a useful range and date units. Right-click it and choose Format Axis; adjust its bounds or major units if the chart shows too much empty time or overly crowded labels.

Because the chart uses numeric date values behind the scenes, the horizontal axis may initially show numbers or an unhelpful date range. Setting a date number format and sensible minimum and maximum bounds makes the schedule easier to interpret. Add a chart title, use a small number of clear colors, and remove a legend if its labels do not help the reader. A legend can be useful when color distinguishes task groups, but it is usually unnecessary when the hidden Start series is the only other series.

Make It Readable on a PowerPoint Slide

Before copying, resize the chart in Excel so its proportions are close to the slide area you need. In PowerPoint, a wide chart often works better on a landscape slide than a tall chart with many task names. If the chart contains dozens of tasks, consider splitting it across slides by phase instead of shrinking the text until it becomes unreadable.

Review the chart at presentation size, not just while zoomed in on the worksheet. Check that task names, date labels, and any milestone or phase colors are legible against the slide background. A chart that looks polished in Excel may need a larger plot area or fewer axis labels once it is placed beside a slide title or explanatory text.

Copy the chart by clicking its outer border and pressing Ctrl+C on Windows. In PowerPoint, select the destination slide and use the paste options that appear after pasting. On Mac, use Command+C and Command+V; the available chart paste choices and menu labels can differ by Office version, so inspect the paste menu rather than assuming a particular option is present. Copying the chart object is preferable to selecting worksheet cells if you want the whole chart rather than a table.

Choose Embed, Link, or Picture

PowerPoint’s paste choices determine what happens when the slide or workbook changes. The labels can vary slightly by version, but the practical choices are usually equivalent to these:

Embed the workbook data: The chart is stored with the presentation. You can edit its chart data from PowerPoint, but later edits to the original Excel file do not automatically update the slide. This suits a self-contained presentation.
Link to the Excel workbook: The presentation refers to the source file, so changes in Excel can be reflected in PowerPoint when the link is updated. Choose this when Excel is the maintained schedule and the presentation needs to track it.
Paste as a picture: The chart becomes a static image. It is easy to move and will not change because someone edits the workbook, but its bars and data cannot be edited as a chart in PowerPoint.

On Windows, common chart options include Keep Source Formatting & Embed Workbook, Use Destination Theme & Embed Workbook, and corresponding choices that link data, plus a picture option. The source-formatting choice preserves Excel’s appearance; the destination-theme choice applies more of PowerPoint’s visual styling. If you need a particular option, use the paste-options menu or Home > Paste rather than relying on the default paste.

Keep a Linked Chart Updated

A linked chart is useful only if PowerPoint can still find the workbook. Save the Excel file in a stable shared location before creating the link, and avoid renaming or moving it afterward. A link to a workbook stored on one person’s local desktop may fail for colleagues who open the presentation on another computer.

When the source data changes, open the presentation and update the link if PowerPoint prompts you. The exact link-management commands can vary across Office builds, but Windows PowerPoint includes link controls under File > Info when the presentation contains external links. If the link is unavailable, check the source file path and permissions. For a presentation that must work without access to the workbook, embed the chart or paste a picture instead.

Linking does not guarantee that every formatting change in Excel will be reflected exactly as expected. Review the slide after updating, particularly if the chart’s dimensions, fonts, or date range changed. For a recurring report, keep a clear source workbook and update the presentation from that file, rather than making separate edits to the chart in both applications.

Common Problems and Practical Fixes

Bars start at zero: The Start series may still be visible, or the chart may be a clustered bar chart instead of a stacked bar chart. Confirm that the type is Stacked Bar and make the Start series fill and line invisible.
Tasks appear in the wrong order: Reverse the category order in Format Axis, then inspect where the date axis crosses the task axis. Reversing categories can change the axis layout.
The date labels look like serial numbers: Format the horizontal axis as dates and check that the source start dates are actual Excel dates.
The linked chart does not update: Confirm the workbook still exists at the linked location and that PowerPoint has permission to access it. Update the link, then check the slide.
The chart is blurry: You may have pasted a picture or enlarged a low-resolution image. Recopy the chart and use an embedded or linked chart object when editability and crisp scaling matter.
The slide is too crowded: Reduce the date range, simplify labels, or divide the plan into separate slides. Making every task fit on one slide is not always the clearest choice.

When Another Approach Makes More Sense

If the audience only needs to see the schedule, a picture is often the most reliable option: it avoids broken links and accidental data edits. If the presentation must remain editable but should not depend on an external file, embedding is a sensible middle ground. If Excel remains the authoritative schedule and the deck is updated regularly, linking can reduce repeated manual work, provided the workbook stays accessible.

For complex plans with dependencies, resource assignments, working calendars, or frequent schedule changes, building and maintaining the chart directly in Excel can become cumbersome. A dedicated project-management application may handle those planning rules better. PowerPoint is primarily for communicating the schedule, not for managing every operational detail behind it.

Frequently Asked Questions

Can I convert an Excel Gantt chart into an editable PowerPoint chart?
Yes. Copy the chart and paste it as an embedded chart, or link it to the workbook. An embedded chart can be edited in PowerPoint using its chart data; a linked chart uses the Excel source. A pasted picture is not an editable chart.

Will a PowerPoint chart update when I change Excel?
Only if you paste it as a linked chart and the source workbook remains available. An embedded chart contains its own data copy, while a picture is static. Check the slide after updating a link.

Can I make a Gantt chart in PowerPoint without Excel?
Yes, you can draw bars and labels using PowerPoint shapes, or build a table-like graphic. That can work for a small, rarely changing schedule, but manually positioned shapes do not automatically track dates or Excel data.

Why does my Gantt chart show dates as numbers?
Excel stores dates as serial values for charting. Format the horizontal axis as dates and verify that the source cells contain real dates rather than text. Adjust the axis bounds if the displayed period is not useful.

Should I link or embed the chart for a presentation?
Link it when the workbook is the maintained source and the deck should reflect later schedule edits. Embed it when the deck must carry its own editable data. Use a picture when a stable, non-editable snapshot is more important than future updates.

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.