Add Data Points to Existing Chart – Excel & Google Sheets

This tutorial will demonstrate how to add a Single Data Point to  Graph in Excel & Google Sheets

Add a Single Data Point in Graph in Excel

Creating your Graph

  1. Select Data
  2. Click Insert
  3. Click Line Chart
  4. Select Line Chart with Markers

Create Line Graph with Markers Excel

 

Adding Single Data point

  1. Add Single Data Point you would like to ad
  2. Right click on Line
  3. Click Select Data

Select Data to Add Additional Data Point in Excel

 

4. Select Add

Add Series to Add Single Data Point in Excel

 

5. Update Series Name with New Series Header

6. Update Values

Select Single Data Point Series in Excel

 

Final Graph with Single Data point

Final Graph to add Single Data Point to Chart in Excel

 

Add a Single Data Point in Graph in Google Sheets

 

Start with your Graph

Similar to Excel, create a line graph based on the first two columns (Months & Items Sold)

Add Single Data Point for Line Graph in Google Sheets

 

  1. Right click on graph
  2. Select Data Range

Select Data Range for Single Data Point in Google Sheets

 

3. Select Add Series

4. Click box for Select a Data Range

Add Single Data Point Series for Line Graph in Google sheets

5. Highlight new column and click OK.

 

Add Series for Single Data Point in Google Sheets

 

Final Graph with Single Data Point

Final Graph for Single Data Point in Google Sheets