OmniDocHow to Make a Run Chart in Excel
Learn how to build a run chart in Excel from time-ordered data, add a median line, and read the patterns it shows, step by step.
If you track measurements over time, such as weekly defect counts, daily call volumes, or monthly test scores, a plain line chart often hides the story. A run chart fixes that by plotting each value in the order it happened and adding a median line across the middle. Quality analysts, teachers, and small business owners use run charts to see whether a process is steady, drifting, or shifting.
Excel can build a run chart without any add-ins. You enter the data in time order, calculate the median, add it as a second series, and format the result. This guide walks through each step for an Excel spreadsheet (.xlsx), and it explains how to read the finished chart.
How do you make a run chart in Excel? The short answer
Put your values in time order, plot them as a line chart with markers, and add a constant median line as a second series. Then check the order and the runs around the median.
| Your situation | What to do | Why |
|---|---|---|
| Data is already in a spreadsheet | Build the chart directly from the columns | Fewest steps, and the chart updates when you edit values |
| Data is in a PDF table | Export the table to Excel first, then check each column | Charts need clean numeric cells, not text that looks like numbers |
| Dates are uneven | Use a line chart with a date axis, or a scatter chart with lines | A standard category axis spaces points evenly, which can distort the timing |
| You need to share the chart | Copy the chart into a document and label the axes clearly | Readers need the units, time period, and median value to interpret it |
Before you start
- Confirm the data is in the order it happened. A run chart depends on sequence. If the rows are sorted by value, the chart will show a false pattern.
- Use one measure per chart. Mixing units, such as hours and dollars, in one series makes the median meaningless.
- Collect enough points to see a pattern. A 30-day log of daily values gives you enough data to see runs. Five points rarely show anything useful.
- Decide how you will label time. Use dates, week numbers, or batch numbers. Pick one format and use it throughout.
- Check for blanks. Empty cells can break the line or pull the median in the wrong direction. Decide whether to fill them, mark them, or leave them out, and note your choice.
If your figures are in a PDF, the desktop client's PDF editor can export to Excel. Once the table opens in your spreadsheet, check that numbers are stored as numbers and dates as dates before you continue.
Building a run chart in Excel, step by step
- Enter the time labels in column A. Put a header in cell A1, such as "Week," and list the labels from A2 downward in order.
- Enter the values in column B. Put a header in B1, such as "Defects," and enter one measurement per row, lined up with the labels in column A.
- Calculate the median in a spare cell. In an empty cell, such as E1, enter a formula like =MEDIAN(B2:B31), changing the range to match your last row. Using a formula means the median updates if you change the data.
- Fill the median down a column. In C1, type a header such as "Median." In C2, reference the median cell with an absolute reference, such as =$E$1, then copy that formula down to the last data row. Every row now holds the same median value, which becomes your reference line.
- Select the data for the chart. Select the headers and values in columns A, B, and C, covering every data row. Leave out the spare cell with the formula.
- Insert a line chart with markers. Open the chart options on the Insert tab and choose a line chart with markers. Excel will plot the value column and the median column as two series on the same axes.
- Format the median line and add labels. Right-click the median series, change it to a dashed line without markers, and give it a clear color. Then add a chart title, such as "Weekly defects, Jan to Jun," and axis titles that include units.
Check the result
Once the chart is built, look at it with a critical eye before you share it. The table below lists common problems.
| Check | How to see it | If it's wrong |
|---|---|---|
| Points are in the right order | Read the x-axis labels from left to right | Sort the rows by date or sequence, not by value, then rebuild the chart |
| Median line sits in the middle | Count points above and below the line | Confirm the MEDIAN range covers every data row and no extra rows |
| No unexpected breaks | Look for gaps or drops to zero | Check blank cells and text entries, and fix or note them |
| Axis scale shows the data | Confirm the data fills most of the vertical space | Set the minimum and maximum axis values so small changes are visible |
| Labels match the data | Compare titles and units with your source | Edit the axis titles and chart title to state the measure and period |
When you read the chart, look at runs. A run is a string of consecutive points on the same side of the median. A long run above the line, or a clear shift in level, suggests the process changed at that point. Many short runs that zigzag across the line often suggest random variation. Treat these as signals to investigate, not conclusions, and confirm them against what happened in the period.
Machine-generated numbers from OCR or automated exports can contain errors, so check any figure that matters before you publish the chart.
❓ FAQ
1. What is the difference between a run chart and a control chart?
A run chart plots values in order with a median line, which helps you see trends and shifts. A control chart adds calculated control limits based on the process variation. Start with a run chart when you need a simple first look at data over time.
2. Why does my median line look slightly off from the middle?
The median depends on the exact range you used in the formula. Check that the range covers every data row and nothing else, including any header or total row. If the number of points is even, the median falls between the two middle values, so the line may not match a visible data point.
3. Can I use a scatter chart instead of a line chart?
Yes. A scatter chart with lines works well when your time values are uneven, because the horizontal spacing reflects the actual time between points. Use the same median column and format it the same way.
4. Can OmniDoc make the chart for me?
OmniDoc does not create charts in this workflow. The desktop client's PDF editor can export a PDF table to Excel, which gives you the data for the steps above. You build and format the run chart in your spreadsheet program.
📝 Summary
A run chart in Excel comes down to three parts: time-ordered values, a median calculated by formula, and a line chart with the median as a dashed reference series. Check the order, the median range, and the runs before you draw conclusions from the chart.
