How to Create an Earned Value Chart in Excel

Creating an Earned Value chart gives you a powerful, at-a-glance view of your project's health, telling you instantly if you're on time and on budget. This article will walk you through exactly how to set up your data and build a clear, insightful Earned Value chart in Microsoft Excel.

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 is Earned Value Management (EVM)?

Before building the chart, it’s helpful to understand the three key metrics that make it work. Earned Value Management (EVM) is a project management technique that measures project performance by comparing the work planned against what was actually completed and what it cost. It’s all about answering the question, "What did we get for the money we spent?"

There are three core components:

• Planned Value (PV): This is the budgeted cost for the work that was scheduled to be completed by a certain date. It's your baseline, or your plan. Think of it as: "Where did we plan to be?"
• Earned Value (EV): This is the value of the work actually completed to date, measured against the budget. It represents the "earned" portion of your budget based on performance. Think of it as: "What is the value of what we’ve actually done?"
• Actual Cost (AC): This is the total amount of money actually spent to complete the work so far. It's the straightforward cost tracked by your finance team. Think of it as: "How much have we actually paid?"

By plotting these three lines on a chart, you combine schedule and budget performance into a single, cohesive visual that tells a comprehensive story about your project's status.

Step 1: Set Up Your Project Data in Excel

A good chart starts with well-organized data. The key here is to use cumulative data - a running total - for each of your metrics over time. This creates the smooth S-curve lines that make the chart easy to read.

Open a new Excel sheet and create a table with four columns. Let's use a simple 12-week website development project as an example. Your columns should be:

• Week: Your time period (e.g., Week 1, Week 2, Month 1, etc.)
• Planned Value (PV): The cumulative budget planned for each week
• Earned Value (EV): The cumulative value of work actually done each week
• Actual Cost (AC): The cumulative costs incurred each week

Here’s how the sample data for our website project might look. Notice how each value builds on the previous week's total.

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

Hypothetical Website Project Data:

In this example, the project is currently in Week 10, so EV and AC data for future weeks are not available yet.

Step 2: Create Your Earned Value Chart

Once your data is neatly organized, creating the chart takes just a few clicks.

1. Select Your Data: Click and drag to highlight your entire data table, including the headers (from Week to Actual Cost).
2. Insert a Line Chart: Navigate to the Insert tab on Excel's ribbon. In the Charts section, click on the "Insert Line or Area Chart" icon. From the dropdown, choose Line with Markers. This chart type is ideal because it clearly shows the data points for each week.
3. Your Chart is Created: Excel will instantly generate a chart with three lines representing PV, EV, and AC. Now, it's time to refine it so it's easy for anyone to understand.

Step 3: Customize and Format Your Chart

A default chart works, but a well-formatted one tells a better story. Here are a few must-do customizations.

1. Add a Clear Title and Axis Labels

First, give your chart a descriptive title. Click on "Chart Title" and change it to something like "Project Earned Value Analysis." Next, add labels to your axes so everyone knows what they're looking at. If they don't appear automatically, click the chart, then click the green "+" icon next to it and check the box for Axis Titles.

• Your vertical (Y) axis should be labeled "Cost."
• Your horizontal (X) axis should be labeled "Time" or "Week."

2. Format the Data Series for Clarity

Color-coding your lines makes the chart much easier to interpret. Right-click on one of the lines and select Format Data Series. A pane will open on the right. You can adjust the line color, marker style, and more.

Here are the standard color conventions for EVM charts:

• Planned Value (PV): Blue - This represents your baseline plan.
• Earned Value (EV): Green - This often represents something positive, like the value you've created.
• Actual Cost (AC): Red - This represents cost or can indicate a problem (over budget).

Step 4: How to Interpret Your Earned Value Chart

Now that you have your chart, here's how to read the story it's telling by comparing the positions of the green (EV), blue (PV), and red (AC) lines.

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

Analyzing Your Schedule

This is all about comparing your Earned Value (green line) to your Planned Value (blue line).

• If EV is below PV (Green line below Blue line): You are behind schedule. The value of the work you've completed is less than what you had planned to complete by this point.
• If EV is above PV (Green line above Blue line): You are ahead of schedule. You've completed more work than planned.

Analyzing Your Budget

To check your budget health, compare your Earned Value (green line) to your Actual Cost (red line).

• If AC is above EV (Red line above Green line): You are over budget. You've spent more money than the value of the work you've completed.
• If AC is below EV (Red line below Green line): You are under budget. The value of the work you've done is greater than what you spent to do it. This is a good position to be in!

In our chart example for the website project, a quick look reveals that up until Week 5, the project was both behind schedule (EV < PV) and over budget (AC > EV). However, around Week 6, the team caught up, and now the project is under budget (EV > AC) but still slightly behind schedule (EV < PV).

Bonus: Calculate Key Performance Metrics

To take your analysis a step further, you can add a few columns to your spreadsheet to calculate key EVM variances and performance indices. These add quantitative context to your visual chart.

For the most recent period (Week 10 in our example), you can calculate:

Schedule Variance (SV)

Tells you how far ahead or behind schedule you are in monetary terms.

SV = EV - PV

A positive value is good (ahead of schedule), and a negative value is bad (behind schedule).

Cost Variance (CV)

Tells you if you're over or under budget in monetary terms.

CV = EV - AC

A positive value is good (under budget), and a negative value is bad (over budget).

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

Schedule Performance Index (SPI)

Measures your time efficiency as a ratio. It answers, "How efficiently are we using our time?"

SPI = EV / PV

A value greater than 1.0 is good (ahead of schedule), while a value less than 1.0 means you're behind schedule.

Cost Performance Index (CPI)

Measures your budget efficiency as a ratio. This is one of the most important metrics, answering, "For every dollar we spend, how much value are we getting?"

CPI = EV / AC

A value greater than 1.0 is good (under budget), while a value less than 1.0 means you're over budget.

Final Thoughts

Building an Earned Value chart in Excel turns complex project data into a clean, intuitive visual that quickly communicates whether you're on track. By following these steps, you can create a professional-grade dashboard to monitor project health and make informed decisions before things go off the rails.

Of course, the biggest challenge is often just collecting and updating the data from all your different tools. Manually tracking your planned values, updating work completed, and pulling in costs from financial software can turn into a weekly reporting marathon. We built Graphed to solve exactly this problem. Instead of wrestling with spreadsheets, we connect directly to your data sources – like project management tools, ad platforms, and CRMs. From there, you can just ask in plain English to "create an earned value chart from my Asana and QuickBooks data" and get a real-time, always-updated dashboard in seconds, freeing you up to act on the insights, not just gather them.