How to Make a Run Chart in Google Sheets

A run chart is one of the simplest and most powerful ways to visualize your data over time, yet it's often overlooked. It’s a simple line graph that helps you see trends and patterns in your data, separating meaningful signals from random noise. This tutorial will walk you through exactly how to create a useful run chart in Google Sheets, step by step, from formatting your data to interpreting what the chart is actually telling you.

Graphed

Your AI Data Analyst to Create Live Dashboards

Connect your data sources and let AI build beautiful, real-time dashboards for you in seconds.

Build Your First Dashboard

What is a Run Chart, Anyway?

At its core, a run chart tracks a specific measurement over a set period. Think of it as a historical record of a process. This could be anything from daily website visitors and weekly sales figures to monthly customer support tickets. Just like a standard line chart, it plots data points on a graph and connects them with a line, making uptrends, downtrends, and unusual spikes immediately obvious.

The secret sauce that elevates a simple line graph to a true run chart is the addition of a center line, which is typically the median of all the data points. Why the median? Because it's less sensitive to extreme outliers than the average (mean). A single, unusually high sales day won't drag the entire center line upwards, giving you a more stable and realistic baseline for comparison.

By plotting your data against this median line, you can quickly answer questions like:

• Is our performance improving, declining, or staying the same?
• Did our recent marketing campaign actually create a sustained lift in traffic?
• Is the fluctuation we're seeing normal, or is it something we need to investigate?

It’s the perfect first step for anyone who wants to move beyond just looking at raw numbers in a spreadsheet.

AI for Data Analysis

Crash Course

Graphed

Free PDF Guide

AI for Data Analysis Crash Course

Learn how to get AI to do data analysis for you — the best tools, prompts, and workflows to go from raw data to insights without writing a single line of code.

Download Free Guide

Step 1: Get Your Data Ready

Before you can make a chart, you need clean, well-structured data. For a run chart, this is very straightforward. All you need are two columns in your Google Sheet:

• Column A: Time Period. This should be your horizontal X-axis. List your time intervals sequentially - day, week, month, quarter, etc. Make sure these are formatted as dates or plain text so they sort correctly.
• Column B: Measurement. This is your vertical Y-axis, the metric you want to track. This column should contain only numbers, like the number of sales, website sessions, or new leads.

Pro Tip: Keep your time intervals consistent. If you start with daily data, stick with daily data. Mixing daily, weekly, and monthly data in the same chart will make trends impossible to read accurately.

Step 2: Create the Basic Line Chart

With your data in place, creating the initial chart takes less than a minute. Google Sheets makes this process incredibly easy.

1. Select your data. Click and drag to highlight both columns, including the headers ("Date" and "Tickets").
2. Insert the chart. Go to the menu bar at the top and click Insert > Chart.
3. Choose the right chart type. Google Sheets is pretty smart and will often default to a Line chart, which is what we want. If it suggests something else, go to the Chart editor pane on the right, click the Setup tab, and select "Line chart" from the dropdown menu.

This is a good start! You can already see the daily fluctuations. But to turn this into a proper analytical tool, we need that median line.

Graphed

Your AI Data Analyst to Create Live Dashboards

Connect your data sources and let AI build beautiful, real-time dashboards for you in seconds.

Build Your First Dashboard

Step 3: Add the All-Important Median Line

Now we’ll add the center line that makes a run chart so valuable. This involves adding one more column to our spreadsheet and inputting a simple formula.

Calculate the Median

1. In your sheet, click on the header for column C (right next to your "Tickets" data) and title it "Median."
2. In the first cell beneath the header (C2 in our example), type the following formula and press Enter:

=MEDIAN($B$2:$B)

1. This is what the formula does:
2. Now, copy this formula down the entire column. Click on cell C2, and you'll see a small blue square in the bottom-right corner. Double-click that square, and it will automatically fill the formula down to the last row of your data.

Add the Median to Your Chart

Once you have your "Median" column, adding it to the chart is simple.

1. Click once on your chart to select it.
2. In the Chart editor on the right, under the Setup tab, look for the "Data range" field.
3. It probably says something like A1:B22. Click on it and change it to include your new Median column. In our example, we’d change it to A1:C22.

As soon as you press Enter, a straight horizontal line representing your median will appear on the chart.

Step 4: Customize Your Run Chart for Clarity

A default chart works, but a little customization makes it much easier to read and present to others. Here are a few recommended tweaks:

In the Chart editor pane, switch from the Setup tab to the Customize tab.

• Distinguish the median line. Click on the "Series" dropdown. Select your Median series. Here, you can change its color (red is a common choice), make it a dashed line, or adjust its thickness to make it stand out as a reference line, not a data line.
• Add a clear title. Go to "Chart & axis titles." Give your chart a descriptive name, like "Daily Support Tickets - October 2023."
• Label your axes. Under the same section, you can add or edit titles for both the horizontal ("Date") and vertical ("Number of Tickets") axes. This removes any guesswork for your audience.

After these quick adjustments, you'll have a clean, professional, and much more insightful run chart.

AI for Data Analysis

Crash Course

Graphed

Free PDF Guide

AI for Data Analysis Crash Course

Learn how to get AI to do data analysis for you — the best tools, prompts, and workflows to go from raw data to insights without writing a single line of code.

Download Free Guide

How to Interpret Your Run Chart: Finding Signals in the Noise

Creating the chart is only half the battle. Now comes the important part: understanding what it's telling you. The goal is to identify "non-random" signals that suggest a real change has occurred in your process.

Statisticians have several formal rules for this, but here are four simple ones that cover most business scenarios:

1. The Shift Rule: Look for a long string of consecutive data points all on the same side of the median line. A run of eight or more points either all above or all below the median is a strong indicator that a fundamental change has happened.
2. The Trend Rule: Look for a long string of consecutive data points that are all moving in the same direction - either all up or all down. Five or more points in a row forming a trend is statistically significant.
3. The Runs Rule: A "run" is a group of one or more consecutive points on the same side of the median. If you have too few "crossings" of the median line, it hints at clustering and a potential process shift. Conversely, too many crossings (data zig-zagging wildly up and down over the median) suggests instability.
4. The Outlier Rule: Sometimes a single data point is so dramatically different from the others that it clearly sticks out. This is often called an "astronomical" point.

Final Thoughts

Creating a run chart in Google Sheets is a direct process that turns a simple spreadsheet into a powerful tool for process analysis. Adding a median line and knowing how to spot trends, shifts, and outliers helps you understand performance, confirm the impact of changes, and make better-informed decisions based on real data.

While building charts yourself is a necessary skill, we know that the manual cycle of exporting CSVs, cleaning spreadsheets, and constantly updating reports for every data source can become a huge time sink. That’s why we built Graphed. We connect directly to your tools like Google Analytics, Salesforce, and Shopify so you can create live dashboards just by asking in plain English. Instead of wrangling formulas for a median line, you can simply ask, "Show me a line chart of daily website sessions compared to the monthly median," and get a real-time visualization in seconds, no spreadsheets required.