Get Access to World’s largest Template Library & Tools

How to Create a Gantt Chart in Excel Easily – Tutorial

How to create a Gantt chart in Excel tutorial below will help you to simplify the step by step of it. The Gantt chart is usually used for project management. Some people may call it as a horizontal bar chart. This Gantt Chart Template is very popular with the horizontal lines that mention the completed work or other activities.

Gantt is essentially a production control tool which was founded by an American engineer and social scientist, Henry L. Gantt in the year 1917. Over the decade or so, MS Excel has become an integral application and its popularity and utility in projects – personal and professional – continues to increase significantly. The reason that was mentioned is because MS Excel was used to create this Gantt chart sample.

Because people always want everything in easier way, then here we go: the easier way to create the Gantt chart.

Step 1: Do the Project Tasks

do the project tasks

Step 2: First after your Gantt Chart is on, Start Setting it up to the Stacked Bar Chart

first after your gantt chart is on start setting it up to the stacked bar chart

Step 3: Add your data on your Gantt chart

add your data on your gantt chart

adding your data into your gantt chart

Start Adding your Data

  1. Name your data (Series) by clicking your cursor in the empty space (it is located under the Series Name). Click on the column header which has Start Date in the table.
  2. Move down to the next step, which is the Series Value. The Task starts to be entered here. A spreadsheet with a little red arrow will be seen on the right of Series values. While opening the Series Values, there will be a smaller Edit Series window. Then, click the first start date and drag it into the last one. It creates highlights that will copy your tasks into your Gantt chart. Remember not to highlight the header or other mistaken cells.
  3. After finishing this step, click the icon of small spreadsheet once more.

start adding your data

Step 4: Add the Task duration and repeat the explained steps above

While on the Select Data Source window, click the Add button and go to Excel’s Edit Series window. In this step, you can start adding your Task duration by following the third steps.

The duration data is starting to add into the chart

  1. Click on the empty space on the Edit Series window (under the Series name). Click on the header that shows Duration.
  2. On the Edit series window, move to the Series value and then click on the icon with a small red arrow. After got finished, click that small icon once more.
  3. Click your Duration data by the first and drag to the last Duration data. All you Duration data are highlighted. To exit, click the icon with red arrow, click OK while arriving to the previous window and you will get back to the Select Data Source window. For building your Gantt chart, click OK.

Step 5: Formatting your Gantt Chart

Click on the blue part to select all the tasks bars, do the right-click and select the Format Data Series to go to the Format Data Series window.

Stay close on the Format Data Series window and click Fill & Line icon (the icon is similar to the paint cat). Under Fill, select the button of No Fill and No Line (under Border). Remember not to close this Format Data Series because you will still need it.

To reorder your data (the top and bottom chart), try this out:

More in Tutorials

How to Create a Professional Resume Using Microsoft Word - TutorialHow to Write a Cover Letter - Tutorial
How to Write a Professional Resignation Letter - TutorialHow to Make/Create a Thank You Letter for a Scholarship [Templates + Examples] 2023
How to Create a Lesson Plan in Word - TutorialHow To Make/Create a Business Letter [Templates + Examples] 2023
How to Create an Affirmative Action Plan - TutorialHow to Create a Gantt Chart in Excel Easily - Tutorial
How to Create a Resume on a Mac - TutorialHow to Create an Action Plan - Tutorial
How to Create a Lesson Plan for Elementary School - TutorialHow to Create a Family Tree Chart in Excel, Word, Numbers, Pages, PDF - Tutorial
How to Create a Pie Chart in Microsoft Excel - TutorialHow To Make/Create a Receipt [Templates + Examples] 2023
How to Create a Project Schedule in Excel - TutorialHow to Make a Certificate in Microsoft Word - Tutorial
How to Create a Calendar in Word - TutorialHow to Create a Birth Certificate using Word - Tutorial
How to Create a Calendar in Excel - TutorialHow to Make a Gift Certificate on Microsoft Word - Tutorial
How to Create a Family Tree in Microsoft Word - TutorialHow to Make/Create a Timeline in Microsoft Word [Templates + Examples] 2023
How to Create a TimeSheet in Excel - Tutorial5+ How to Make an Inventory Using Excel - Tutorial
How to Create an Invoice on ExcelHow to Create Receipts in Excel
How to Create a Family Tree in PowerPoint - TutorialHow to Use Bootstrap Tooltip
How to Use Glyphicons in Bootstrap 3How to Create Custom PHP Contact Forms
How to Use PHPBrew & VirtPHP - TutorialUnderstanding Bootstrap Grid - Column Wrapping
How to Create a Basic Timeline Template in Excel 2023 - Tutorial10 Top YouTube Channels for Game Development Tutorials in 2023!
What is a CSS Preprocessor and Why You Should Use IT?25+ Great Examples of InDesign In Use - Tutorials
Top Ui Photoshop Tutorials for Freshers5 Tips to Make Your Website Invincible From Hackers!
20 Easy Illustrator Tutorials For Beginners!19+ Illustrator Tutorials For Creating Isometric Illustrations!
20+ Useful Responsive Web Design TutorialsHow to Make an App - Free Online Tutorials
Html5 Tutorial for Beginners - Techniques and Examples
bottom banner