Home » Blog » Add another line to a graph

Add another line to a graph

Hello everyone! Did you know…how to add another line to a graph in Microsoft Excel when the chart type is a Line Chart and each data series is in a spreadsheet column?

click to INTERACT

Choices Choices for add another line to a graph

There are a number of ways to do this.

Automatic source data

Possible the easiest one is to make your source data for the graph or chart an official table by selecting a cell in the data and pressing CONTROL + t. Make sure the data range given is the correct range and that “My table has headers” is ticked off. Then press enter.

Thereafter, if you enter another column of source data this will automatically add another data series or line to your graph.

With the mouse

Alternatively, you could click on the chart area in the chart and then drag on your existing source data at the bottom right corner with the mouse to extend your source data to include the entire new column.

Select Data

Another way might be to click on the Select Data command which you will find on the Chart Design ribbon in the Data group and add the new data series by clicking “Add” on the left (or series side) of the dialog box.  You would select the new series name and series values range by highlighting the appropriate source cells of the new column on the spreadsheet.

To add another line to a graph – last method for today

The last option you might think a little odd but it would be to select your new column of data including the column heading, copy this and then click the chart area on the chart and paste the data into the chart using CONTROL + v. It’s really just the regular type of link of a chart data series to the source spreadsheet data that you are creating here.  This method should work for you as well!

click to INTERACT

Leave a Reply

Your email address will not be published. Required fields are marked *