
How Do You Plot Multiple Data Sets in Excel?
Carlos GarciaPublished How Do You Plot Multiple Data Sets in Excel?
Almost every chart that matters has more than one line on it. Revenue this year against revenue last year. Sessions against conversions. Three regions on the same axis so somebody can see which one is pulling ahead.
Excel makes the single-series version trivial. Select a column, press a button, get a chart. The moment you want a second data set on the same chart, the path stops being obvious, and the dialog that actually does the job is one Microsoft's own getting-started documentation never mentions.
This guide covers the four situations you will actually hit: data sets sitting side by side, data sets scattered across non-adjacent columns, a chart that already exists and needs another series bolted on, and the awkward case where two data sets are on scales so different that one of them flattens into a straight line.
What Is the Short Answer?
If the data sets sit in adjacent columns, select all of them at once, including the header row and the shared category column, then insert the chart. Excel reads each column as its own series and plots them together without any further work.
If they are not adjacent, hold Ctrl while you drag over each block you want. Excel treats the combined selection as one range, keeps the column structure, and plots one series per column.
If the chart already exists, right-click it and choose Select Data. The dialog that opens lists every series currently plotted and lets you add another one by pointing at its name cell and its value range.
And if one data set is in the thousands while the other is in single digits, do not try to fix it with formatting. Move the smaller series onto a secondary axis, which Excel exposes through its combo chart options.
Free audit
Where do you stand in AI search?
A manual SEO + AI search audit of your site: how ChatGPT, Gemini, Perplexity and Claude read and cite it today, and what to fix first. Report within 48 hours, no credit card.
Get my free auditOr have it all done: AI SEO services, $999 once
What Does "Multiple Data Sets" Actually Mean in Excel?
The phrase gets used loosely, and the ambiguity is the reason people get stuck. Excel has a precise vocabulary here, and once you know which object you are adding, the command you need stops being a guess.
A Series Is Not a Data Point
A series is one set of related values that Excel draws as one line, one set of columns, or one set of markers. A data point is a single value inside that series. When you add a second data set to a chart you are adding a series, not data points.
This matters because the two have very different ceilings. Microsoft's published charting limits put "Data series in one chart" at 255. For data points, the specification does not give a number at all: both "Data points in a data series for 2-D charts" and "Data points for all data series in one chart" are listed as "Limited by available memory."
So the hard structural limit is on series, and 255 is far beyond anything a readable chart would ever use. The practical limit is your reader's eyes, not Excel's.
Adjacent and Non-Adjacent Ranges Behave Differently
Excel's chart engine infers structure from the shape of your selection. A rectangular block with headers across the top and categories down the left side is the layout it expects, and it will get the series right nearly every time.
A non-rectangular selection, built by Ctrl-clicking two columns with a third column skipped in between, still works, but you need to select the same number of rows in each block. Mismatched row counts are where this goes wrong.
Shared Scale Versus Mixed Scale
Two data sets belong on one axis when they are measured in the same unit and sit in roughly the same numeric range. Sessions and users, both in the thousands, are fine together.
Sessions in the thousands and conversion rate at 2.4 percent are not. Plotted on one axis, the conversion rate line sits flat on the baseline and tells the reader nothing. That is a secondary axis problem, and it is covered further down.
Not sure whether your reporting is actually answering the questions your stakeholders are asking? SEO Stuff's free audit looks at the whole measurement setup, not just the charts. Start your free audit and see what your data is missing.
How Do You Plot Multiple Data Sets, Step by Step?
Three paths, depending on where your data lives and whether a chart already exists.
From Columns That Sit Side by Side
Lay the sheet out with the shared category in the leftmost column. Dates, months, region names, whatever every series has in common. Then put each data set in its own column to the right, with a short header at the top of each.
Select the whole block, headers included. Go to the Insert tab, pick the chart type you want, and Excel plots one series per data column, using the headers as series names and the leftmost column as the category labels.
Microsoft's own walkthrough recommends starting from Insert and then Recommended Charts, which opens a gallery of suggestions based on what you selected. There is also a keyboard shortcut worth knowing: with the range selected, Alt + F1 drops a chart straight onto the current sheet with no dialog at all.
If the series and the categories come out swapped, which happens when your layout has categories across the top instead of down the side, use the Switch Row/Column control on the Chart Design tab. It transposes the interpretation without touching your data.
From Columns That Are Not Next to Each Other
Real spreadsheets are messy. The two columns you want are often separated by three you do not.
Select the first block normally. Then hold Ctrl and drag over each additional block. Include the header cell in every block so Excel can name the series. Keep the row range identical across all blocks, because a selection where one column covers rows 2 to 50 and another covers rows 2 to 40 will produce a chart with a gap in it.
Insert the chart as usual. Excel collapses the non-adjacent selection into a single logical range and plots it exactly as if the columns had been side by side.
Adding a Series to a Chart That Already Exists
This is the path people search for most, and it is the one Microsoft's getting-started page does not document.
Right-click anywhere in the chart area and choose Select Data. The dialog lists the plotted series on the left and the category labels on the right. Click Add, then point the series name field at the header cell of your new data set and the series values field at its value range.
Confirm, and the new series appears. The same dialog's Edit button lets you repair a series whose range has drifted, and its arrows let you reorder series, which changes the drawing order and therefore which line sits on top where they overlap.
One habit worth building: point the series name at a cell rather than typing the name in. A typed name is static. A cell reference updates itself when somebody renames the column.
Reporting that nobody reads is a measurement problem before it is a charting problem. A free audit from SEO Stuff shows you which numbers are worth putting on a chart in the first place.
What Do You Do When the Scales Do Not Match?
A secondary axis gives one series its own vertical scale on the right-hand side of the plot area, so a small-magnitude series can be read against a large-magnitude one.
Microsoft frames this as a combo chart feature. Its guidance is that a secondary axis "works well in a chart that shows a combination of column and line charts," and the fastest route is to change the chart into a combo chart rather than to add an axis to the chart you already have.
The path: select the chart, go to Chart Design, choose Change Chart Type, and pick Combo. The dialog lists every series with its own chart-type dropdown and a Secondary Axis checkbox. Set the large-magnitude series to Clustered Column on the primary axis, set the small-magnitude series to Line, and tick Secondary Axis on that second one.
Microsoft offers a preset for exactly this shape, named "Cluster Column - Line on Secondary Axis," which does both steps in one click. If you need to add the axis to an already-selected series instead, the documented route is Add Chart Element, then Axes, then the secondary option. Axis titles follow the same path under Add Chart Element and Axis Titles.
Microsoft's own stated use cases for a secondary axis are narrow: use one "when the values in a chart vary widely from data series to data series," and for mixed data types, with price and volume given as the example.
A word of caution that Microsoft does not offer. A secondary axis is the easiest way to make two unrelated series look correlated, because you choose both scales and the apparent relationship between the lines is an artifact of that choice. Label both axes. If the chart is going to anyone making a decision, say in the caption what each axis measures.
When Is One Chart the Right Choice, and When Should You Split?
Put multiple data sets on one chart when the comparison between them is the point. Same unit, same time axis, and a reader who needs to see the gap, the crossover, or the divergence.
Three to four series is the comfortable ceiling for a line chart that someone has to read in a meeting. Beyond that, lines cross often enough that color alone stops distinguishing them, and the chart becomes a picture of complexity rather than a picture of data.
Split into separate charts when the series answer separate questions, when the units are genuinely different and a secondary axis would mislead, or when you have more than about six series. A row of small charts with identical axes, one per series, is almost always more readable than one chart with six lines on it.
Split also when your series have different time granularities. Daily data and monthly data on one axis will either compress the daily series into noise or stretch the monthly one into a staircase.
Before you build another dashboard, find out whether you are tracking the right things. SEO Stuff's free audit reviews your analytics setup and tells you what is missing.
What Are the Limitations Worth Knowing?
The structural limits are generous and the documentation gaps are not.
Microsoft publishes a ceiling of 255 data series in one chart, and 255 worksheets referred to by a chart. Those are the only hard numbers in the charting section of the specifications. Everything else, including every data-point limit and the number of charts linked to a worksheet, is published as "Limited by available memory" rather than as a figure.
More interesting is what Microsoft does not document at all. Its "Create a chart from start to finish" page, last updated in 2026 and covering Excel for Microsoft 365 back to Excel 2016, walks through selecting data, Recommended Charts, the All Charts tab, Alt + F1 and adding a trendline. It does not mention the Select Data dialog, adding a series to an existing chart, Switch Row/Column, non-adjacent selection, or combo charts anywhere.
That is a real gap rather than an oversight on your part. The single most common multi-series task, adding a second data set to a chart that already exists, is absent from the page a beginner would naturally land on.
The secondary-axis page has its own problems. It publishes no restrictions at all: no list of chart types that cannot take a secondary axis, no note about what happens when you combine incompatible types. It is also internally inconsistent, describing the combo route as Change Chart Type in one place and the direct route as Add Chart Element in another, and it carries a step marked for Word on Mac that has no bearing on Excel at all.
Neither page offers any readability guidance. There is no Microsoft statement anywhere in this documentation about how many series is too many, which is the judgment call that actually determines whether your chart works.
Two practical limitations worth planning around. Series ranges are static references, so adding a row of new data below your range will not appear on the chart unless the range covers it. Converting the source to an Excel Table first solves this, because the table expands and the chart follows. And series order controls drawing order, so where lines overlap, the series lowest in the Select Data list is drawn on top.
Multiple Series vs the Alternatives
A single multi-series chart is not the only way to show several data sets, and it is often not the best one.
Small multiples, meaning a grid of separate charts sharing identical axes with one series each, beat a crowded single chart whenever you have more than about four series. Excel has no built-in small-multiples feature for standard charts, so you build it by copying one chart and repointing each copy's series, but the readability gain is worth the manual work.
A PivotChart suits the case where the series themselves are not fixed. If you want to flip between regions, products and channels as your series, build a pivot table first and chart that. The series then follow the pivot's field layout rather than a hard-coded range.
A combo chart is the right answer specifically when the data sets differ in kind rather than only in scale. Volume as columns and price as a line is the classic shape, and Microsoft's own example uses exactly that pairing.
Conditional formatting data bars inside the cells are an underrated alternative when the comparison is between rows rather than over time. No chart object, no axis to mislabel, and the numbers stay visible next to their own bars.
Charts are the last step. Getting the measurement right is the first. Take SEO Stuff's free audit and start with data you can trust.
Final Thoughts
Plotting multiple data sets in Excel comes down to one decision made twice. First, where is the data, which determines whether you select a block, Ctrl-select scattered columns, or open Select Data on an existing chart. Second, do the series share a scale, which determines whether you keep one axis or move to a combo chart with a secondary one.
Everything after that is restraint. Excel will happily draw 255 series. Your reader can follow about four.
Keep the categories in one shared column, name every series from a cell rather than by typing, convert the source range to a table so new rows show up on their own, and label both axes the moment a second one appears.
If your next step is mixing chart types rather than only adding series, our guide to what a combo chart is in Excel covers the variants and where they fall down.
Every limit and command name above was checked against Microsoft's own Excel specifications, secondary-axis and create-a-chart support pages on November 18, 2026, and the documentation gaps described are gaps in those pages as published on that date.
Want this done for you?
SEO Stuff gets businesses cited by ChatGPT, Gemini, Perplexity and Claude, and ranking in Google. Start with the free audit, a call, or the package.
See where you stand
A free, manual SEO + AI search audit of your site, with a report within 48 hours. No credit card, no sales call.
Get my free auditTalk it through
A free 15-minute call with the founder about whether AI search is a meaningful opportunity for your business.
Free strategy callHave it done
The Done-For-You Package: audit, 10 pages of content, 3 DR50+ placements, dashboard. $999 once, delivered in 21 business days.
See the package

