Free Gantt Chart Template Excel Mac

If you’re a project manager, regardless of the industry you’re working in, Gantt charts can be a very useful tool for managing your projects. Don’t want the hassle of creating your own Gantt chart from scratch? No problem! We provide several premade Gantt chart templates in Excel.

Free Templates For Apple Numbers
Gantt Chart Creator Mac
Free Gantt Chart Template Excel Mac Download
Free Gantt Chart Template Excel Machine

Free Gantt Templates for Apple Numbers on Mac. Choose from our top Apple Numbers Gantt chart templates for planning and tracking projects. In addition to the 14 free, customizable templates below, you’ll also find info on how to create your own Gantt chart in Apple Numbers. Templates on this page include project management Gantt charts, a. How to make a Gantt chart in Numbers. List your project data in a table. Open Numbers and select the Charting Basics category under the Basic section of the Template Gallery. Click on the “+” tab on the far-left side of the Charting Basics ribbon to create a new sheet. Make a simple Excel gantt chart with our free template. Our easy premade Excel gantt chart template can save you tons of time by organizing your project plan and tackling the tedious scheduling work for you! Use this Excel gantt chart to simplify complex projects into an easy-to-follow plan and track the status of tasks as work progresses. To do so, go to the Layout tab on the Word ribbon and click on Orientation. Go to the Insert tab and select Chart from the Illustration section. 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. Add your project schedule data. Download Simple Gantt Chart Template. Excel 2000-2004 Excel 2007-2016 Smartsheet. Organize and track simple projects or timelines, like personal objectives or short team projects, with this simple Gantt chart template. To get started, simply input your task data, like start and end dates and duration times, into the chart to create a high.

We’ll show you each of them, including the features they have. You can download them for free. If this sounds like something that could help better organize your day, keep reading!

Automated Gantt chart templates in Excel (FREE download)

Why use a Gantt chart template in Excel?

Templates are a great way to save your precious time because you won’t stare too long at an empty document. You can focus more on the content than anything else, such as formatting. But why Gantt chart templates in Excel?

One of the reasons is because Excel is one of the most accessible and easy-to-use software programs. There are plenty out there for creating Gantt charts, but creating Gantt charts using this spreadsheet app is probably the most familiar way to do it for most of us. Everyone in your team will also be able to collaborate easily because of their familiarity with Excel.

In addition, Excel can integrate with other apps and services to help you work more efficiently. You can import data from project management apps such as Jira and Trello into Excel, then use it to create a Gantt chart visualization. There are also integration tools available that automate the import process, such as Coupler.io.

Coupler.io makes importing data from multiple sources into Excel, Google Sheets, or BigQuery easy without coding! Check out the complete list of Microsoft Excel integrations supported by Coupler.io.

How to create a Gantt chart in Excel from our template

In the next section, you will see a list of Gantt chart templates for Excel.

They range from essential to complex Gantt charts and charts with different granularity: hourly, daily, weekly, and monthly.

To create a Gantt chart from our Excel templates:

Go to File => Save As => Download a copy.
Open the downloaded XLSX file.
Read the getting started instructions in the “Readme” worksheet.
Start inputting your project data and save your file as an Excel document.

It’s so simple to use our templates. You only need basic Excel skills such as how to copy-paste a row. If you want more control over the formatting, such as changing the bar colors, you only need to understand basic conditional formatting in Excel.

Automated Gantt chart templates in Excel (FREE download)

Our Excel Gantt chart templates below are fully automated. All you have to do is provide some inputs. The bars will update automatically, showing a visualization of your project schedule. See the list below. 👇

Basic Gantt chart Excel template

This Microsoft Excel Gantt chart template contains the essential elements needed to create a Gantt chart. It has basic features to visualize your project tasks in a daily timeline.

There are no progress tracking, subtasks, dependencies, and resource management features. However, this template is powerful enough to visualize your project schedules. You can see all the works mapped out and how long the whole project will take.

