14 easy steps to create a gantt chart with Excel in 3 minutes
14 easy steps to create a Gantt chart with Excel in 3 minutes, just follow the steps shown in the photos and you can download the sample excel template.
Follow these simple 14 steps and Download Gantt Chart template at the end of this post.
Step No. 1: create a table contains your activity name, start date, duration and finish date.
Step no. 2:from the excel bar choose insert tape, then bar then choose stacked bar
Step no. 3: right click in the chart area and choose select data.
Step no. 3
Step no. 4: from the select data window click Add.
Step no. 5: Add the start date values into the series values.
Step no. 6: Add a new value same we did in step no. 4 for the duration.
Step no. 7: edit the horizontal axis values .
Step no. 8: add the activities names in the horizontal axis values.
Step no. 9: after adding all the data as per steps no. 5,6,7 and 8 just click OK
Step no. 10: Right click on the blue bar and choose format data series.
Step No. 11: from the fill menu choose no fill
Step no. 12: right click on the axis include the activities name and choose format axis
Step no. 12
Step no. 13: from axis options check categories in reserve order.
Step no. 13
Step no. 14: now you have a gantt chart matching with your data in step no. 1, whenever you change any date or duration the bar chart will be changed automatically.
Download the Gantt excel template:
Project Management Professional Templates 200+
- Project Management from Directory
Project Management from Directory includes all Project Management from and excel spread sheets for project management all in one place, all files c...
- Create Gantt Chart and cash flow using excel with sample file
How to create a time schedule, Gantt chart, Bar chart and cash flow using the attached excel sheet.
This Microsoft Excel sheet is fully automated a...
- paste values from single cell to merged cell in excel
paste values from single cell to merged cell in excel, merged cells causing lots of problems in copy paste right? How many times you needed to copy...
- Performance Management Plan Template
Performance Management Plan Template, this Performance Management Plan Sample is useful to monitor the performance of your management plan in high ...
- Video How to calculate working days using excel with sample
Definition of Working Days:
It is the period of time between two dates after deduction the week ends and the holidays, in other meaning the net eff...
- Progress planned vs actual progress excel template
Simple, fast Free Printable Spreadsheets Templates,and automated Progress planned vs actual progress template.
just fill the activity start and fin...
- Twelve month profit and loss projection excel template
Twelve-month profit and loss projection excel template, download this excel template and read the following instructions.
You should change "c...
- payment certificate excel template
payment certificate excel template is a document between contractor and client for Interim Advance Payment, Interim Progress Payment, Interim Excha...