Office Timeline Pro is here!
Create impressive Swimlane slides and Roadmaps with the Pro add-in.
Open PowerPoint, select Layout from the Home tab and then choose the Blank type for your slide.
Go to the Insert tab.
Click on Chart from the Illustrations section.
Select the Bar category from the All Charts list.
Choose the Stacked Bar type for your Gantt chart.
After completing all the steps listed above, a standard chart like the one below will be inserted onto your PowerPoint slide, along with an Excel table pre-filled with placeholder data, which you can replace with your own.
Quick tip: You can change the style and color scheme for your chart by clicking on the small brush symbol on the right side of the graphic.
To start working on your Gantt chart, you first need to break down your project into main phases or tasks, which will make up the basis of the graphic. After defining these project tasks, assign a start date, end date and duration (number of days required to carry out a task) to each of them:
List your tasks’ descriptions or titles in column A of the Excel table opened by PowerPoint (you can just replace the existing data with your own). As you insert the task names, the items will be stacked upwards on the graphic, with the first task being at the bottom of the graphic and the last one displayed at the top.
Rename the column entitled Series 1 into Start Date, the Series 2 column into End Date, and the last column into Duration (days).
Before entering the dates of your project tasks under Start Date and End Date, you may need to format the two columns to properly display this type of content. To do so, select columns B and C, right-click on them, and choose Format Cells from the menu that appears.
In the Format Cells dialogue box that pops up, select Date from the Category list on the left, and then pick the desired date format from the Type menu.
Once you’ve set the right format for the Start Date and End Date columns, insert the dates for each of your tasks. Note: Don’t worry if your chart looks like it’s “broken” after entering your dates. This is normal and we’ll deal with it very soon, after filling out the Duration column.
To calculate the duration of your tasks, type the formula =$C2-$B2 in cell D2 (the one corresponding to your first task). Next, select the cell, and then drag its fill handle (the small green square at the bottom-right corner of the cell) downwards across the column. This will apply the same formula to the other cells under the Duration column and fill them with the appropriate count of days.
After calculating the task durations, you can now remove the End Date series from the graphic - this will make room for the Duration series to be easily visible and get your graphic closer to what it should look like. First select your chart, and then:
i. Click on the Chart Filters icon visible in the upper right of the visual;
ii. In the Series group, uncheck the box next to End Date;
iii. Click on Apply.
After filtering out the End Dates, your chart should now look like this:
You have built a stacked bar chart so far. To turn it into a Gantt chart, you need to format the graphic so that the blue sections become transparent and only the grey ones remain visible. The remaining bars will represent the tasks of your Gantt chart. To do this:
Click on any of the blue bars on your chart. This will select all of them at once.
Right-click on the selection to open the mini toolbar.
In the mini toolbar, click on the Fill icon and select No Fill.
Your Gant chart should now look like this:
Now that you’ve outlined your Gantt chart, you can customize it further to make it look more unique:
To change the color of all tasks simultaneously, click on any of them once to select them all, right-click the selection, and go to Fill in the mini toolbar, where you can choose whatever color you please. In my example I chose a dark red.
If you wish to make individual tasks stand out, you can easily recolor each of them. Simply click twice on the desired task to select it and use Fill to choose a new shade for it.
You can also apply a variety of styles and effects to your graphic using the Chart Tools Format tab on the ribbon. However, I’d recommend keeping such effects to a minimum to ensure legibility. In my example, I chose to add a shadow to the plot area to make it stand out better.
You might also want to reverse the order of tasks so that the first one is displayed at the top of your Gantt chart and the last one at the bottom. To do so, double-click on the list of task descriptions on the left side of the graphic. This will open the Format Axis pane, where you’ll need to tick the checkbox in front of Categories in reverse order, under the Axis Options group.
Once you do so, you will notice that the order of tasks has been reversed, with the date markers having also been moved from beneath to the top of your Gantt chart.
To bring your tasks closer to the vertical axis of your Gantt chart, you’ll need to remove some of the blank space where the blue bars used to be. To do so:
i. Select any of the dates above the bars, right-click on the selected area and choose Format Axis from the small menu that pops up.
ii. In the Axis Options window opened on the right, increase the Minimum Bounds number under the header called Bounds to adjust the leftmost boundary of your chart. In my case, I changed the initial number from 43200.0 to 43300.0.
As a final adjustment, I also wanted to remove the legend from my graphic as I felt it created more confusion rather than help. To do so, I simply selected it and pressed Delete. In the end, my PowerPoint Gantt chart looked like this:
Manually building a Gantt chart in PowerPoint is not so complicated, but it does take time and effort. To make the whole process simpler and more time-efficient, you can use an intuitive add-in for PowerPoint called Office Timeline. It allows you to use pre-formatted Gantt chart templates and copy-paste or import data from Excel and other productivity tools.
In the steps below, I will show you how to automatically make a Gantt chart using the PowerPoint add-in. To get started, you first need to install Office Timeline Plus, which will add a Gantt chart maker tab to the PowerPoint ribbon.
Go to the Office Timeline Plus tab you’ll see on the PowerPoint ribbon and click on New.
This will open a gallery where you can choose from a variety of templates and styles to use for your graphic.
Double-click to select the template you prefer and then click Use Template in the preview window. For my example, I will use a custom Gantt template made earlier.
Now, in the Data Entry wizard, you can either enter your tasks and dates manually, or you can
them from an existing Excel file. Here is where you can also make a few customization choices, such as changing the shape or color of each task. When ready, click the Create button.
Depending on the template chosen and the customizations you make, you can get a Gantt chart that looks similar to this:
Once generated, your Gantt chart can be restyled or updated automatically using Office Timeline Plus. You can add or edit data at any time, format fonts and shapes, and include details such as task duration, percent complete or Today marker, among others. In my example above, I’ve entered a few milestones too, repositioned task titles, and added % complete to provide more clarity.