The daily timeline shows only workdays (Monday to Friday). You can change the range of the dates displayed in the timeline area by using the scroll bar on the top-right. As the timeline shows daily granularity, this template is best for planning short-term projects.

Weekly timeline Gantt chart Excel template

This template is excellent for short and medium-term projects. By default, it gives you a weekly timeline that covers one year, with the scroll bar at the top-right allowing view periods up to four years long. The bars show the total weeks each task will take based on the start dates and end dates you inputted.

Monthly timeline Gantt chart excel template

A monthly timeline template is a great way to stay on top of your projects. The high-level overview allows you to know what needs to be done for the next few months. It can also guide planning and mapping smaller tasks, so you never miss any deadlines.

Free Templates For Apple Numbers

This template has a monthly timeline spanning three years, but you can remove or add more years as needed. You can also use the scroll bar to see a range of future years in the timeline area.

Hourly schedule Gantt chart Excel template

This project schedule Gantt chart Excel template with an hourly timeline can help you plan daily activities in small time increments. Use this template to plan short-duration tasks and map them to a timeline under 24 hours. You can also use it for hourly labor scheduling.

The bar colors in this template are based on the assignee name. Each person has a different bar color, making it easy to spot when someone has multiple tasks at the same time.

Project management Gantt chart Excel template

This professional Gantt chart Excel template for project management has quite valuable features to help you manage and track the progress of your projects, such as:

You can organize tasks into phases.
You can input which member of the team member is responsible for each task.
You can enter the completion of each task by inputting a value in the % completed column. By doing this, the pieces you’ve done will also have a different color.
There are also vertical lines that indicate the current date. Thus, by looking at the bars, you can immediately see what should have been done by today’s date. Some tasks that are behind schedule will be easy to spot, so you can take action to get them back on track.

In addition, this project management Excel Gantt chart template shows how to use the following formulas to calculate the start date and duration of each phase based on its tasks’:

Start date of a phase:

Number of workdays:

The above formulas will make the bar of each phase update automatically when its tasks’ durations change. However, you can also enter the start date and duration of each phase manually if you prefer.

Gantt chart Excel template with subtasks

This template has similar features as the Project Management template above. The main difference is adding subtasks and breaking your project into more detailed and manageable items. The template also shows how to calculate the start date, duration automatically, and % completed of a task based on its subtasks. Still, you can enter them manually if you prefer.

Gantt chart template with dependencies

In a project, often, there is a task that cannot start until another has been completed. Some tasks may depend on another, and luckily, ensuring task dependencies can be done using formulas in Excel.

This template provides you an easy way to define the predecessor of a task, subtask, even a phase.

The ID column in this template is unique and defined using a formula. You will need to enter a cell reference to an ID value in the DEPENDENCY column to add a dependency.

The bars on the right are based on the START DATE and END DATE columns, calculated automatically based on IND. START DATE, DEPENDENCY, and WORKDAY values.

You can see how a delay in one task might impact the schedules of other tasks, even an entire Phase.

For more detail on how to use this template, please check the Readme worksheet in this template.

Construction Gantt chart Excel template

Gantt charts are also popular and widely used in the Construction industry. The simplicity and visual clarity of the chart make it a valuable tool for displaying job schedule information.

An activity or a task might be as large and complicated as laying the foundation of a building. It could also be much more straightforward, like erecting formwork for one footing. A Gantt chart helps you estimate and visualize those activities, making delays less likely to occur.

Our Construction Gantt chart template has example tasks defined for a Construction project. When using it, you can use Phases to group tasks based on a category you like. For example, for a high-rise building construction, you can group tasks based on the construction area, floor, responsibility, etc.

The template makes it easy to assign who’s responsible for each task. You can also estimate the cost of a task and enter its actual cost as your work progresses.

Marketing Gantt chart Excel template

