How to Add Median Line to Excel Chart

Adding a median line to an Excel chart provides a powerful visual cue that instantly shows the true midpoint of your dataset. It’s a simple-yet-effective way to add context that an average line might distort. This tutorial will walk you through exactly how to calculate the median and add it as a clean, clear line to your column, bar, and scatter charts.

Graphed

Still Building Reports Manually?

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

Watch the Demo

First, a Quick Refresher: What Is a Median and Why Use It?

While most people default to the "average" (or mean), the median is often a more honest representation of your data's central point. The median is the value that falls exactly in the middle of a dataset when it's arranged from smallest to largest.

Why does this matter? Because the average can be heavily skewed by unusually high or low numbers, known as outliers. The median, on the other hand, isn't affected by them.

Imagine you're analyzing the monthly revenue from five marketing campaigns:

• Campaign A: $1,000
• Campaign B: $1,500
• Campaign C: $2,000
• Campaign D: $2,500
• Campaign E: $25,000

The average revenue is $6,400, but that number is inflated by the one breakout campaign. It doesn't accurately represent a "typical" campaign's performance. The median, however, is the middle value ($2,000), which gives you a much better benchmark for what a standard campaign brings in. When you visualize data with outliers, a median line tells a more truthful story.

The Foundation: Calculate the Median in Excel

Before you can chart a median line, you have to calculate the median value from your data. Fortunately, Excel makes this incredibly simple with the =MEDIAN() function.

Let's say your data is in cells B2 through B13. To find the median of these values, you would use this formula:

=MEDIAN(B2:B13)

Simply click into an empty cell, type this formula (adjusting the cell range to match your data), and press Enter. Excel will instantly show you the median value. This is the number we'll use to create our charted line.

Graphed

Still Building Reports Manually?

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

Watch the Demo

Method 1: Add a Median Line to a Column or Line Chart

The most common scenario is adding a horizontal median line across a column, bar, or line chart. The best way to do this is by creating a combo chart. It sounds complex, but it's just a few simple steps.

For this example, let's assume we have a list of monthly sales figures in a table.

Step 1: Create a Helper Column for the Median

Go to your data table and add a new column next to your data. Let's call it "Median." In the first empty cell of this new column (C2 in our example), we'll calculate the median for our entire sales range.

Here’s the critical part: you must use absolute cell references (with dollar signs) so that the same median value is repeated for every row. This ensures the line will be perfectly straight. For a sales range of B2:B13, the formula would be:

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

The dollar signs lock the reference to that specific range. After typing the formula, press Enter. Then, click the small green square at the bottom-right corner of the cell and drag it down to fill the formula for all the rows in your table. Your table should now look like this, with the same median value repeated:

(You can imagine the table now has a "Median" column with the same value in each row.)

Step 2: Create a Basic Chart

Now, select all of your data, including the new Median column and the headers. Go to the Insert tab on the Excel ribbon and choose your preferred chart. A simple “Clustered Column” chart works perfectly for this.

Excel will generate a chart showing your sales data as blue bars and your median data as orange bars. This doesn't look right yet, but don't worry – we're about to fix it.

Graphed

Still Building Reports Manually?

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

Watch the Demo

Step 3: Convert to a Combo Chart

This is where the magic happens. Right-click on one of the orange "Median" bars within the chart. From the context menu, select "Change Series Chart Type...". This opens the Combo chart dialog.

Here you'll see both of your data series ("Sales" and "Median") listed. You can assign a different chart type to each one.

• Leave the "Sales" series as a Clustered Column.
• For the "Median" series, click its dropdown menu and change the chart type to "Line."

Click OK. Your chart will instantly transform. The sales data remains as columns, while the median data becomes a perfectly straight horizontal line cutting across the chart.

Step 4: Format Your Median Line for Clarity

The default line might be a bit plain. You can make it stand out and look more professional.

• Change the Style: Right-click on the median line and select "Format Data Series." In the Format pane that appears, you can change the color, make the line thicker, or change it to a dashed style for clearer visual differentiation.
• Add a Label: Right-click the line again and choose "Add Data Label." This will place the median value directly on the line, removing any guesswork for your audience.

Method 2: Adding Median Lines to a Scatter Plot

Adding vertical or horizontal median lines to scatter plots requires a slightly different approach, as you need to define the start and end points of the line. It's still easy, but involves creating a small, separate table.

Step 1: Calculate the Medians for Your X and Y Axes

First, find the median for both your horizontal (X-axis) and vertical (Y-axis) data using the =MEDIAN() formula.

You’ll also need the minimum and maximum values for each axis to define the boundaries of the line. Use the =MIN() and =MAX() functions. Keep these values handy in a few separate cells.

Step 2: Build Helper Tables for Your Lines

To draw a line in a scatter plot, Excel needs at least two points. We'll create tiny tables for this purpose.

For a Horizontal (Y-axis) Median Line:

Create a small, two-row, two-column table. The first column will hold the minimum and maximum X-axis values. The second will hold the Y-axis median value, repeated twice.

For a Vertical (X-axis) Median Line:

Create another small table. This time, the first column repeats the X-axis median value, and the second column holds the minimum and maximum Y-axis values.

Graphed

Still Building Reports Manually?

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

Watch the Demo

Step 3: Add the Lines to Your Scatter Plot

1. Make sure you already have a scatter plot created with your primary X and Y data.
2. Right-click anywhere inside the chart area and choose "Select Data."
3. In the "Select Data Source" dialog, under "Legend Entries (Series)," click the "Add" button.
4. A small "Edit Series" dialog will pop up.

When you close the dialog, you'll see your median lines appear on the scatter plot. Excel will plot them as new data points first.

Step 4: Format to Connect the Dots

To turn the dots into lines, right-click one of the new data points on the chart (e.g., one of the vertical median points) and choose "Format Data Series." In the options pane, go to the "Fill & Line" section (the paint bucket icon), select "Solid line," and choose your desired color and style. Do the same for the other set of median data points.

The result is a clean scatter plot with clearly-defined median lines, giving you immediate insight into the distribution of your data.

Final Thoughts

Calculating the median in a separate column and using Excel's combo chart feature provides a straightforward way to add essential context to your reports. This simple horizontal line can tell a clearer story than an average, helping you and your team make decisions based on what's typical, not what's skewed by outliers. The same logic applies to scatter plots, where a few helper cells let you build a powerful visual guide.

When you find yourself building the same reports in Excel or Google Sheets every week, the process of adding helper columns, re-creating charts, and fixing formatting can become tedious. At my company, we built Graphed to remove this manual repetition from your workflow. You just connect your data sources directly - like Google Analytics, HubSpot, or Shopify - and ask for the analysis in plain English. Instead of building tables and charts, you can just ask, "Show me sessions by source as a bar chart with a median line," and our AI generates a live, interactive dashboard for you in seconds.