Excel Chart Multiple Series: Add and Format Them

Yes. To chart multiple series in Excel for Microsoft 365 on Windows, arrange each series in its own row or column, select the data, and choose Insert > Recommended Charts. To add a series to an existing chart, select the chart and use Chart Design > Select Data > Add; Excel then lets you specify the series name and value range.

What multiple series means in an Excel chart

A data series is a set of related values that Excel plots as a group. In a line chart, each series usually becomes a separate line; in a column chart, it becomes a set of columns; and in a scatter chart, it becomes a set of points. A chart with multiple series makes it possible to compare several groups against the same categories or measurement scale.

For example, a monthly sales table might have months in the first column and separate columns for North, South, and West. Each region is a series, and the months are the category labels along the horizontal axis. A line chart can show whether the regions rise or fall together, while a clustered column chart makes their sales values easier to compare month by month.

Series and categories are different parts of the chart. Categories identify positions such as months, departments, or product names. Series identify the groups being compared. Excel often infers this arrangement from the selected range, but it can guess the wrong orientation when the table is square, has unusual headings, or includes extra rows and columns. The preview and the Switch Row/Column control help you check its interpretation.

Arrange the data before creating the chart

A clear rectangular table gives Excel the best chance of identifying series correctly. Put descriptive headings in the first row or column, use one row or column per series, and keep the category labels in a single adjacent row or column. Avoid merged cells, blank spacer rows inside the data, and totals mixed into the same range as the observations.

For example, this layout treats each region as a series and each month as a category:

Column A: Month
Columns B through D: North, South, and West sales
Rows 2 through 13: January through December

Excel can also chart series arranged in rows, with the categories across columns. The orientation is not inherently better one way or the other; choose the layout that is easiest to read and maintain in the worksheet. Include the heading cells when you select the table so Excel can use them for the legend, and include the category labels so the axis shows meaningful names rather than default numbers.

Keep units and time periods consistent within a series. For example, do not mix dollars and unit counts in the same ordinary chart axis. If the table contains a total row, leave it out of the chart selection unless comparing the total with the component groups is intentional; including it can make the individual values look small.

Create a chart with several series

With the data laid out as a table, select the complete range, including headings and category labels. In Excel for Microsoft 365 on Windows, open Insert > Recommended Charts, review the suggested charts, and select one that suits the comparison. You can also choose a chart directly from the Insert tab, such as Insert Line or Area Chart or Insert Column or Bar Chart. Selecting the chart type directly is useful when you already know which visual form fits the data.

After insertion, check that each intended group appears in the legend and that the category axis contains the expected labels. Click the chart to show the Chart Design and Format tabs. Use Chart Design > Switch Row/Column if Excel has treated each month as a separate series rather than treating each region as one series. This command changes how the selected data is grouped; it does not rearrange or alter the worksheet cells.

For an existing chart, select it and choose Chart Design > Select Data. In the Select Data Source dialog, use Add to create another series. Enter or select a cell for the Series name, then select the numeric cells for Series values. Do not include the heading cell in the values range. If the new series uses the same categories as the others, leave the horizontal category labels unchanged. Select Edit in the Horizontal (Category) Axis Labels area if you need to replace those labels.

Use the dialog’s Remove button to take a series out of the chart without deleting its worksheet data. The Edit button can change a selected series name or range. If a series appears in the wrong order, use the move controls in the dialog where available; order matters in some chart types because later series can visually cover earlier ones.

Choose the chart type for the comparison

A chart can contain multiple series without making them easy to understand. Pick the form based on the question the chart should answer. Line charts are suited to changes over ordered time periods. Clustered columns or bars compare groups within each category. Stacked columns show how group values contribute to a total, while 100% stacked charts emphasize each group’s proportion of the whole rather than its absolute size.

Use a line chart when the sequence or trend matters, such as monthly customer visits.
Use clustered columns when readers need to compare values across categories and groups.
Use stacked charts when the components and their combined total are both relevant.
Use an XY scatter chart when both horizontal and vertical values are numeric measurements, rather than named categories.

With many series, a chart can become crowded. Several lines may overlap, and a long legend may be harder to scan than the plot itself. Consider charting a smaller set of relevant groups, splitting the comparison into separate charts, or using small multiples—several similarly formatted charts arranged together. A chart is not improved simply by including every available column.

Format and label multiple series clearly

Give every series a concise, distinct name. The legend typically uses the series headings, so headings such as North, South, and West are more useful than Series 1 or a long sentence. To change a heading used in the chart, edit the source cell or use Chart Design > Select Data and edit the series name. A chart title should explain the subject and, when needed, the time period or unit.

