How to Create a PERT Chart in Excel

A PERT chart can be a project manager’s best friend, turning a jumble of tasks, deadlines, and dependencies into a clear, actionable roadmap. While there are specialized project management tools out there, you can build a perfectly functional and insightful PERT chart using a tool you already have: Microsoft Excel. This article will guide you step-by-step through creating a PERT chart in Excel to help you visualize your project timeline and identify the most critical tasks.

Graphed

Build AI Agents for Marketing

Build virtual employees that run your go to market. Connect your data sources, deploy autonomous agents, and grow your company.

Build Your First Agent

What Exactly Is a PERT Chart?

PERT stands for Program Evaluation and Review Technique. It’s a visual tool used in project management to map out all the tasks needed to complete a project. Unlike a simple to-do list, a PERT chart focuses on the relationships and dependencies between tasks, showing you which activities must be finished before others can begin.

The main goal is to determine the project’s critical path - the longest sequence of tasks that dictates the minimum time required to complete the entire project. If any task on the critical path is delayed, the whole project finish date gets pushed back. By identifying this path, you know exactly where to focus your attention to keep things on schedule.

Key Components of a PERT Chart

Before we build one, let's get familiar with the basic building blocks:

• Nodes (or Events): These are typically represented by circles or rectangles. Each node signifies a milestone or the start/end point of an activity. They are often numbered for easy reference (e.g., 1, 2, 3).
• Arrows (or Activities): The arrows connect the nodes and represent the actual tasks that need to be completed. The direction of the arrow shows the flow of work.
• Time Estimates: This is what makes PERT so powerful. Instead of using a single time estimate for each task, PERT uses three:

Using these three estimates, you'll calculate the "Expected Time" for each task, giving you a more weighted, realistic forecast than a single "best guess" estimate.

AI Agents for Marketing

Crash Course

Graphed

Free PDF · the crash course

AI Agents for Marketing Crash Course

Learn how to deploy AI marketing agents across your go-to-market — the best tools, prompts, and workflows to turn your data into autonomous execution without writing code.

Download the PDF

Step 1: Gather and Organize Your Project Data

The success of your PERT chart depends entirely on the quality of the data you feed it. Before you even think about drawing shapes in Excel, you need a detailed breakdown of your project. Open a blank Excel spreadsheet and create a table with the following columns:

• Task ID: A simple identifier for each task (e.g., A, B, C).
• Task Description: A brief explanation of the work to be done.
• Predecessors: The Task ID of any tasks that must be completed before this one can start. This is crucial for establishing dependencies.
• Optimistic Time (tO): Your best-case scenario time estimate.
• Most Likely Time (tM): Your realistic time estimate.
• Pessimistic Time (tP): Your worst-case scenario time estimate.

Example Project: Launching a New Landing Page

Let's imagine our project is to launch a new landing page for a marketing campaign. Our initial data table in Excel might look like this:

Step 2: Calculate the Expected Time (TE)

Now we’ll add a new column to our table: Expected Time (TE). We'll use the standard PERT formula to calculate a weighted average of our three time estimates. This gives more weight to the "Most Likely" duration, providing a more balanced projection.

The formula is:

Expected Time (TE) = (tO + 4 × tM + tP) / 6

In your Excel sheet, click into the first cell of your new "TE (Days)" column. If your Optimistic, Most Likely, and Pessimistic times for the first task are in cells D2, E2, and F2, you’d enter this formula:

=(D2 + 4*E2 + F2) / 6

Press Enter, then drag the fill handle (the small square at the bottom-right of the cell) down to apply this formula to all your tasks. Your table will now look like this, with the calculated expected times:

Step 3: Construct the PERT Chart Visually in Excel

Here's where we get to the fun part. It’s important to know that Excel does not have a specific "PERT Chart" button. We're going to build it manually using shapes and connectors. This gives you complete control over the layout.

Graphed

Build AI Agents for Marketing

