Adding Data Points to an Existing Line Chart

This post will guide you how to add a single data point in an existing line char in excel. How do I add a single point to a graph that already has a line chart in Excel 2013/2016.

Assuming that you have a line chart in excel, and the product cost is on the y-axis, and the product is in the x-axis. And if you want to add a single data point appear on that line chart based on a number that you typed into a value into one cell in another column. You can refer to the below steps:

1# type one data point value in one cell in a new column, such as Cell  C2.

add data points1

2# Right click on the existing line chart, and click Select Data…from the drop-down list. And the “Select Data Source” window will appear.

add data points2


3# Click “Add” button in the Legend Entries section.

add data points2-1

4# enter one Series name in the Series name text box, such as: single data point, then choose the whole column including that single data point value (Cell C2). Click OK button.

add data points3

5# you will see that the specified data point has been added on the existing line chart.

add data points4


Related Posts

Check Cell If Contains One of Many with Exclusions

In Microsoft Excel Spreadsheet or google sheets, when cells contain multiple strings, how can we accomplish this task if you want to check whether these cells contain more than one given string and exclude other given strings? In this article, ...

If Cell Contain Specific Text

This article will explain how to check if a cell contains text or a specific text string in Google Sheets or Microsoft Excel spreadsheets. In our daily work, we often look for specific text in worksheets containing large amounts of ...

Cell Contains Number

This article will talk about how to check if a given cell contains any numbers in Microsoft Excel Spreadsheet or Google Sheets. How to quickly check if a cell contains a number? When you have a small number of cells ...

Categorize Text With Keywords

If you are looking for the simplest approach to categorize the text with keywords, then look no further because you have just landed on the right blog post where you will get to know a formula and its usage to ...

Cash Denomination Calculator

Every country has different cash denominations, so you may need to calculate the number of different denominations based on the total amount. If it is just a small amount of cash, then you can calculate the different cash denominations manually, ...