How to Make a Gantt Chart in PowerPoint

Đỗ Thủy02/12/2022

0 2 3 minutes read

Create your own or use a PowerPoint add-in

what you need to know

Creating a Gantt chart in PowerPoint is done by editing the stacked bar chart on the slide and making the bar set invisible.
You can save the slide as a template and reuse it by editing the data below. insertion > Chart > Edit the data.

This article outlines how to create one using the tools available in PowerPoint and outlines the other options.

How to Create a Gantt Chart in PowerPoint

Gantt charts are named after Henry Gantt and provide a visual representation of the time it takes to complete a task step. How to make one in PowerPoint.

Open a blank slide in PowerPoint, and then insertion > Chart.

Choose from the open menu bar > stacked chart. A sample chart with a table to which you can add data is automatically created on the slide.

Assign a row to each phase in the project and label the columns with start date, end date, and duration. Leave the period blank for now.

The chart is loaded with data for the top bar below, so it can be confusing. As you make changes to the lines, they are updated automatically, so you can review your work and make sure the lines are in the correct order.

Display Start Date and End Date columns, then right-click and select Format Cells. Choose date In the window that opens, select from the desired category and format.

You can also set the format to hours. If you need a Gantt chart for the day, use it instead.

Add the start and end dates for each task. Data changes have not yet been reflected in the chart. So don’t worry that all the bars look the same.

Enter formula =$C2-$B2 Type in the first cell under Duration and press Tab. Then use the small rectangle (“Fill Handle”) in the lower right corner and drag it down until you reach the last step in the diagram. The period is automatically filled in.

Click the chart on the slide and select it. filter iconUncheck End Date and click. use. This option offsets the bars instead of keeping them uniform.

Select “.start date” Latch. Select one and all will be highlighted. Right click and Fill and choose no filling.

To color-code each task, double-click on the bar to open the Format menu for that individual part.

This option makes these bars invisible.

The finished Gantt chart.

Do I need to manually create a Gantt chart or use an add-on?

This process can take some time, but remember that there are several add-ins for Microsoft Office that automate this. Enter the necessary data and they do the rest.

However, most of the add-ons we found were subscriptions rather than software, some costing us $149 per year. Formatting these charts is a good idea unless you create them regularly or design more complex charts.

A more viable option is to do this process once, save the results, and then copy the slides and edit the data whenever you need a new chart. move file > save a copy Give it a different name. then go Chart > data editing Modify the details as needed.

Frequently Asked Questions

How to create a Gantt chart in Excel?
Excel doesn’t have a Gantt chart feature, but you can use a stacked bar chart to show the start and end dates of tasks, which you can customize. To do this, select the data and insertion > Insert bar chart > stacked bar Chart. To make the stacked bar chart look like a Gantt chart, click the first data series and click format > mold filling > no filling.
How do I create a Gantt chart in Google Sheets?
To create a Gantt chart in Google Sheets, create a project plan, create a calculation spreadsheet, and then create a Gantt chart. To create a Gantt chart, select all cells in the calculated table and insertion > Chart; A new chart is displayed. start date and total duration. Place it under the table, select and select. chart editthen select stacked bar chart. move To adjust > series > Applies to all series > start date. Choose Color > doesn’t exist.

More information

How to Make a Gantt Chart in PowerPoint

Build one yourself or use a PowerPoint add-in

What to Know
Creating a Gantt chart in PowerPoint is done by editing a stacked bar chart in the slide and making one set of bars invisible.
You can save the slide as a template and reuse it, by editing the data under Insert > Chart > Edit Data.

In this article, we’ll lay out how to design one using the tools available in PowerPoint, and briefly discuss other options.

How to Make a Gantt Chart in PowerPoint

A Gantt chart is named after Henry Gantt and lays out visually the time it’ll take to complete the sections of a task. Here’s how to build one in PowerPoint.

Open a blank slide in PowerPoint, then choose Insert > Chart.

In the open menu, choose Bar > Stacked Chart. A sample chart with a table to add data will automatically be generated in the slide.

Give each phase of your project a row, and name the columns Starting Date, End Date, and Duration. Leave Duration blank for now.

The chart will load with the data for the top bar at the bottom, which can be confusing. It will automatically update when you change a row, so you can check your work and make sure your rows are in the correct order.

Highlight the Start Date and End Date columns, then right-click and select Format Cells. Select Date from the category and the format you prefer in the window that opens.

Notice you can also set the format to “time.” Use this instead if you need a Gantt chart for a single day.

Add the starting and ending date for each task. The chart won’t reflect the change in your data yet, so don’t worry that all the bars seem to be the same.

Type the formula =$C2-$B2 into the first cell under “Duration” and press Tab. Then use the small square in the bottom right corner (the “fill handle”) and drag that down until you’ve reached the last phase in your chart. The duration will automatically fill in.

Click on your chart in the slide, choose the Filter icon, uncheck “End Date,” and click Apply. This option staggers the bars instead of keeping them even.

Choose the “start date” bars. If you select one, it will highlight all. Right-click, choose Fill and select No Fill.

If you’d like to color-code each task, double-click on the bar, and you’ll open the formatting menu for that individual piece.

This option renders those bars invisible.

The finished Gantt chart. Should I Build Gantt Charts Manually or Use an Add-In?

Keep in mind while this process can be somewhat time-consuming, there are several add-ins for Microsoft Office that will automate constructing these; you fill in the needed data, and they do the rest.

That said, most add-ins we found were subscriptions, instead of software, with some running as high as $149 a year. Unless you’re making these charts regularly or are designing more complex ones, you’re probably better off formatting them.

A more viable option is to go through this process once, save the results, and then copy the slide and edit the data whenever you need a new chart. To do this, go to File > Save A Copy and give it a different name. Then go to Chart > Edit Data and revise your information as needed.

FAQ

How do I make a Gantt chart in Excel?
Excel does not have a Gantt chart function, but you can customize one by using a stacked bar chart to show the start and finish dates of tasks. To do this, select your data and go to Insert > Insert Bar Chart > Stacked Bar chart. To make the stacked bar chart look like a Gantt chart, click the first data series and go to Format > Shape Fill > No Fill.

How do I make a Gantt chart in Google Sheets?
To make a Gantt chart in Google Sheets, you’ll build a project schedule, create a calculation table, and then generate the Gantt chart. To generate the Gantt chart, select all cells in the calculation table and go to Insert > Chart; you’ll see a new chart called Start Day and Total Duration. Position it below the tables, select it, choose Edit Chart, and then select Stacked bar chart. Go to Customize > Series > Apply to All Series > Start Day. Choose Color > None.

#Gantt #Chart #PowerPoint