Excel Video 470 is an easy video with three ways to delete data from a chart. Before we get to the three tips, please note that Excel 2013 makes it so easy to filter data from a chart that I only delete chart data that I never ever plan to chart again. Another tip is to remove the data from the chart before you remove the data from the spreadsheet. I’ve seen spreadsheet errors persist when you delete the data from the spreadsheet before removing the data from the chart.
The three ways to delete chart data are to select the chart series and click delete, to click inside the chart and drag the chart’s data range, and to use the select data window. Each of these options makes it easy to delete chart data. You don’t need to remember all three options, just choose the delete option that works best for you.