How to Make a Graph in Excel with Multiple Data Series

Charts & pivot tables · Updated November 18, 2026

To make a graph in Excel with multiple data series, arrange each series in its own column or row, include a label for every series, select the complete data range, then choose Insert > Recommended Charts and pick a chart that suits your data. You can adjust series, labels, and formatting afterward from the Chart Design and Format tabs. These steps are for Excel for Microsoft 365 on Windows.

What You’ll Need

  • An Excel workbook with the data you want to compare, arranged in a clear table.
  • A label for each series and, if applicable, a shared set of categories such as dates, products, or regions.
  • A general idea of what you want the graph to show: trends, comparisons, or the relationship between two measures.

You do not need to calculate anything special just to create a chart. If your source data is spread across separate parts of a worksheet, it is usually easier to copy it into one rectangular table first.

Step-by-Step

  1. Arrange the data in a table. Put category labels in the first column and each data series in a separate column. For example, a monthly sales table could have Month in column A, Store East in column B, and Store West in column C. Put the column headings in the first row and keep each row aligned: the February values must sit beside February, not January. Avoid blank rows or columns inside the table, since Excel may treat them as breaks in the chart data.

  2. Check the values and labels. Confirm that numbers are stored as numbers, not text, and that the series headings are short and descriptive. For a time-based chart, use real Excel dates in the category column rather than text that only looks like a date. If your data has units, such as dollars or units sold, note them so you can label the vertical axis clearly later.

  3. Select the full data range. Click the first heading cell, then drag to the last value in the table. Include the category labels and all series headings as well as the values. For a contiguous table, you can click a cell inside it and press Ctrl+A to select the current data region; check the selection before continuing, especially if nearby cells contain other information. On Mac, use Command+A. Selecting a single column by mistake will produce a chart with only one series.

  4. Insert a suitable chart. Choose Insert > Recommended Charts. Review the suggested options and select one that makes the comparison easy to understand, then click OK. You can also use the chart buttons in the Insert tab, such as Insert Column or Bar Chart, Insert Line or Area Chart, or Insert Scatter (X, Y) or Bubble Chart. Use a column chart to compare values across categories, a line chart to show change over time, and a scatter chart when both axes represent numeric measurements. Excel for Mac has chart choices on the Insert tab too, though the ribbon layout can vary slightly. In Excel for the web, use Insert > Chart and choose a chart type.

  5. Check that Excel plotted each series correctly. Click the chart and look for a separate colored line, set of bars, or legend entry for each series. If the categories appear as series, or the series appear along the horizontal axis, select the chart and choose Chart Design > Switch Row/Column. This is useful when your data is arranged in rows instead of columns. On Mac and Excel for the web, select the chart and look for Switch Row/Column on the Chart Design tab; if you do not see it, open Select Data and use its layout controls.

  6. Correct the source range if needed. Select the chart, then choose Chart Design > Select Data. In the Select Data Source window, check that the Chart data range includes all intended cells. The Legend Entries (Series) area lists the plotted series; select a series and choose Edit to change its name or values. The Horizontal (Category) Axis Labels area controls the labels along the bottom of many chart types. Use Select Data when one series is missing, a heading was treated as a value, or the wrong cells were included. The dialog’s appearance can differ slightly on Mac.

  7. Add a title and axis labels. With the chart selected, choose Chart Design > Add Chart Element. Select Chart Title and Axis Titles, then click each placeholder in the chart and type meaningful text. A useful title describes both the measure and comparison, such as Monthly Sales by Store. Axis titles should identify the measure and unit, for example Revenue (dollars). You can also use the Chart Elements button beside the chart when it is available. In Excel for Mac, use Chart Design > Add Chart Element; in the web version, select the chart and use its Chart or Chart Design options.

  8. Make the graph readable and save your work. Use Chart Design > Change Colors to choose a palette with distinguishable series. Click the legend to move it, or use Add Chart Element > Legend to choose its position. To change a series color, click that series, right-click, and choose Format Data Series. Keep gridlines light and remove decorative effects that compete with the data. Click outside the chart to finish, then save the workbook. A chart linked to worksheet data updates when you change those source values.

For a graph that should grow when new records are added, convert the source range into an Excel table first: select a cell in the data and choose Insert > Table, confirm that the table has headers, and click OK. Create the chart from the table. Charts based on tables can include newly added table rows, making this a practical choice for regularly updated reports. Check the chart after adding data to confirm the new rows are represented as intended.

