Free Gantt Chart Template Excel Mac

Posted on by

This step-by-step Word Gantt chart tutorial illustrates how to create professional Gantt charts right inside the popular word processor.

  1. Gantt Chart Template For Mac free download - Gantt Chart Builder (Excel), Gantt Chart Designer, Gantt Chart, and many more programs.
  2. Download Gantt Excel - Free Gantt Chart Excel Template. Create Professional Gantt Charts in Microsoft Excel on Windows & Mac OS. Fully Automated and Easy to Use.
Chart

See our free Gantt chart template collection. This free Gantt chart template gallery was created for professionals who need to make eye-catching visuals for project presentations. Download the desired Gantt template as an editable PowerPoint slide or, where available, click on the Edit Online button to open it in your browser and update it.

Professionals who wish to create a Gantt chart in Microsoft Word can do so using the tool’s Stacked Bar feature and some manual formatting. However, since the software is primarily designed for editing copy and lacks a built-in Gantt feature, it may not offer too much flexibility when it comes to more refined customizations or regular updates.

If you need to create impressive Gantt charts and update them frequently for recurring presentations, PowerPoint may prove faster and more efficient. Below, I will demonstrate how to make a Gantt chart both manually in Word and automatically in PowerPoint. If you wish to learn how to make a timeline in MS Word, please see our timeline tutorial here.

Free Gantt Chart Template Excel Macro

Which tutorial would you like to see?

How to manually make a Gantt chart in Word

1. Build a basic Stacked bar graphic

  1. Open a new Word document and set the orientation of the page from Portrait to Landscape to get more space for your Gantt chart. To do so, go to the Layout tab on the Word ribbon and click on Orientation.

  2. Go to the Insert tab and select Chart from the Illustration section.

  3. In the All Charts window that pops up, select the Bar category and choose Stacked Bar as the type of graphic to use for your Gantt chart.

2. Add your project schedule data.

Once you complete the steps above, Word will generate a standard chart like the one below along with an Excel table where you can replace the placeholder data with your own.

Quick tip: You can change the type, style and color scheme of your chart from the Design tab highlighted in the image above or by clicking on the small brush symbol on the right side of the graphic. You can also resize the visual by clicking on the chart area and dragging its sizing handles until you reach the desired height and width.

Apple numbers gantt chart

Gantt Chart Excel Template Free Download Mac

To begin working on your Gantt chart, you first need to outline the main phases or tasks of your project. Once you determine the project tasks, you can then assign a start date, end date and duration (number of days in which a task is carried out) to each of them:

  1. Enter your tasks’ descriptions or titles in column A of the Excel table visible in your Word document. As you list the task names, the items will be stacked upwards on the graphic, the first task being displayed at the bottom of the graphic and the last one at the top.

  2. Rename the columns entitled Series 1, Series 2, and Series 3 into Start Date, End Date, and Duration (days), respectively.

  3. To properly display the start and end dates of your tasks, you may wish to format columns B and C before entering your data. To do so, select the two columns, right-click on them, and choose Format Cells from the shortcut menu. In the dialogue box that pops up, pick Date from the Category list and select the desired date format from the Type menu.

  4. Once the right format for columns B and C is set, you can type in your tasks’ Start and End Nhm writer latha tamil font. dates. Note: Don’t worry if the graphic seems to be off after you enter the dates. We will fix this quickly as soon as we fill out the Duration column.

  5. Calculate the duration of your first task by typing the formula =$C2-$B2 in cell D2. Then, select the cell and drag its fill handle downwards across column D. This will apply the same formula to the rest of the cells under Duration.

  6. Now that you’ve calculated the task durations, you don’t need the End Date series anymore, so you can remove it from the graphic to make the Duration series visible. To do so, select the chart and then:

    i. Click on the Chart Filters button (the funnel symbol on the right side of the graphic);

    Webkinz pet codes. ii. Uncheck the box to the left of End Date, under the Series group;

    iii. Click on Apply.

    Once you’ve filtered out the End Dates, your chart should look like this:

Gantt chart in os
3. Turn your graphic into a Gantt chart

Now your graphic is getting closer to a Gantt chart, but it’s not quite there yet. To turn it into a Gantt, you’ll need to make the blue bars transparent so that only the grey ones remain visible. The remaining bars will represent the tasks of your Gant chart. To do this:

  1. Click on any of the blue bars on your chart to select the whole series.

  2. Right-click on the selection.

  3. Free kayakalpa yoga in tamil pdf. In the mini toolbar that pops up, click on the Fill button and select No Fill.

    The resulting Gantt chart should look like this:

4. Customize your Gantt chart

