How to Add Data Points to an Existing Graph in Excel (3 Ways)

Get FREE Advanced Excel Exercises with Solutions!

Excel has a powerful graphing feature that can add visual depth and clarity to even the most mundane of datasets. Though Excel does most of the heavy lifting, you may wish to edit some aspects of your chart. For instance, you may need to add data points to an existing chart. Hence, in this article, we’ll demonstrate 3 ways how to add data points to an existing graph in Excel. In addition, we’ll also discuss how to get data points from an Excel chart.


How to Add Data Points to an Existing Graph in Excel: 3 Quick Ways

First and foremost, let’s assume the Population Growth of USA dataset shown in the B4:C12 cells which contain the Year and the Population in Millions respectively.

how to add data points to an existing graph in excel

Using the above dataset, you’ll get the following Excel graph.

Scatter plot

Now, let’s see the process of adding data points to the existing graph in detail and with the necessary illustrations. Here, we have used the Microsoft Excel 365 version, you may use any other version according to your convenience.


Method 1: Inserting a Single Data Point

First of all, let’s start with a simple example of adding a single data point to an existing graph in Excel. Here, we want to insert a Scatter Plot, therefore, just follow the steps shown below.

📌 Steps:

  • First, select the C5:C12 cells >> go to the Insert tab >> choose the Scatter option.

Inserting a Single Data Point

  • Next, select the chart >> press the Select Data option.

Clicking Select Data

Now, this opens the Select Data Source window.

  • Second, click the Edit button.

Editing Series values

  • Then, enter the Series name, here it is the “Population Growth of USA”.
  • In turn, select the Series X and Y values that correspond to the B4:B12 and C4:C12 ranges respectively.

Entering x and y axis values

  • Third, we’ll add the predicted “Population of 372 million” for the “Year 2030” as highlighted in the image below.

adding data points to an existing graph in excel

  • From this point, select the chart >> drag the Resizing Handle to add this new data point.

Drag the resizing tool

Afterward, we can format the chart using the Chart Elements option.

  • In addition to the default selection, enable the Axes Title to provide axes names. Here, it is the “Year” and “Population in Millions”.
  • Now, add the Chart Title, for example, “Population Growth of USA”.
  • Lastly, you can disable the Gridlines option to give your chart a clean look.

Formatting chart

Eventually, this should generate the chart as shown in the figure below.

how to add data points to an existing graph in excel adding single data point

Read More: How to Expand Chart Data Range in Excel


Method 2: Using Resizing Handles

Now, I know what you’re thinking. Is there a quicker way? Lucky you! Assuming you’re in a hurry, our next method provides the answer to adding a new data series to an existing Line Graph.
Suppose we have the Breakdown of Marketing Expense and Revenue dataset shown in the B4:D13 cells below, which depicts the Month number, the Marketing Expense, and the Revenue in USD respectively. Hence, let’s see it in action.

Dataset for Using Resizing Handles

📌 Steps:

  • Initially, choose the C5:C13 cells >> navigate to the Insert tab >> select the Lines with Markers option.

Inserting Line chart with markers

  • Then, click to select the chart >> drag the Resizing Handles to add the x-axis values.

Utilizing resizing handle to add x axis labels

  • In a similar style, again drag the Resizing Handles to add a new series, in this case, “Revenue” to the graph.

adding data points to an existing graph in excel

Now, apply formatting to the chart with the Chart Elements option.

  • First, check the Axes Title to name the axes. Here, it is “Month” and “US Dollar”.
  • Second, add the Chart Title, for instance, “Breakdown of Marketing Expense and Revenue”.
  • Third, insert the Legend option to show the “Marketing Expense” and “Revenue” series.
  • Lastly, uncheck the Gridlines option to give your chart a clean look.

Formatting with chart elements option

Finally, the output should look like the plot shown in the screenshot below.

how to add data points to an existing graph in excel with resizing handle

Read More: How to Add Data to an Existing Chart in Excel


Method 3: Utilizing Select Data Option

Alternatively, we can also employ the select data option to add data points to an existing graph in Excel. In this situation, let’s consider the data for Stock Price of Companies in the B4:D13 cells, which display the Company name and the 2020 and 2021 Stock Prices respectively.

Dataset for Utilizing Select Data Option

📌 Steps:

  • To begin with, select the C5:C13 cells >> jump to the Insert tab >> click the Insert Column or Bar Chart option.

Inserting Bar chart

  • Later, select the chart >> hit the Select Data option.

  • Next, press the Edit button to add the x-axis labels.

Inserting x axis labels

  • Now, highlight the B5:B13 cells as the Axis label range >> click OK.

Selecting x axis labels

  • Following this, click the Edit button to enter a name for the data series.

how to add data points to an existing graph in excel clicking the edit button

  • Likewise, choose the C4 cell (“Stock Price in 2020”) as the Series name >> hit the OK button.

Entering Series Name

  • Afterward, select the Add option to add the data points for a new series.

