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.
How to Remove One Data Point From Excel Chart: 3 Useful Methods
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.
- 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 clicked 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 Skip Data Points in an Excel Graph
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.
- 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
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.
- 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 Limit Data Range in Excel Chart
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
Download Practice Workbook
Download this practice workbook to exercise while you are reading this article.
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.
- How to Change Chart Data Range in Excel
- How to Edit Data Table in Excel Chart
- How to Change Data Source in Excel Chart
- How to Change X-Axis Values in Excel
- How to Change Chart Data Range Automatically in Excel
- How to Sort Data in Excel Chart
- How to Group Data in Excel Chart
- How to Hide Chart Data in Excel
- How to Ignore Blank Cells with Formulas in Excel Chart