How to Create a Run Chart in Excel

Stop trying to find stories in rows and columns of data. A run chart is a remarkably simple tool you can make in Excel to see how a process or key metric is performing over time. This guide will walk you through exactly how to create and interpret a run chart, step-by-step, helping you spot trends and patterns you might otherwise miss.

Graphed

Still Building Reports Manually?

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

Watch the Demo

First Things First: What Exactly Is a Run Chart?

A run chart is essentially a line graph that shows data points in chronological order. Think of it as a historical record of your performance. It's one of the most fundamental tools for process improvement because it helps you distinguish between random, everyday fluctuations (often called "noise") and real, significant changes (often called "signals").

A standard run chart has two key components:

• Your data points: Plotted sequentially over time.
• A center line: Typically the median of all your data points.

By comparing your data points to the median, you can instantly see if your performance is consistently above or below average. It's an effective way to visually answer questions like:

• Are our sales numbers trending upwards this quarter?
• Did our website traffic actually increase after that last marketing campaign?
• Are our customer response times getting better or worse?

You can use a run chart to track almost anything: daily sales figures, weekly website visitors, monthly customer churn, or even the time it takes you to complete a recurring task each day. Its simplicity is its greatest strength.

Step 1: Get Your Data Ready in Excel

Before you can build anything, you need a solid foundation. In data analysis, that means organizing your data properly. The quality of your chart depends entirely on the quality of your data - "garbage in, garbage out" is a very real concept here.

For a run chart, you need at least two columns in your Excel sheet:

1. A time-series column: This contains the timeline for your measurements (e.g., Day 1, Day 2, Week 1, Week 2, or specific dates like 11/1/2023, 11/2/2023).
2. A data column: This contains the values you've measured at each point in time (e.g., Number of Sales, Page Views, Minutes to Respond).

Crucially, your data must be sorted chronologically. If your dates or time periods are out of order, the chart won't show a true representation of performance over time.

Graphed

Still Building Reports Manually?

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

Watch the Demo

Calculating the Center Line (Median)

The next step is to add a third column for your center line. While you could use the average (mean), the median is a much better choice for run charts. The median is the middle value in your data set, making it less sensitive to extreme outliers. For instance, one exceptional sales day won't drastically skew your entire center line if you use the median.

Here's how to calculate it in Excel:

1. Title a third column "Median."
2. In the first cell of that column, enter the median formula. If your sales data is in cells B2 through B21, your formula would be:

=MEDIAN($B$2:$B$21)

Pro Tip: Using dollar signs ($B$2:$B$21) locks the cell range. This is called an absolute reference. When you drag the formula down to the other cells in the column, the reference range won't change.

1. Click the small square at the bottom-right corner of the cell (the fill handle) and drag it down to the last row of your data. This will copy the same median value for every time period, creating a flat center line for your chart.

Your data should now look something like this:

[Insert screenshot or example table if needed]

Step 2: Building the Run Chart in Excel

With your data prepped, creating the chart itself takes less than a minute. Follow these simple steps.

1. Select Your Data

Click and drag your cursor to highlight all three columns, including the headers: the time period, your data values, and the median.

2. Insert a Line Chart

Navigate to the Insert tab on the Excel ribbon. In the Charts section, click on the Line Chart icon and select the "Line with Markers" option. This type is ideal because the markers make each individual data point easy to see.

Excel will instantly generate a basic run chart with your data and the median line plotted correctly.

Graphed

Still Building Reports Manually?

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

Watch the Demo

3. Customize and Format Your Chart for Clarity

A basic chart works, but a well-formatted chart tells a story. Taking a few extra moments to clean it up makes it more professional and easier for anyone to understand.

• Give it a clear title. Double-click the chart title and change it from "Chart Title" to something descriptive, like "Weekly Units Sold This Quarter."
• Label your axes. A chart without labeled axes is ambiguous. Click the green "+" icon next to your chart, check the box for "Axis Titles," and label your X-axis (e.g., "Week") and Y-axis (e.g., "Units Sold").
• Adjust the line styles. You want your data line to be the main focus. Right-click on the median line, select "Format Data Series," and change its appearance. A good practice is to make the data line a solid, prominent color (like blue) and the median line a dashed, neutral color (like gray or orange).

After a few tweaks, your final chart should look clean, professional, and easy to interpret.

Step 3: Reading the Story Your Run Chart Is Telling

Now for the most important part: what does the chart actually mean? Interpreting a run chart involves looking for non-random patterns that suggest a real change has occurred. The median line is your reference point.

Here are a few simple "rules" to help you spot significant signals in your data:

Rule 1: Look for Shifts

A "shift" is a long sequence of data points all falling on the same side of the median. If you see six or more consecutive points either all above or all below the center line, it's a strong indicator that the process has fundamentally changed. For example, six straight weeks of above-median sales after launching a new promotion is a signal that the promotion is working.

Rule 2: Look for Trends

A "trend" is a long sequence of data points that are continually increasing or decreasing. Look for five or more consecutive points that are all moving in the same direction — up or down. This signals a sustained change over time. If your customer complaint numbers have decreased for five months in a row, you're looking at a positive trend.

Graphed

Still Building Reports Manually?

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

Watch the Demo

Rule 3: Look for Outliers

An outlier, sometimes called an "astronomical point," is any data point that is dramatically different from all the others. It's the "one of these things is not like the others" moment in your data. If your website typically gets 1,000 visits a day and one day it gets 20,000, that's an outlier. These are usually caused by special events (like a viral social media post or a technical glitch) and are worth investigating immediately.

By using these simple rules, you can confidently tell the difference between normal variation and a pattern that requires your attention or deserves celebration.

Common Pitfalls When Making Run Charts

Run charts are easy to create, but a few common mistakes can make them misleading. Here's what to watch out for:

• Using the mean instead of the median. As mentioned earlier, the mean (average) can be easily skewed by unusually high or low data points. Unless your data is very stable with no outliers, stick with the median for a more reliable center line.
• Not having enough data points. A run chart with only a handful of data points is not very useful for spotting trends. To get meaningful insights, aim for at least 15-20 data points.
• Letting the data get out of order. Remember, a run chart is a time-series graph. Its entire value comes from its chronological sequence. Always double-check that your data is sorted correctly by date or time period before you create the chart.
• Overreacting to every peak and valley. The purpose of a run chart is to help you see the bigger picture and avoid chasing every small fluctuation. Don't make major decisions based on one or two data points. Instead, look for the statistically significant signals, like shifts and trends.

Final Thoughts

Creating a run chart in Excel is a straightforward way to start visualizing your data over time, helping you move beyond raw numbers to spot meaningful patterns and trends. By adding a median line and learning how to look for signals, you can gain a much deeper understanding of whether your performance is improving, holding steady, or in need of attention.

While Excel is great for these kinds of one-off analyses, we know the real challenge is often just pulling all your data together in the first place - especially from platforms like Google Analytics, Shopify, Facebook Ads, and your CRM. We built Graphed to automate that entire process. You simply connect your data sources, and you can create live, interactive charts and entire dashboards just by describing what you want to see in plain English. It turns hours of manual reporting into a quick, 30-second conversation.