Be careful not to include the name of the column itself. When you are done, exit this window by clicking on the small spreadsheet icon again.
Your chart should now look something like this:. You have really built a Stacked bar chart. Now we need to format it so it looks like a Gantt chart. To do that, we must make the blue parts of each task bar transparent so only the orange parts will be visible. These will become the tasks of your Gantt chart. To select all of the tasks bars at once, click on the blue part of any bar in your Gantt chart, then right-click and select Format Data Series , which will bring up the Format Data Series window in Excel. Don't close the Format Data Series task pane because we're going to use it in the next step.
You probably also see that the tasks on your Gantt chart are listed in reverse order with the last task on top of the Gantt chart and the first Task listed at the bottom. This is easy to change in Excel. To do so click on the list of tasks along the vertical axis of your Gantt chart. This will select them all and it will also open the Format Axis task pane.
In the Format Axis task pane under the header Axis Options and the sub-header Axis Position put a check into the checkbox called Categories in reverse order. You will notice that Excel arranged your tasks into proper order, listing them from first to last on your Gantt chart. You will also notice that Excel moved the date markers from beneath to the top of the Gantt chart. Now it is really starting to look more like a Gantt chart should.
Removing some of the blank white space where the blue bars used to be will bring your tasks a little closer to the vertical axis of your Gantt chart. To remove some of the blank white space in the chart, click on the dates above the task bars. One click should select all the dates, then right click and select Format Axis to bring up Excel's Axis Options window. In the Axis Options window, under the header called Bounds, note the current number for Minimum Bounds. It represents the left most boundary of your Gantt chart.
Changing this number by making it larger will bring your tasks closer to the vertical axis of your Gantt chart. In my case I changed the original number which was At any time you can hit the reset button to return the original settings.
This gives you the opportunity to try a number of different settings until you find the one the makes your Gantt chart look best. In the same Axis Options window under the header Units, you can adjustment the spacing between each of the dates listed at the top of the horizontal Axis.
If you increase the unit number your Gantt chart will enlarge the space between each date, which will also lessen the number of dates your Gantt chart shows. Doing the opposite, reduces the space between each date and therefore crowds more dates onto your Gantt chart. In my case I changed the original number from 20 to Under the Series Options header you will find the Gap Width control.
Sliding it up or down will increase or reduce the size of your Task bars on your Gantt chart. Play around until you find something that best works for you. PowerPoint is graphical and a better choice for making Gantt charts that will be used in client and executive communications. Office Timeline is a PowerPoint add-in that makes and updates Gantt charts by importing or pasting from Excel.
You can copy-paste , import and synchronize your Excel tables in PowerPoint. This will open a gallery that will allow you to choose a style or template for your Gantt chart. From the gallery, double-click any template or style to select it and then click Use Template in the preview window to open the Data Entry Wizard. In this demonstration, I will be using a custom template. If you prefer to import and synch your Excel table, rather than copy-paste, select Import. You can copy them all at once, but be sure not to copy the title.
Then, make any edits you wish change colors or shapes, add or remove items, etc. Depending on the style or template selected, you will have a Gantt chart that looks like this:. From here, you can easily customize the Gantt chart further , adding milestones, formatting fonts and colors, and adding various details like percent complete or notes. It is easy to do in Office Timeline. In my example, I used Office Timeline Plus to add milestones, move task titles and date texts, change shapes, and add percent complete.
Thank you! Please check your inbox for download link and tips to get started.
Automatically create a Gantt chart in PowerPoint. Manually create a Gantt chart in Excel. List your project schedule in an Excel table. Begin making your Excel Gantt by setting it up as a Stacked Bar chart. Add the start dates of your Tasks to the Gantt chart. Now we're going to add your task data. To create a Gantt chart like the one in our example that shows task progress in days: Select the data you want to chart. Expand your Office skills.
December 6, at Your Excel chart is starting to look like a normal Gantt chart, isn't it? Post a comment Click here to cancel reply. To select all of the tasks bars at once, click on the blue part of any bar in your Gantt chart, then right-click and select Format Data Series , which will bring up the Format Data Series window in Excel. Quickly turn project data into professional timelines Build stunning, uncomplicated timelines and Gantt charts that are easy to make and simple to communicate. Removing some of the blank white space where the blue bars used to be will bring your tasks a little closer to the vertical axis of your Gantt chart. If you prefer to import and synch your Excel table, rather than copy-paste, select Import.
Get new features first. Was this information helpful? Yes No.
Any other feedback? How can we improve it? Send No thanks. Thank you for your feedback! It sounds like it might be helpful to connect you to one of our Office support agents.
Contact Support. Sample simulated Gantt chart in Excel and