To change a series’ appearance, select one of its plotted marks and use the formatting controls on the Format tab or the Format Data Series pane. Line charts can use different colors and line styles; column charts can use fills and borders. Keep the visual differences easy to distinguish and use a restrained palette. Color alone may not be enough for readers with color-vision differences, so labels, marker shapes, or line styles can help when appropriate.

Data labels can clarify exact values, but adding labels to every point in a chart with many series can create clutter. A useful compromise is to label only important points, use a data table below the chart, or leave the values in the worksheet and provide a clear axis scale. For chart elements such as titles, legends, and axis titles, select the chart and use Chart Design > Add Chart Element. The exact options offered depend on the chart type.

Use a secondary axis carefully

When series use different units or have very different magnitudes, one shared vertical scale can hide the smaller values. A combo chart can place one series on a secondary vertical axis while showing another series on the primary axis. For example, a chart might show monthly revenue as columns and an order count as a line on a second scale.

To create one in Excel for Microsoft 365 on Windows, select the chart and choose Chart Design > Change Chart Type. In the Combo category, choose a chart type for each series and select Secondary Axis for the series that needs its own scale. The available choices depend on the data and chart types. Add clear axis titles so readers know what each scale measures.

A secondary axis is not a general fix for an unattractive chart. Two scales can make unrelated movements appear to track each other, and the visual comparison may be misleading if the scales are chosen poorly. Use one only when the different units or ranges justify it, label both axes, and make the chart type and scale choices apparent to readers.

Fix common multiple-series chart problems

If Excel plots the wrong groups, first check the selected range for an extra heading, total, or blank column. Then try Chart Design > Switch Row/Column. If the chart is already built, use Chart Design > Select Data to inspect the series names, values, and category labels individually. A series with a wrong range may still appear in the legend, even if its plotted values are missing or incorrect.

A series is missing: Open Select Data and use Add, or expand the chart’s source range to include the omitted column or row.
The legend shows generic names: Include the heading cells in the source range or edit the series names in Select Data.
The horizontal axis shows 1, 2, 3: Edit Horizontal (Category) Axis Labels and select the cells containing the intended labels.
One series looks flat: Check whether its values are much smaller or larger than the other series, or whether the data contains text or blanks instead of numbers.
The line has breaks: Check for empty cells and review Chart Design > Select Data > Hidden and Empty Cells. The available empty-cell display choices depend on chart type.

When adding new data later, a chart based on an Excel table will generally expand as rows are added directly to that table. This is often easier to maintain than repeatedly editing a fixed range. To make a range a table, select the data and use Insert > Table, confirming that the table has headers if it does. Check the chart after changing the source: table expansion does not solve every layout or chart-type issue, and added columns may not be interpreted as intended.

Excel desktop, Mac, and web differences

The instructions here target Excel for Microsoft 365 on Windows. Excel for Mac also supports charts with multiple series and has corresponding chart design and data-selection controls, though tabs, dialog layouts, and some available options can differ by release. When selecting nonadjacent ranges with a mouse, Windows uses Ctrl-click and Mac uses Command-click; selecting a single contiguous table is usually simpler and less error-prone.

Excel for the web supports creating and editing many chart types, but its interface and some advanced formatting options can differ from the desktop application. If a particular chart type, combo-chart setting, or formatting control is not available in the browser, open the workbook in the desktop app. A chart created in the desktop version may still display in the web version, but check how it appears after editing or sharing the workbook.

Frequently Asked Questions

Can an Excel chart have more than two series?
Yes. A chart can contain multiple series, subject to practical limits of readability and chart type. Each series needs a name and a corresponding set of values; use the same category labels when the groups are being compared across the same positions.

How do I add a second data series to an existing chart?
Select the chart, choose Chart Design > Select Data > Add, then set the series name and values range. Include numeric cells in the values range, not the heading, and confirm that the category labels still match the new data.

Why does Excel show my months as separate series?
Excel may have interpreted rows and columns in the opposite direction. Select the chart and choose Chart Design > Switch Row/Column, then verify that the legend lists the groups and the horizontal axis lists the months.

Can each series have a different chart type?
Yes, for supported combinations. Select the chart and use Chart Design > Change Chart Type > Combo to assign chart types by series. A combo chart can also place a series on a secondary axis when that is appropriate.

How do I keep a chart updated when I add data?
Use a well-structured Excel table as the chart source and add new records directly to the table. After adding data, inspect the chart to confirm the new rows or columns are included and that the series and category labels remain correct.

Try it: the Percentage Formula Generator: percent of, percent change, increase and decrease, with the formula.

More in Charts & pivot tables

Sources: Function behaviour and menu paths: Microsoft Support documentation for Excel. Method & sources

Spotted an error in this guide? Let us know.