Common Mistakes

  • Leaving out headings. If the selected range does not include the series names, Excel may use generic labels such as Series 1. Include the header row, or edit each name in Chart Design > Select Data.

  • Including totals in the plotted values. A total row or column can make the individual series look much smaller and distort comparisons. Leave totals out of the selection unless the total itself is a series you want to show.

  • Mixing unrelated units on one axis. A series in the thousands can flatten a series in decimals. Do not assume a secondary axis is automatically the best fix: it can make the chart harder to interpret. Consider separate charts, or use a combo chart with a secondary axis only when the two measures genuinely need different scales and both axes are clearly labeled.

  • Choosing a chart type that hides the message. A stacked chart emphasizes totals and composition, not straightforward comparisons between every series. A line chart may imply continuous change when categories are unrelated. Match the design to the question you want the graph to answer.

  • Using colors as the only distinction. Similar shades can be difficult to tell apart, particularly in print or for readers with color-vision differences. Use clear contrast and retain the legend, labels, or other visual cues.

Tips

  • Keep the table simple: one header row, one category column, and one column per series is a dependable layout for most charts.

  • Use consistent category labels and units across series. If one series is monthly revenue and another is monthly orders, say so in the title or axis labels rather than leaving readers to guess.

  • For a chart with many series, consider whether all of them need to appear together. A few focused charts can be easier to read than a single chart crowded with lines or colors.

  • To select separated ranges on Windows, hold Ctrl while selecting the additional cells; on Mac, hold Command. Nonadjacent selections can be fiddly, so placing the data in one table is often more reliable.

  • Use descriptive series names in the source table. A legend that says North, South, and West is more useful than one that says Series 1, Series 2, and Series 3.

Troubleshooting

The chart shows only one series: Recheck the selected range, then open Chart Design > Select Data. Add the missing series or correct the Chart data range. Make sure each series has values in the range and a heading in the header row.

The chart has the wrong labels or orientation: Try Chart Design > Switch Row/Column. If that does not fix it, open Select Data and set the category label range explicitly. Check for blank cells or an extra heading that may have shifted the selection.

Numbers are missing or shown as zero: Click a source cell and check whether the value is stored as text. Re-enter or convert it to a number, then confirm that the cell is not blank and that the series value range includes it. Also check whether a chart filter is hiding the series or categories; use the Chart Filters button beside the chart, when available, to restore them.

The chart is difficult to read: Try a different chart type from Chart Design > Change Chart Type, reduce the number of series, or adjust the axis scale through Format Axis. If the values have very different magnitudes, consider separate charts before using a secondary axis. Give each axis an explicit title if you do use one.

The graph does not update: Confirm that you edited cells included in the chart’s source range. Open Select Data to inspect that range. If you routinely append rows, use a chart based on an Excel table, then add the new records directly beneath the existing table.

Frequently Asked Questions

How many data series can I put in one Excel graph?
Excel can plot multiple series, but a chart becomes harder to interpret as lines, bars, or legend entries accumulate. There is no single ideal number; use only the series needed to make the comparison clear, and split a crowded chart when necessary.

Can I graph data that is in separate columns or ranges?
Yes. If the ranges are nonadjacent, select the first range and hold Ctrl on Windows or Command on Mac while selecting the others, then insert a chart. For more control, create the chart and use Chart Design > Select Data to add or edit series. Keeping the data together in a single table is generally less error-prone.

Should I put data series in rows or columns?
Either arrangement can work. Excel often treats columns as separate series and the first column as category labels, but the result depends on the selected range. Use Chart Design > Switch Row/Column to change how Excel interprets the rows and columns.

How do I show two series with very different values?
First consider separate charts or a chart type that makes the comparison meaningful. A combo chart can place one series on a secondary axis, but clearly label both axes because their scales differ. In Microsoft 365 for Windows, use Chart Design > Change Chart Type > Combo, then select Secondary Axis for the appropriate series if that option is available for the chosen combination.

Can I add another series after creating the graph?
Yes. Add the new data to the worksheet, select the chart, and open Chart Design > Select Data to edit the chart data range or add a series. If the source is an Excel table, adding a row to that table may extend the chart automatically; check the chart to verify.

Related

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.