With your Gantt chart ready, you can now make further customizations to personalize it and make it better fit for presentations.

  1. To make your graphic stand out more, you can apply a variety of styles and effects to it from the Chart Tools Format tab on the Word ribbon. In my example, I chose to add a slight shadow to the plot area using Shape Effects and applied a Quick Style to all the tasks to make them pop out.

  2. You can also recolor individual tasks to draw attention to particular phases or activities. To do so, select the desired task bar (you may need to click on it twice), then right-click on it, and then go to Fill in the shortcut menu to change its color.

  3. If you want to reverse the tasks’ order, double-click the list of task descriptions on the left side of the chart. Then, in the Format Axis pane that opens, you need to tick the checkbox in front of Categories in reverse order, under the Axis Options group.

    You will notice that the first task is now displayed at the top of your Gantt chart and the last one at the bottom, with the date markers also moved from beneath to the top of the graphic.
    gantt-chart-word

  4. To bring the task bars closer to the vertical axis of your graphic, double-click on the date series above the bars to open its settings in the Format Axis pane on the right. Here, in the Axis Options group, increase the Minimum number under the header called Bounds to adjust the leftmost boundary of your chart. In my case, I changed the initial number from 43200.0 to 43300.0.

  5. In my example, I also decreased the width of my task bars so there would be more space between them on the graphic. To do the same, select your tasks and then:

    i. Right-click on the selection and choose Format Data Series from the shortcut menu that appears;

    ii. On the right, under Series Options, increase the percentage in the box next to Gap Width. For my Gantt chart, I raised it to 175%.

  6. Finally, you may also want to remove the legend generated automatically by Word as it can be a little confusing. Simply select it, press Delete, and that’s it. In the end, your final Gantt chart can look similar to this:

Download MS Word Gantt chart template
Download PowerPoint Gantt chart template

How to automatically make a Gantt chart in PowerPoint

Making a Gantt chart in Microsoft Word is possible, but customizing and updating it can turn out to be too time-consuming. PowerPoint is a faster and simpler choice if you need to build impressive visuals for recurring communications.

Below you will learn how to automatically create a Gantt chart in PowerPoint using a lightweight add-in called Office Timeline. To get started, you first need to install Office Timeline Basic, which will add a Gantt chart maker tab to the PowerPoint ribbon.

1. Open PowerPoint and add your data into the Office Timeline Basic wizard

  1. Go to the Office Timeline Basic tab on the PowerPoint ribbon and click on New.

    You will be taken to a gallery with a variety of Gantt chart templates and styles you can choose from.

  2. Select the template you want to use for your graphic by double-clicking on it, and then click Use Template in the preview window. For my example, I will choose a custom Gantt chart template made earlier.

  3. Now, in the Data Entry wizard, you can either enter your task descriptions and dates manually or copy-paste them from an existing Excel schedule. This is where you can also start making a few styling choices, such as changing the shape or color of each task. When ready, click the Create button.

2. A new Gantt Chart slide will be instantly generated in PowerPoint

  1. Depending on the template used and the styling choices you make, you can get a Gantt chart slide similar to this:

  2. Once you’ve generated your Gantt chart, you can restyle or update it automatically with Office Timeline Basic. You can add or edit data at any time, change fonts, colors, shapes, positions or spacing, and include extras such as Time Elapsed, Task Duration or Notes. In my example above, I chose to insert a few milestones too, reposition task titles, and add Percent Complete to make the visual clearer.

How to make a PowerPoint Gantt Chart from Excel in less than 60 seconds:

Excel is one of the most known and used tools on the planet, so it’s no wonder teams around the world rely on it for task and time management. However, it takes precious time to manually create and organize different tasks along with their start and due dates, and it can quickly become outperformed by a dedicated Project Management software. So why not let the pros help? We have created a free and ready-to-download Inbound Marketing inspired Gantt chart Excel template, and it’s just one click away.

Free Gantt Chart Template Excel MacDownload the Free Gantt Chart Template for Excel 2021

We understand the essence of progress through task management, so we built a free pre-designed Gantt chart that will truly help you and your team. By using our pre-made free Excel template, you will only need to write down your tasks alongside your dates. And just like that, you’ll be able to visualize and print your project in a minute. Adjust your priority tasks, update your deadlines and automatically calculate duration. Follow the steps below to start using the easiest to use free Gantt chart Excel template around.

Do You Need Gantt Charts?

In this article, you will find a step-by-step guide to learn how to use our free Excel Gantt chart template (if you haven’t yet downloaded it, you can do it here). We’ve created this Gantt chart thinking of a quick and effective visual representation of a project, no matter what kind of project it may be. It is actually ready for you to start plugging in your own information, adding your dates, and begin tracking your progress, as easy as it really sounds.

1: Edit your tasks

