If you haven't already, download our free Gantt Chart Excel template and follow along.
- Step 1: Name your project.
- Step 2: Add your tasks.
- Step 3: Update task start and end dates (and additional information)
- Step 4: Add milestones and color-code tasks.
- Step 5: Add more tasks and finalize your Excel Gantt Chart.
A Gantt chart helps you schedule your project tasks and then helps you track your progress. Click Insert > Insert Bar Chart > Stacked Bar chart. Next, we'll format the stacked bar chart to appear like a Gantt chart.
Here are 8 best practices you need to know when building your gantt chart to ensure that it will be as useful as possible:
- Enter tasks in groups.
- Get granular with tasks.
- Identify responsible parties (company, people)
- Be sure to display start and end dates for each task.
- Account for time off and holidays.
- Note dependencies.
Gantt charts are useful for planning and scheduling projects. They help you assess how long a project should take, determine the resources needed, and plan the order in which you'll complete tasks. They're also helpful for managing the dependencies between tasks.
How do I print just the Gantt chart in MS Project?
- On the File tab, click Print, and then click Page Setup.
- Click the View tab.
- Click to clear the Fit timescale to end of page check box.
- Click OK.
- Click the View tab.
- Back in the Project plan click View.
Steps to Create Milestone Chart in Excel
- Get the data in place.
- Go to Insert –> Charts –> Line Chart with Markers.
- Go to Design –> Select Data.
- In the Select Data Source dialogue box, click on Edit in Horizontal (Category) Axis Labels and select dates in Column E.
- In Select Data Source dialogue box, click on Add.
Project Management Basics: 6 Steps to a Foolproof Project Plan
- Step 1: Identify & Meet with Stakeholders. A stakeholder is anyone who is affected by the results of your project plan.
- Step 2: Set & Prioritize Goals.
- Step 3: Define Deliverables.
- Step 4: Create the Project Schedule.
- Step 5: Identify Issues and Complete a Risk Assessment.
- Step 6: Present the Project Plan to Stakeholders.
7 Alternatives to Gantt Charts
- Project management timeline.
- Project network diagram.
- Kanban board.
- Scrum board.
- Cross-functional flowchart.
- Project checklist.
- Simple Gantt chart.
Here are 4 ways not to use Gantt charts for project management.
- Don't use your Gantt chart for an initial project plan.
- Don't use your Gantt chart for resource management.
- Don't manually create your Gantt chart.
- Don't set your project plan in stone.
A Gantt chart is a graphical depiction of a project schedule. It's is a type of bar chart that shows the start and finish dates of several elements of a project that include resources, milestones, tasks, and dependencies. Henry Gantt, an American mechanical engineer, designed the Gantt chart.
Put simply, a project timeline tracks the chronological order of events. These timelines give teams an understanding of a project at just a glance, keeping everyone informed and aligned at every stage of the project. The timeline is composed of a series of tasks, each of which has a due date and duration.
A Gantt chart is a horizontal, timeline-based bar chart that represents a project plan in time. Start and end dates of tasks, milestones, dependencies between tasks, and assignees are classic components of Gantt charts.
Design a Gantt Chart in Canva in 5 easy steps
- Create a new Canva account to get started with your own Gantt Chart design.
- Choose from our library of professionally created templates.
- Fix your images, add stunning filters and edit text.
1 : a table listing important events for successive years within a particular historical period. 2 usually timeline ˈtīm-?ˌlīn : a schedule of events and procedures : timetable sense 2.
Print the timeline in Project
- Drag the line underneath the timeline to the bottom of the screen.
- Click File > Print.
To label your timelines, use the new “Bar Label” button in the format ribbon of your timeline. You can name each timeline individually. To adjust the timescale labels, click on the “Start” or “Finish” date on your timeline, and then click “Date Range” in the format ribbon.
