Select all the cells in each column that contain your data. The data for each series is in a separate column, and the label to display on the chart for each is in the first row of each column.1. Since each data series (the data for each separate line to be plotted) must be in a separate column, you must enter the labels for each data series in a separate column on the first row.Įxcel uses the labels in the first row of each column to label the lines in the chart for the data in that column.Enter your data into each of your columns, in the rows below the labels.Here's an example worksheet showing two data series.
![how to make an x y scatter chart in excel 2010 how to make an x y scatter chart in excel 2010](https://i.stack.imgur.com/QBMYX.png)
In the first row of the worksheet, enter the labels for each of the data series to plot. But when you include two or more columns of data, Excel treats each column as a separate data series and automatically creates separate lines on the chart for the data in each column.Enter Your DataIf you already have a spreadsheet with data entered into columns, skip to the next step ( Create Your Chart, below). When you create a line chart using one column of data Excel adds only one plot line to the chart.
![how to make an x y scatter chart in excel 2010 how to make an x y scatter chart in excel 2010](https://www.dummies.com/wp-content/uploads/430344.image1.jpg)
#HOW TO MAKE AN X Y SCATTER CHART IN EXCEL 2010 HOW TO#
How To Add Lines In Scatter Plot Excel FreeĬreate a New Chart With Multiple LinesWhen you create a new chart in Excel, you must specify the data to be plotted (for more information please see ).How To Make A Scatter Plot In Excel 2016.Now select the chart and open the 'Chnage Chart Type' options from Design Tab. Select the entire table and insert a line chart with markers. Now enter a value “100” for Jan in “Ver Line” column. Enter a new column beside your quantity column and name it “Ver Line”.