How to Edit Gantt Chart in Excel

You’ve built a Gantt chart in Excel, which is a great first step for visualizing your project timeline. But projects are rarely static - deadlines shift, tasks get added, and priorities change. This guide will walk you through exactly how to edit your Gantt chart in Excel, so you can keep it accurate, updated, and truly useful for managing your work.

Graphed

Still Building Reports Manually?

Watch how growth teams are getting answers in seconds — not days.

Watch the Demo

Understanding Your Excel Gantt Chart's Structure

Before you start making changes, it's helpful to remember what an Excel Gantt chart really is. Unlike a pie or line chart, there's no built-in "Gantt chart" option in Excel. What you've created is a clever customization of a stacked bar chart. This means it has two key parts:

• The Data Source: This is the table in your spreadsheet with your project information - task names, start dates, end dates, and durations.
• The Chart Visualization: This is the stacked bar chart itself, which visually represents the data from your table.

The golden rule of editing an Excel Gantt chart is simple: all modifications start with your data. When you update the information in your table, the chart will automatically reflect those changes. Most of the work happens in the spreadsheet cells, not the chart itself.

Core Edits: Updating Tasks and Timelines

These are the most common edits you'll be making as your project progresses. Whether a deadline gets pushed back or a new task pops up, here’s how to handle it.

Graphed

Still Building Reports Manually?

Watch how growth teams are getting answers in seconds — not days.

Watch the Demo

Changing Task Details (Names and Dates)

Let's say a task needs to be renamed, or its start date has shifted. This is the easiest fix:

1. Navigate to your data table in the spreadsheet.
2. Find the row corresponding to the task you need to change.
3. Click directly into the cell for the "Task Name," "Start Date," or "End Date" you want to modify.
4. Type in the new information and press Enter.

You'll see the corresponding bar on your Gantt chart immediately adjust to reflect the new dates or the task label change on the axis.

Adjusting Task Duration

Most Gantt chart templates use a simple formula to calculate duration (e.g., =End Date - Start Date). Because of this, you don't typically edit the duration column directly.

Instead, to change a task's duration, you just need to update its End Date. For example, if "Task A" starts on May 1st and lasts 5 days, its end date would be May 6th. If you realize it will actually take 8 days, you would change the End Date to May 9th, and the Duration cell and the chart bar's length will update automatically.

Adding New Tasks

When a new task is added to the project scope, getting it onto your Gantt chart involves two main steps: updating the data and then telling the chart to include it.

1. Add the Task to Your Data Table: In your task list, right-click a row number where you’d like to add the new task and select "Insert" to create a blank row. Enter all the relevant details: Task Name, Start Date, and End Date (or Duration).
2. Update the Chart's Data Source: This is the key step. Your chart is currently only looking at the original range of data and doesn't know about your new row.

Graphed

Still Building Reports Manually?

Watch how growth teams are getting answers in seconds — not days.

Watch the Demo

Removing Tasks

If a task becomes obsolete, you can remove it just as easily. First, delete the task's row from your data table by right-clicking the row number and selecting "Delete." However, this might leave an ugly blank space in your chart. To fix this, you follow the same process as adding a task: click the chart, go to "Select Data," and adjust the data range to exclude the now-empty space.

Cosmetic Changes: Improving Readability and Style

Once your data is correct, you can focus on making the chart easier to read and more visually appealing.

Formatting the Gantt Bars

Remember that "invisible" part of the stacked bar chart? That's the series representing the start date, and the visible bar is the one representing the duration. Here’s how you can customize them.

• Make the Starting Bar Invisible: Single-click one of the bars in your chart to select the entire data series. You may need to click a second time on just one of the start date segments (the first part of each stacked bar). Right-click and choose "Format Data Series." In the format pane, go to the "Fill & Line" tab (the paint bucket icon) and under "Fill," select "No fill." This makes them disappear, leaving you with classic-looking Gantt bars.
• Change Bar Colors: Now, click on one of the visible duration bars to select that series. In the same "Fill & Line" pane, you can choose a new fill color, add a solid border, or apply other effects to make them stand out. You can even click a single, individual bar and format it with a unique color to highlight a critical task.

Adjusting the Timeline Axis

Sometimes your project timeline is very long, or you want to zoom in on a specific phase. You can easily adjust the date axis at the top of your chart.

1. Right-click on the date axis at the top of your Gantt chart.
2. Select "Format Axis" from the dropdown menu.
3. In the "Axis Options" tab, you'll find a few useful settings:

Advanced Customizations for Your Gantt Chart

Ready to take your chart to the next level? These common customizations add more projective context.

Graphed

Still Building Reports Manually?

Watch how growth teams are getting answers in seconds — not days.

Watch the Demo

Showing Task Progress

Displaying how much of a task is complete adds another layer of valuable information. This involves adding another data series to your chart.

1. Add a "Progress" Column: In your data table, create two new columns: "% Complete" and "Progress Days."
2. In the "% Complete" column, you will manually enter the percentage of completion for each task (e.g., 25%, 50%, 100%).
3. In the "Progress Days" column, enter a formula that calculates the number of completed days based on the percentage, like so: =([Duration column]*[% Complete column]). Drag this formula down for all tasks.
4. Add Progress to the Chart: Click your chart, go to "Chart Design" > "Select Data." Click "Add" under the Legend Entries (Series) section.
5. Format the Progress Bar: A new, colored bar will appear stacked next to your duration bars. To make it appear overlaid, right-click this new progress series, go to "Format Data Series," and in the "Series Options," select "Secondary Axis." This will look strange at first, but now you have more control. Select either the progress series or the main duration series, and in "Series Options," set the "Series Overlap" to 100% and increase the "Gap Width." This should place your progress bar neatly inside the main task bar, which you can format to be a darker shade for clarity.

Adding a "Today" Marker

A vertical line that indicates the current date is incredibly helpful for seeing where your project should be at a glance.

1. Set Up "Today" Data: Somewhere in a blank area of your sheet, create a small helper table. In one cell, type the label "Today." In the cell next to it, enter the formula =TODAY(). This will always show the current date.
2. Create Drawing Points: This helper line will be an XY Scatter plot, so you need X and Y coordinates. The X-values are both the "Today" date you just created. For the Y-values, use 0 for the first point and 1 for the second.
3. Add the Series: Click your chart and go to "Select Data" > "Add." The "Edit Series" box appears. For series X-values, select your two "Today" date cells. For series Y-values, select your 0 and 1 cells. Click "OK."
4. Combine Chart Types: Go to "Chart Design" > "Change Chart Type" > "Combo." Find your "Today" series in the list and change its chart type to "Scatter with Straight Lines." Make sure it's plotted on the secondary axis.
5. Format the Axis: To make the line stretch across the whole chart, you need to format the new secondary vertical axis that appears on the right. Right-click it, go to "Format Axis," and set the Minimum bound to 0 and the Maximum bound to 1. Now you can hide this axis and format your vertical "Today" line to be a red, dashed line.

Final Thoughts

Editing an Excel Gantt chart is all about manipulating the data table and tweaking the chart's extensive formatting options. Once you get the hang of adjusting the data source range and customizing individual chart elements, you can easily keep your timeline accurate and crystal clear for stakeholders.

As projects get more complex, you may find yourself pulling data from different places - like your CRM, ad platforms, and project management tools - just to keep your spreadsheets updated. We designed Graphed to simplify all of this. Instead of spending hours manually editing charts, we let you connect all your data sources automatically. You can then use simple, plain English to ask questions and generate real-time dashboards in seconds, freeing you up to focus on strategy instead of spreadsheet wrangling.