Add a Data Series to Chart – Excel & Google Sheets

This tutorial will demonstrate how to add series to graphs in Excel & Google Sheets.

Adding Series to a Graph in Excel

Starting with your Data

We’ll start with the below data that shows Item A Revenue by Year. In this tutorial, we’ll show how to add new series to an existing graph.

Starting with Data to Add Additional Series in Excel

 

Adding Data

In this example, we’ll add another dataset to add to the graph.

Additional Data in New Table in Excel

 

  1. Right click Graph
  2. Click Select Data

Select Data to Add Additional Series to Graph Excel

 

3. Select Add under Legend Entries (Series)

Add New Series to Chart and Graph in Excel

 

4. Update Series Name with New Series Header

5. Update Series Values with New Series Values

Add Header and Values to New Series in Excel

 

Final Graph with Additional Series

Below you can see the final graph with the additional series.

Final Graph with Additional Series in Graph Excel

 

Adding Series to a Graph in Google Sheets

Starting with your Data

Below, we’ll use the same data used above.

Starting with Data to Add Additional Series in Google Sheets

 

Add a Data Series

  1. Add the additional series to the table
  2. Right click on graph
  3. Select Data Range

Add Data Series Range to Chart in Google Sheets

 

4. Select Add Series

5. Click box to Select a Data Range

Select Data Range to Add Additional Series in Google Sheets

 

6. Highlight the new Series Dataset and click OK.

Select Data Range to Add Additional Series to Graph Google Sheets

Format Graph

  1. Select Setup under Chart editor
  2. Click on box under Chart Type
  3. Change to Bar Graph

Change Combo Chart to Bar Chart in Google Sheets

 

Final Graph with Additional Series

The below graph shows the additional data series.

Final Graph with Additional Series in Google Sheets