Microsoft Excel is a great tool to make illustrative and beautiful charts as it provides many built-in chart styles. However, sometimes we may need to remove a specific data point from an existing Excel chart. In this article, we will discuss how to remove one data point from an excel chart.
Download Practice Workbook
Download this practice workbook to exercise while you are reading this article.
3 Useful Methods to Remove One Data Point From Excel Chart
In this section, we will demonstrate 3 effective methods to remove one data point from an excel chart. For illustration, I have taken a chart and its associated data set.
In this line chart, I have some hypothetical selling data for an imaginary shop for the first 10 months of a year( From January to October). Now, we want to remove one data point from the chart (such as June). Let’s look at the first method to achieve this goal.
1. Use of Filter to Remove One Data Point
This method is applicable when you have already created an excel chart that includes all data points. Now to remove one data point, follow the steps below.
Steps:
- First, bring your mouse pointer onto the chart and left-click on it. Consequently, you will see a menu bar on the right side of the chart. Now, from the menu, left-click on the Chart Filters option.
- Eventually, you will see another menu appearing on the right side that contains Categories(Month’s Name).
- Now from that list, deselect the month’s name whose corresponding data you want to remove from the Excel chart. Here, I have deselected Jun and then click on Apply.
- As a result, even though my data set contains the data point of June, it has been excluded from the graph. If you carefully look at the graph now, you should notice that between May and July, the June month’s data is no longer appearing on the chart.
Read More: How to Exclude Data Points from Trendline in Excel
2. Delete Data to Remove from Excel Chart
Deleting data is not usually encouraged especially in the scientific community but if you have no problem deleting the data which you want to remove from the Excel chart then this method is for you. To know more, follow the steps below.
Steps:
- Here, we can see that the charts have already been made and it contains all of the data points from the left data table. From here, we want to exclude Jun’s data point.
- To do that, first, select the row containing Jun on the table and right-click on the mouse. Consequently, a menu will appear.
- Now, from the menu, click on Delete.
- Consequently, another dialogue box will appear. Now, from the options, select Shift cells up and click OK.
- As a result, you will see that the data point of June has been removed not only from the data table but also from the chart as well.
Read More: How to Edit Chart Data in Excel (5 Suitable Examples)
Similar Readings
- How to Create Graph from List of Dates in Excel (with Easy Steps)
- Combine Daily and Monthly Data in Excel Chart
- How to Link Excel Data to PowerPoint Chart (3 Simple Methods)
- Create Org Chart From Excel Data (With Easy Steps)
- How to Change Data Source in Excel Chart (3 Useful Examples)
3. Selection of Only Data Points That Are to Be Included
You can apply this method if you have not made the Excel chart yet. To construct an excel chart that will contain all the data points in a table except one, follow the steps below.
Steps:
- Similar to the previous two examples, we will make the excel chart without the month of June. To do that, first, select the data on the upper rows from June( January to May). Then, by holding the Ctrl key, select the lower rows from June (July to October).
- Now, go to the Insert tab from the ribbon.
- From there, select any chart style you like. I have chosen the 2D line chart.
- Consequently, you will have an Excel chart without the removed/unselected data point (June).
- Now, you can always add the Chart Title, Axis Title, and so on for further beautification.
Read More: How to Select Data for a Chart in Excel (2 Ways)
Things to Remember
- Use the 1st and 2nd methods if your graph already exists.
- Use 2nd method when you are good to delete the unnecessary data point
Conclusion
That is the end of this article. If you find this article helpful in understanding how to remove one data point from an excel chart, please share this with your friends. Moreover, do let us know if you have any further queries. Finally, please visit Exeldemy for more exciting articles on Excel.
Related Articles
- How to Show Only Dates with Data in Excel Chart
- How to Sort Data in Excel Chart (5 Easy Methods)
- Selecting Data in Different Columns for an Excel Chart
- How to Format Data Series in Excel (with Easy Steps)
- How to Expand Chart Data Range in Excel (5 Suitable Methods)
- Excel VBA: Get Source Data Range from a Chart (with Quick Steps)