TipsTIP: The dollar signs in the Chart data range field indicate that the field uses.4. The data displayed in the chart is shown in the Chart data range field. Alternately, click Select Data from the Data section of the Office Ribbon in the Chart Tools Design tab.The Select Data Source dialog opens. Make sure to add a label to the first row of the new column so the chart can display a label for the new plot line.Click on the chart that displays the original data to select it.Right-click on the chart and choose Select Data. Don't worry if it's not right the first time, since you can change it later if you need to.Excel creates a new chart that displays a separate plot line for each column of data.Add a Line to an Existing ChartIf you already have a line chart, you may add a new plot line to it by editing the Data Source for the chart.Enter or copy and paste the data for the new plot line into the column immediately to the right of the original data. If you're unsure what type of line chart to create, select either Line or Line with Markers. TipsThere are multiple types of line charts used for different purposes. Select all the cells in each column that contain your data.
How put label scatter chart in excel series#
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. 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 put label scatter chart in excel how to#
0 kommentar(er)
