How to make Gantt charts by weeks in Excel 365?
Tags: tomakeganttchartsbyw
Published: 2021-08-18 12:56:11

---
title: How to make Gantt charts by weeks in Excel 365?
published: true
date: 2021-08-11 16:54:16 UTC
tags: ToMakeGanttChartsByW
canonical_url: https://geekexcel.com/how-to-make-gantt-charts-by-weeks-in-excel-365/
---

A **Gantt char** t is a type of **bar chart** that illustrates a project schedule. This chart lists the tasks to be performed on the **vertical axis, and time intervals on the horizontal axis**. The width of the horizontal bars in the graph shows the duration of each activity. Gantt charts illustrate the start and finish dates of the terminal elements and summary elements of a project.

Here I will introduce you to some quick tricks to **Make Gantt Charts By Weeks In Excel 365**. Let’s get them below!! Get an official version of MS Excel from the following link: **[https://www.microsoft.com/en-in/microsoft-365/excel](https://www.microsoft.com/en-in/microsoft-365/excel)**

## Insert Gantt Chart

- You need to **enter the data** in the Excel worksheet.
- For instance, we have shown the **list of project started details**.

![](https://geekexcel.com/wp-content/uploads/2021/08/project-details.png)<figcaption>Project Details</figcaption>

- Then, you have to **select any blank cell**.
- Now, you need to click on the **Insert** option and select **any Bar chart**.
- After that, you have to **right-click**  on the **chart** and Click  **Select Data option**.

![](https://geekexcel.com/wp-content/uploads/2021/08/Click-Select-Data.png)<figcaption>Click the Select Data option</figcaption>

- You will receive **Select Data Source**  dialog box, and it is used to take **input fields of data**.
- Then, you have to **start adding the data** in the  **Edit Series**  dialog box.
- Now, you need to add the **start week number** **(D3)** as  **Series name** : and start week array **D4:D10** and click  **OK**.

![](https://geekexcel.com/wp-content/uploads/2021/08/Click-Series-value.png)<figcaption>Click Series Value</figcaption>

- After that, you need to **add** the **next values** which is the **duration** of days.
- For that, you have to click **Add ** and fill the **duration** field and click  **OK**.

![](https://geekexcel.com/wp-content/uploads/2021/08/click-for-duration.png)<figcaption>Add duration details</figcaption>

## Continue with the Gantt chart

- You need to click **Edit ** to select the **tasks** to be **replaced with numbers** shown on the **vertical axis.**

![](https://geekexcel.com/wp-content/uploads/2021/08/Click-on-Edit.png)

- Now, the above process fills the  **Description Column**  as shown below and Now click **Enter**.

![](https://geekexcel.com/wp-content/uploads/2021/08/click-description-1024x364.png)<figcaption>Click description</figcaption>

## Change outer layout

- You need to **add chart title** and enable  **legends**  clicking  **+ option** on right just above the brush option.

![](https://geekexcel.com/wp-content/uploads/2021/08/Add-title.png)<figcaption>Add title and legends</figcaption>

- Then, you have to click on the  **right side brush** look alike option of **chart** , select the **type of style** you want.

![](https://geekexcel.com/wp-content/uploads/2021/08/Choose-the-style.png)<figcaption>Type of Charts</figcaption>

## Verdict

From this chapter, you can get some clarification about **how to Make Gantt Charts By Weeks In Excel 365**. Let me know if you have any **doubts** regarding this article or any other Excel/VBA topic.

Thank you so much for visiting  **[Geek Excel](https://geekexcel.com/)!! **If you want to learn more helpful formulas, check out [**Excel Formulas**](https://geekexcel.com/excel-formula/) **!!**

**Read Next:**

- **[Excel Formulas: Check Last N Weeks of Today’s Date ~ Easy Solution!!](https://geekexcel.com/excel-formulas-check-last-n-weeks-of-todays-date-easy-solution/)**
- **[Formulas to Create Gantt Chart with Weekends ~ Easy Tutorial!!](https://geekexcel.com/excel-formulas-to-create-gantt-chart-with-weekends/)**
- **[Excel Formulas to build a Gantt Chart with Conditional Formatting!!](https://geekexcel.com/excel-formulas-to-build-a-gantt-chart-conditional-formatting/)**
- **[Formulas to Build Gantt Chart by Week ~ Easy Tutorial!!](https://geekexcel.com/excel-formulas-to-build-gantt-chart-by-week-easy-tutorial/)**
- **[Excel Formulas to Create Gantt Chart with Time Schedule!!](https://geekexcel.com/excel-formulas-to-create-gantt-chart-with-time-schedule/)**