Build virtual employees that run your go to market. Connect your data sources, deploy autonomous agents, and grow your company.

Build Your First Agent

1. Set Up Your Canvas

I find it helpful to hide the gridlines for a cleaner look. Go to the View tab and uncheck the "Gridlines" box.

2. Add Your Nodes (Events)

Navigate to the Insert tab, click on Shapes, and select the Oval shape. Click and drag on your sheet to draw your first node.

• Create numbered nodes for the project’s milestones. For our example, we can map it out like so:
• To add text, simply double-click the shape and start typing the number. You can format the shape's color, outline, and text size using the Shape Format tab that appears when a shape is selected.

3. Add Your Arrows (Tasks)

Go back to Insert > Shapes and select an arrow. Draw an arrow connecting the relevant nodes based on your "Predecessors" column.

• Task A ("Plan Strategy") goes from Node 1 (Start) to Node 2 (Strategy Done).
• Task B ("Write Copy") starts after A, and Task C ("Design Mockups") also starts after A. This means you will draw two separate arrows pointing out from Node 2. We'll have them both point to Node 3 (Copy & Design Done).
• Task D ("Develop") can only start after both B and C are done, so its arrow will start from Node 3 and go to Node 4.

Continue this process for all your tasks, building out the web of dependencies.

4. Label Your Tasks

Now, we need to label each arrow with its Task ID and its Expected Time (TE). Since you can't add text directly onto an arrow, the easiest way is with a Text Box.

Go to Insert > Text Box. Draw a small box near an arrow and type in the information. For Task C, you’d type "C (5.33 days)". Under the text box's format settings, set the 'Shape Fill' and 'Shape Outline' to 'No Fill' and 'No Outline' to make it transparent.

5. Identify and Highlight the Critical Path

The critical path is the longest duration path from start to finish. To find it, add up the Expected Time (TE) for every possible path through your chart.

In our example, there are two paths from Start to Finish:

• Path 1: A -> B -> D -> E -> F = 2.17 + 3.17 + 6.67 + 2.00 + 1.17 = 15.18 days
• Path 2: A -> C -> D -> E -> F = 2.17 + 5.33 + 6.67 + 2.00 + 1.17 = 17.34 days

The second path is longer, making it our critical path. Now, go back to your chart and change the color or thickness of the nodes and arrows along Path 2. This makes it instantly obvious where your team needs to avoid delays.

AI Agents for Marketing

Crash Course

Graphed

Free PDF · the crash course

AI Agents for Marketing Crash Course

Learn how to deploy AI marketing agents across your go-to-market — the best tools, prompts, and workflows to turn your data into autonomous execution without writing code.

Download the PDF

A Quicker (But Less Detailed) Alternative: SmartArt

If you need to create a simple workflow diagram quickly for a presentation and don't need detailed time calculations shown visually, Excel's SmartArt can be a decent option.

1. Go to Insert > SmartArt.
2. Choose a graphic from the "Process" categories. A basic flowchart-style graphic works well.
3. Use the text pane that appears to enter your task descriptions into the shapes.

This method is much faster, but you lose the granular control. It's difficult to represent complex dependencies (like Task D needing both B and C) and you can't easily label the arrows with time estimates. It’s best used for very high-level project summaries.

Final Thoughts

Creating a PERT chart in Excel requires a bit of manual effort, but the payoff is a powerful visualization of your project's timeline, dependencies, and potential bottlenecks. It transforms abstract deadlines into a concrete game plan, allowing you to proactively manage your resources and ensure your project stays on track.

This manual process in spreadsheets works great for planning, but keeping dashboards and reports updated with real-time performance data can become a grind. To deal with the headache of constantly pulling data for marketing and sales analytics, we built Graphed. Our platform automatically connects to your data sources like Google Analytics, Shopify, and Salesforce, enabling you to build live dashboards simply by describing what you want to see. Instead of spending hours in spreadsheets, you can get instant answers and focus on what the data actually means for your business.