Begin by renaming the pre-existing tasks to those that fit your project’s needs. You may do so by editing any task under the “Name” Excel column.

2: Update your dates

Now, you’ll need to edit your task’s start and end dates. These cells are pre-formatted as date cells (US format dictates Month, Day, Year, although you may change this format if and when needed).

3: Duration of tasks

We have pre-formatted our template so that each task is automatically calculated by subtracting the start date from the end date of each of your project’s tasks. You’ll notice how, as you enter your dates, the “Duration” column will populate on its own. Easy as that.

4: Fill in the user column

You may continue by assigning each task to different members of your team, so make sure to fill the “User” column with their own names. Also, you can edit the percentage on the “Progress” column depending on your task completion rate.

How to Customize your Free Excel Gantt Chart Template

Download the Free Gantt Chart Template for Excel 2021

Name your Gantt chart and start working on your project

You know your project better than anyone, so give it a proper title. You can customize our Excel Gantt chart template by simply selecting our sample title and changing and formatting the text as you normally would any text on an Excel file.

Change the colors of the bars

Gantt chart for numbers

You can freely edit the color of the Taskbar within your Gantt chart. This is especially useful in case you wish to assign a specific color to a team member or to separate your tasks by task type. In order to change the color of your tasks, click on a bar twice. Select the Excel paint bucket, and choose a color from the taskbar.

We're gonna need a bigger chart

We built a fairly decent list of tasks, but we are fully aware a project can be much more complex. So, in case you need more room for your tasks, you can simply add additional rows by highlighting the last filled row in the chart, clicking “Insert” and then selecting “Rows”. More rows with the same format will be added above.

Last step: Print your Gantt Chart

Good job! Your project is now print-ready. In order to only print your Gantt chart, head to the chart and click on any of its corners. You’ll notice the entire chart will be selected. Go up to File - Print - Print Selected Chart. In case you are using Mac, you’ll need to hover over your chart and drag out a selection until it covers the entire chart. Head over to File - Print Area - Set Print Area.

Good job! Your project is now print-ready. In order to only print your Gantt chart, head to the chart and click on any of its corners. You’ll notice the entire chart will be selected. Go up to File - Print - Print Selected Chart. In case you are using Mac, you’ll need to hover over your chart and drag out a selection until it covers the entire chart. Head over to File - Print Area - Set Print Area.

Apple Numbers Gantt Chart

You thought this was simple? Wait until you try building your own Gantt chart on Instagantt

There is nothing like building and managing your own project. Instagantt has been carefully designed to allow you to manage your schedules, timelines, tasks, and subtasks, while also collaborating and communicating with your team in one beautifully crafted software.
Task management is our core function, and we take it seriously. Our Drag & Drop option will change the way you think of editing dates, changing lengths, or creating dependencies, forever.
We believe every task is important when managing a project. So break down each task and carefully bring your projects to completion by adding subtasks. Mark especially important tasks with Milestones and feel the joy of completing parts of your projects by dividing it in Sections.

Instagantt is super easy to use. You’ll be creating Gantt charts like a pro in no time.
So start your free trial now: https://instagantt.com/login
‍Start by clicking on + New Workbook, and give your brand new workbook a proper title. You can begin by selecting Example Project on your menu, this is a great way to learn the basics.

You can now click on + New Project to start building your own Gantt chart. Give your project a name and click on Create. Your new project will now appear on the menu and you can start adding your tasks.

Once all your tasks and subtasks are all lined up, you may continue by assigning start and due dates to each of them. Also, you can write a basic description, add attachments, and simply manage every aspect of your project. Calculate the progress of your project by adding multiple subtasks; in case one of your tasks must be completed before you begin working on another task, you can add a dependency by dragging the corner to its predecessor and dependent task. And just like that, you can now start tracking your progress!

Quickly get a real sense of how much of your time and budget will be compromised on a specific task by completing the Estimated Hours, Actual Hours, Estimated Cost and Actual Cost fields. When creating tasks, simply click on the text field and type in the information.

Gantt Chart Pages

Keep your team members informed of what’s happening by mentioning them and linking specific tasks or projects to them. Simply type “@” following the name of your teammate. They will receive a notification via email when a new activity is linked to them.

Gantt Chart For Numbers

Instagantt also allows you to build ready-to-share online Gantt charts in minutes, virtually training free. Thanks to our Export & Share options, showing real-time progress becomes available in a second. Send an image, PDF, Excel file, or even a public snapshot of your work to your team or your clients.
We focus on efficiency and there are many ways in which Instagantt can help you. Whether you are a project manager, a marketer, IT manager, homeowner, contractor, freelance worker, content manager, contractor or a government agency, Instagantt will become a must-have tool in your day-to-day work life!