This Microsoft Excel Gantt chart template has a monthly timeline with quarterly info and helps plan your long-term marketing project. Just enter your tasks, including their start dates and end dates. You can also group your tasks into phases, such as online marketing, search engine optimization, offline marketing, and so on.

Event planning Gantt chart excel template

When planning an event, it doesn’t matter how many people will attend. All events require careful preparation for unforeseen circumstances that could arise on your special day! A Gantt chart can help you ensure everything is organized in advance!

Use this template to plan all activities needed for your big day. It has pre-defined tasks as examples, making it easy for you to follow and add more tasks of your own.

Wrapping up: Gantt chart template in Excel for your project

A Gantt chart is a valuable tool to help you plan, track, and communicate your project schedule. They can also help you identify any potential problems that may arise before it’s too late.

Creating Gantt charts from templates can save you precious time. We hope that the templates in Excel we provide are great for helping you plan out your project in an organized and visually appealing way.

Finally, when you already have a list of tasks in Jira or other project management apps and want to import them in Excel to create a Gantt chart visualization, try Coupler.io. This integration tool also allows you to automate the import process on a schedule to be more efficient!

Back to Blog

This step-by-step Numbers Gantt chart tutorial explains how to make professional Gantt charts inside the popular spreadsheet app for Mac.

Professionals who need to create a Gantt chart in Apple's Numbers can do so using the tool’s Bar Chart feature and some manual formatting. However, since the software lacks a built-in Gantt feature and its templates are primarily designed for summarizing data such as home budgets, checklists and invoices, it may limit one's ability to generate more accurate, easy-to-follow visuals for purposes such as presentations to clients and managers.

If you need to create impressive Gantt charts that can be easily customized and updated, using a web-based Gantt chart maker such as Office Timeline's may prove more efficient. The tool lets you quickly build your visual online and download it as a native PowerPoint slide to include in presentations. On this page, I will explain how to make a Gantt chart both manually in Numbers and automatically with Office Timeline Online. To learn how to make a timeline in Numbers for Mac, please see our timeline tutorial here.

Which tutorial would you like to see?

How to make a Gantt chart in Numbers

1. List your project data in a table

Open Numbers and select the Charting Basics category under the Basic section of the Template Gallery.
Click on the “+” tab on the far-left side of the Charting Basics ribbon to create a new sheet.
In the newly added sheet, there will be a default table where you can input your data. Enter the key phases of your project (called project tasks) in the first column of the table as in the image below. Since the task descriptions will be displayed on the vertical axis of your chart, it’s recommended that you keep them as short as possible to ensure they'll be clearly visible.
In the second column, add the start week for each of the project phases, using the first task (which will start in week 1) as the reference point for the rest of the tasks. This will help outline the span of the horizontal axis when you start building your graphic. I have included a second table in the image below to better illustrate how I calculated the start time series for my chart.
Use the next column to list each task's duration (number of weeks required to complete that task). In the second table below, you can see my calculations for the duration series.

2. Create a basic graphic setting it up as a 2D Stacked Bar Chart

Select all the data in your table and then go to Insert → Chart on the Numbers ribbon.
Select 2D Stacked Bar from the menu that appears.
Numbers will automatically generate a simple stacked bar chart that looks like the one below:

3. Format your graphic to turn it into a Gantt

Now that your basic stacked bar graphic is created, you will need to make a few edits to turn it into a Gantt. The main thing to change is to make the blue bars transparent so that only the green ones remain visible. The latter will represent your tasks. To do this:

Click on any of the blue bars. This will select the whole series.
Select the Style tab from the Format pane on the right side of your sheet.
Click on the color indicator next to Fill and select No Fill.
The resulting Gantt chart should look like this:

4. Customize your Gantt chart

At this point, your Gantt is ready for a few customizations if you want to make it look more unique.

