Add a second series to your chart by selecting the data first, then using the chart editing tools

When you have two or more sets of related numbers — like monthly sales for different products, or temperature readings from different locations — you can show them all on a single chart instead of creating separate ones. Excel lets you add multiple data series to the same chart so you can compare them side by side.

The method depends on whether you're starting fresh or adding to a chart you've already made. If you're building a new chart, you select all your data at once before inserting the chart. If the chart exists, you edit it to include the additional series. Both approaches take just a few clicks.

Key Takeaways

  • Select all your data columns together — including headers — before inserting a chart, and Excel will automatically recognize each column as a separate series.
  • If you already have a chart, right-click it and choose "Edit Data" to add more series without starting over.
  • The chart type you choose (column, line, bar) determines how clearly multiple series display, so pick one that separates the data visually.
  • Each series needs its own column of data with a header row so Excel knows what to label it.

Select all your data columns before you create the chart

The easiest way to add multiple series is to include all of them when you first build the chart. Open your spreadsheet and arrange your data so each series is in its own column, with a header in the first row. For example, if you're tracking sales for three products, put Product A in column B, Product B in column C, and Product C in column D, with the month names in column A.

Click on the first cell of your data (including the header) and drag to select the entire range — all columns and all rows you want to include. You can also click the first cell, hold Shift, and click the last cell to select the whole block at once. Make sure your selection includes the header row; Excel uses those labels to name each series in the chart.

Once your data is selected, go to the Insert tab at the top of the screen and click Chart. Excel will open a dialog showing chart type options. Pick the type that works best for your data — column charts and line charts both display multiple series clearly — and click OK. Excel will create the chart with all your series already included.

Add a series to a chart that already exists

If you've already made a chart and want to add another series, right-click directly on the chart itself and select Edit Data from the menu that appears. This opens the data range editor, which shows you exactly which cells the chart is currently using.

In the data range window, you'll see a list of the series the chart already contains. Click the Add button to create a new series. Excel will ask you to select the data for that series — click and drag to highlight the cells that contain the new data you want to add. Include the header cell so the series gets labeled correctly. Click OK, and the new series will appear on your chart immediately.

If you need to remove a series instead, select it from the list and click Remove. You can also reorder the series by selecting one and clicking the up or down arrow buttons, which changes the order they appear in the chart legend.

Use column charts for side-by-side comparison

A column chart (vertical bars) works well when you want to compare multiple series at the same point in time. If you're showing quarterly revenue for three different regions, column charts let you see all three regions' numbers for Q1 side by side, then all three for Q2, and so on. The bars are easy to compare because they're grouped together.

Column charts handle up to four or five series comfortably before the chart gets crowded. If you have more than five series, consider using a line chart instead, since lines don't take up as much space. You can change your chart type at any time by right-clicking the chart, selecting Change Chart Type, and picking a different option.

Use line charts when you have many series or want to show trends

A line chart is better when you have many series to display or when you want to emphasize how each series changes over time. Each series gets its own colored line, and you can include six, seven, or even more series without the chart becoming unreadable. Line charts are also the standard choice for showing data that changes continuously, like stock prices or temperature throughout the day.

Make sure each line is a different color so you can tell them apart. Excel assigns colors automatically, but if two lines are too similar, you can change them. Right-click the chart, select Edit Data, choose the series you want to recolor, and then right-click that series and select Format Data Series to pick a new color.

Check your data range if a series doesn't appear

Sometimes you'll add data to your spreadsheet but the chart won't update automatically. This usually means the chart's data range doesn't include the new cells. Right-click the chart and select Edit Data to open the data range window. Look at the range shown — it might say something like $A$1:$D$10. If your new data is in row 11 or beyond, the range needs to be expanded.

Click in the range field and manually change the ending row number to include your new data. For example, change $A$1:$D$10 to $A$1:$D$15 if your data now goes to row 15. Press Enter, and the chart will refresh to show the additional data. This is especially important if you plan to add more data to your spreadsheet later — you can expand the range now to save yourself the step later.

Adjust the legend so readers know which series is which

The legend is the box that shows which color or pattern represents each series. By default, Excel places it to the right of the chart, but you can move it if it's covering important data. Right-click the chart and select Edit Legend (or Format Legend depending on your Excel version), then choose a new position — bottom, top, left, or right.

If the legend labels are hard to read or don't match your data, go back to the data range editor (right-click the chart, select Edit Data) and check that each series has a clear header in the spreadsheet. The legend pulls its labels directly from those headers, so fixing the header text fixes the legend automatically.

Frequently Asked Questions

Can I add a series that's not next to my other data?

Yes. When you edit the chart's data range, you can add non-adjacent cells by typing them with a semicolon between ranges — for example, $A$1:$C$10;$E$1:$E$10. This tells Excel to include columns A through C and also column E, even though they're not touching.

What if my series have different numbers of data points?

Excel will plot whatever data exists for each series. If one series has 12 months of data and another has only 10, the chart will show all 12 months on the horizontal axis, and the shorter series will simply end earlier. This works fine for most charts, though it can look odd if the difference is very large.

How do I change the order of series in the legend?

Right-click the chart and select Edit Data. In the data range window, select the series you want to move and click the up or down arrow buttons to reorder it. The order in this list determines the order they appear in the legend and how they're stacked in column charts.

Can I show one series as bars and another as a line on the same chart?

Yes, but only in a combo chart. Right-click your chart, select Change Chart Type, and look for Combo options. These let you assign different chart types to different series — for example, one series as columns and another as a line. This is useful when your series have very different scales or represent different kinds of data.

Why does my chart look crowded with multiple series?

Too many series or too many data points can make a chart hard to read. Try using a line chart instead of columns, since lines take less space. You can also make the chart larger by dragging its corners, or remove series you don't need to compare right now and add them back later.