how to add data points to an existing graph in excel using the add button

  • In turn, select the D4 cell (“Stock Price in 2021”) for the Series name >> choose the D5:D13 cells as Series Values.

how to add data points to an existing graph in excel with the select data tool

Finally, apply the formatting to the chart as shown in the previous method to obtain the output shown in the image below.

how to add data points to an existing graph in excel using select data option

Read More: Selecting Data in Different Columns for an Excel Chart


How to Get Data Points from a Graph in Excel

Last but not least, sometimes we may want to get the data points from a graph; in that case,  apply the VBA Code below. It’s simple and easy, just follow along.

📌 Steps:

  • First of all, select the chart >> navigate to the Developer tab >> click the Visual Basic button.

How to Get Data Points from a Graph in Excel

Eventually, the Visual Basic Editor window pops out.

  • Second, go to the Insert tab >> select Module.

Inserting Module

For your ease of reference, you can copy the code from here and paste it into the window as shown below.

Sub Extract_Chart_Data()

    Dim x_axis_num As Integer
    Dim x_axis_series As Object
    
    On Error Resume Next
    x_axis_count = 2
    x_axis_num = UBound(Application.ActiveChart.SeriesCollection(1).Values)
    Application.Worksheets("Get_Chart_Data").Cells(1, 1) = "X Values"
    
    With Application.Worksheets("Get_Chart_Data")
        .Range(.Cells(2, 1), _
        .Cells(x_axis_num + 1, 1)) = _
        Application.Transpose(ActiveChart.SeriesCollection(1).XValues)
    End With
    
    For Each x_axis_series In Application.ActiveChart.SeriesCollection
        Application.Worksheets("Get_Chart_Data").Cells(1, x_axis_count) = x_axis_series.Name
        With Application.Worksheets("Get_Chart_Data")
            .Range(.Cells(2, x_axis_count), _
            .Cells(x_axis_num + 1, x_axis_count)) = _
            Application.WorksheetFunction.Transpose(x_axis_series.Values)
        End With
        x_axis_count = x_axis_count + 1
    Next
    
End Sub

Pasted VBA code

Code Breakdown:

Here, we’ll explain the VBA code to get data points from a chart.

  • In the first portion, the sub-routine is given a name, here it is Extract_Chart_Data().
  • Next, define the variables x_axis_num and x_axis_series as Integer and Object data types respectively.
  • In the second potion, set the x_axis_count to  2 and apply the UBound function to get the largest value.
  • In addition, use the Worksheet object to define the worksheet name, here it is “Get_Chart_Data” and return the x-axis values into this worksheet.
  • Then, utilize the With statement to loop through all the x-axis values and return the values in the specified worksheet.
  • In the third portion, combine the For Loop and the With statement to iterate through and extract the y-axis values and the series names.
  • Lastly, return them to the adjacent cells.

VBA code explanation

  • Third, click the Run button or press the F5 key to run the VBA code.

Running VBA code

Subsequently, the final results appear in the “Get_Chart_Data” worksheet as shown in the picture below.

how to get data points from an existing graph in excel


💡 Things to Remember

Furthermore, let’s discuss an important issue when using the VBA Code to extract data points from an Excel chart.

  • Specifically, make sure to select a chart and then run the VBA code, otherwise, the program returns only the string of text “X Values”.

Things to remember

  • Additionally, make sure to rename your worksheet to “Get_Chart_Data” or edit the VBA code to enter a worksheet name according to your preference.

Renaming worksheet


Practice Section

We have provided a Practice section on the right side of each sheet so you can practice yourself. Please make sure to do it by yourself.

Practice Section for how to add data points to an existing graph in excel


Download Practice Workbook


Conclusion

To sum up, we hope this tutorial has provided you with helpful knowledge on how to add data points to an existing graph in Excel. Now, we recommend you apply all this know-how in the practice dataset by downloading the practice workbook. In addition, feel free to comment and provide your valuable feedback.


Related Articles


<< Go Back to Edit Chart Data | Excel Chart DataExcel Charts | Learn Excel

What is ExcelDemy?

ExcelDemy - Learn Excel & Get Excel Solutions Center provides online Excel training , Excel consultancy services , free Excel tutorials, free support , and free Excel Templates for Excel professionals and businesses. Feel free to contact us with your Excel problems.
Eshrak Kader
Eshrak Kader

Eshrak Kader is a dedicated professional with a BSc. Degree in Naval Architecture and Marine Engineering from Bangladesh University of Engineering and Technology. He boasts a rich background in Microsoft Office Suite, and over the past year, he has authored over 120 insightful articles for the ExcelDemy. Currently, Eshrak leads a team of 5 in the ExcelDemy Video project and enjoys problem-solving and making videos on Excel. Eshrak’s passion for continuous learning underscores his commitment to excellence in... Read Full Bio

We will be happy to hear your thoughts

Leave a reply

Advanced Excel Exercises with Solutions PDF

 

 

ExcelDemy
Logo