Customizing your task bars
i.To change the color of all your tasks simultaneously, select any of them, go to the Style tab in the Format pane and click on Fill, where you can choose whichever color you prefer. In my example, I picked a dark purple.
ii.If you want to color the chart bars individually, you need to redistribute your tasks into different categories. To do so, first add several columns after “Duration”, as in the following image. Each of these will generate a distinct hue that you can later customize from the Style tab (as shown earlier). Then, cut the duration value of the task you intend to recolor and paste it in whichever of the newly added columns, keeping the same row. You can see how I set up the new colors for my graphic below:
Note: The tasks that have their duration values in the same column are seen as a single category and customized simultaneously, while those with the duration values placed in different columns will be considered as distinct series, and you'll be able to recolor them individually.
iii.While in the Style section, you can also choose to apply various styles and effects to your tasks, such as strokes and shadows, but I recommend keeping these to a minimum so your chart remains legible. For instance, I added only a straight black outline to the bars using the Stroke feature. Since I kept a multicolored graphic, I selected all my bars first (Shift + Click) to make sure the Stroke effect is applied collectively.
iv.If you want to display each task’s corresponding duration on the chart, select all of the bars and go to Value Labels within the Series tab. Click on the arrow on the left and select 'Same as Source Data'.
Customizing the chart area
To personalize your graphic even further, you can make some changes to the chart area using the Format pane's Chart tab. Before getting started, first make sure your graphic is selected.
i.Add borders and titles: Check the box for Border and Title under Chart Options. In my example, I also unchecked the box for Legend, as I found it to be redundant for my Gantt.
ii.Customize fonts: You can change the font type and size for the entire graphic under Chart Font, as shown in the picture below. In my example, I changed the font to Helvetica and I increased its size.
Note: To customize the chart title or the task descriptions separately, simply double-click on the desired element and make whatever changes you want from the small pane that pops up.
iii.Adjust the space between the chart bars: Under the Gaps section of the Chart tab, use the up-down controls to increase or decrease the space between your tasks. I increased the gap percentage to 80% for my chart (see image below).
iv.Apply a background to the graphic: Under Background & Border Style, click on the arrow next to No Background Fill and select Color Fill from the drop-down menu to get access to a color palette. In my example, I used a light shade of grey called Mercury for the background.
v.Finally, to make it easier to see the relative distance between tasks, I've added more vertical gridlines. To do the same, select the Axis tab of the Format pane, go to Minor Gridlines and click on the type of gridline you want to add. I chose the second type, with a size of 0,5 points.
After completing all the steps above, trying out several font sizes and styles, and increasing the width of the chart area, my final Gantt chart in Numbers looks like this:

Download Gantt chart template for Numbers

How to make a Gantt chart online automatically

Gantt Chart Creator Mac

Manually building a Gantt chart in Numbers is possible, but the tool’s limited customization options (for example, not being able to color tasks individually) can make it difficult to create more professional visuals and update them for recurring business or project communications.

Professionals who want to build Gantt charts more easily and apply more refined custom changes to their visuals can do so using Office Timeline Online . The browser-based tool lets you automatically create an eye-catching graphic, update it quickly as plans change, and download it as a .pptx file or .png image. To get started, access the free app here and follow the steps below.

1. Enter your project's data in Office Timeline Online

From the New tab in Office Timeline Online, click on Timeline from scratch or choose one of the templates provided to start building your Gantt chart. To save time, you can also import an existing schedule from Excel. In my example, I chose to make a new Gantt chart from scratch.
After clicking the Timeline from scratch button, you will be taken to the Data View, which allows you to enter and edit data.
In the Data View, list your task descriptions and dates - Office Timeline will instantly generate your graphic and show you a live preview of it on the right. You can also make a few quick styling choices here in the Data tab, such as choosing the shape and color for each task. Once ready, select the Timeline tab on the Office Timeline Online ribbon or click the thumbnail image on the top right to go to the Timeline View, where you can see your Gantt chart in full size and customize it further.