How To Do Gantt Chart In Excel

In this Gantt chart Excel for Microsoft 365 step-by-pace tutorial we volition prove you lot how to make professional Gantt charts using Microsoft Excel and PowerPoint.

We have created a preformatted Gantt chart template in Excel for y'all. It provides a simple, straightforward way to add your project data, job, dates, and notes into the spreadsheet. All that information will automatically appear in the Gantt chart.

Click hither to download the Gantt chart template for Excel. Follow the below steps to create a unique Gantt chart for your project from scratch.

What is a Gantt nautical chart?

A Gantt chart is a timeline of your project. Project management requires knowledge, and skills on project activities to encounter the projection requirements. When it comes to managing projects, you demand tools to make them manageable. Professionals use Gantt charts to visualize how highly circuitous tasks can be broken down into smaller processes.

Microsoft Excel does not have a congenital-in Gantt chart template as an option. We volition show you how to create a Gantt chart in Excel using the stacked bar chart and a chip of styling and formatting.

Using Vizzlo's Gantt chart template can salvage yous a lot of fourth dimension. All you need to practice is create an account and you lot are ready to start! You will be able to add together milestones, dependencies, adjust tasks and activities using drag and drop simplicity, high-quality download, and y'all tin can connect your Gantt chart with a public Google Sheets or Microsoft Excel file directly. This volition save you even more time if you update your data frequently. Besides, Vizzlo's native PowerPoint add-in and Google Slides addition arrive easy to seamlessly integrate into your favorite presentation tool.

Start creating your ain gantt chart.

Try Vizzlo for gratuitous

How to make a Gantt chart in Excel

Would you similar to learn how we created this Gantt chart from scratch in Microsoft Excel? Follow the instructions beneath to create a Gantt chart in Excel.

1. Create a projection table in the Excel worksheet
2. Insert a Stacked Bar nautical chart
3. Formatting the Gantt Chart and its data
4. Alter the properties of your tasks

Create a project tabular array in the Excel worksheet

The start stride to your Gantt nautical chart in Excel is the information. Enter your project table and list each job is a separate row. Structure your projection plan by including the Task, Progress, Kickoff date, End appointment, and Duration to complete the tasks.

The two columns we volition need to create the Gantt chart are Beginning and Duration. Note that you tin can use Excels formula to create the Duration column: Duration = End Date - Start Engagement

Insert a Stacked Bar chart

Select the values of the column Offset including the cavalcade header. Select the values of the column _Start _including the cavalcade header. Switch to the Insert tab → under the Charts group and click Bar. Under the 2-D Bar department, click Stacked Bar.

When you clicked on Stacked Bar chart, you should see this effect:

Formatting the Stacked Bar nautical chart and its data

You demand to add together a second series to your nautical chart to make information technology wait like a Stacked Bar chart. This is when we demand to add the Duration column to your existing chart. To so, right-click anywhere on the chart, in the menu that will and then open cull the option Select Data…

… this will open up a dialog called Selected Data Source. To add a second series besides the already selected Start series click on the Add button.

The Edit Series dialog opens and you see two input elements:

1. Series name
2. Series values

To add together a series proper noun click in the cavalcade header, i.e. click on the cell that says Duration. Alternatively, you can blazon "Duration" or any other name in this field.

Remove the content from the Serial values input element and then select on the first cell in the Duration that contains a value and drag the mouse downward to the last value.

Click Ok to shut the carte and this will bring you back to the Selected Data Source dialog. The chart that yous will go as effect will look like this:

Turn a Stacked Bar chart into a Gantt chart

To make a stacked column chart look like a Gantt nautical chart, nosotros have to make i of the two series 'disappear'. In the end one series will be looking like the floating tasks that make the typical look of a Gantt chart. The goal is to hibernate the blue confined and then that merely the orange parts are visible. Technically nosotros need to keep the blue confined as a zero baseline. So let'due south make them transparent.

At present the next steps are:

• change the labels of the y-axis
• contrary the y-axis
• arrange the x-axis range
• flip the x-axis

Alter the labels of the y-axis

Nosotros are going to use the values from the Chore column of our information table as labels of the y-axis. To change that:

1. Right-click on the y-axis
2. In the dialog that opened click Select Information…
3. On the bottom right of the Select Information Source dialog under Horizontal (Category) Axis Labels click the Edit push
4. Select the values of the Task cavalcade
5. Press Ok

Reverse the y-axis

Select the y-axis to open the Format Centrality dialog. Under the department Axis Options click the checkbox at the bottom called Categories in contrary order.

Adjust the x-axis range

You take noticed that the ten-axis range does not start at the first twenty-four hour period of the first job. We can alter the axis range easily. Maybe the tricky est part is to know how Microsoft Excel handles date values.

Excel stores dates every bit sequential serial numbers so that they can be used in calculations. By default, January one, 1900 is serial number 1, and March 16, 2019 is series number 43540 because information technology is 43,540 days afterwards January 1, 1900. You can see that when y'all select a prison cell and change the format from Date to, due east.g. Full general. We will use the 43540 as the minimum of the axis range.

To modify the axis range you lot need to select the axis beginning. Then in the sidebar you tin can change axis properties. Under Axis Options there is a number input in which you need to enter 43540. Voilà.

Flip the x-centrality

Because we reverse the y-axis before, the x-centrality labels are now shown on height of the chart. We can change that with a few clicks too.

How to make a Gantt chart in PowerPoint

Microsoft PowerPoint is generally a ameliorate choice for making Gantt charts for your presentations and reports. Vizzlo offers a PowerPoint add-in that makes and updates Gantt charts by importing or pasting from Excel.

The benefits of using Vizzlo are:

— Import your data every bit Excel file, a .CSV file, or connect to Google Sheets

— You can schedule automatic updates of your charts

The next steps will show you how to turn the Excel table yous created higher up into a PowerPoint Gantt chart using Vizzlo.

Source: https://vizzlo.com/data-viz-guide/gantt-chart/how-to-make-a-gantt-chart-in-excel/

Posted by: weiserthatrepasis.blogspot.com

Share this post