how to plot a graph in excel with multiple series

Select Series Data: If I somehow have a chart that uses only part of the data, I can right click on the chart and choose Select Data, or I can click Select Data on the ribbon, and the Select Data Source dialog pops up. The first column (if series are plotted by column) is used for X values, the rest of the columns become the Y values, and the first row is used for series names.

If I have a single block of data, I can select the block of data, or just a single cell within it, and Excel will build a chart using all of the data. This is a trivial case, and probably not what people are asking about. Displaying Multiple Series in One Excel Chart Displaying Multiple Series in an XY Scatter Chart Single Block of Data

I’ll show how to add series to XY scatter charts first, then how to add data to line and other chart types the process is similar but the effects are different. I’m going to show a couple ways to handle this.

A common question in online forums is “How can I show multiple series in one Excel chart?” It’s really not too hard to do, but for someone unfamiliar with charts in Excel, it isn’t totally obvious.

How to plot a graph in excel with multiple series