You can delete data from a chart, including the corresponding data on the worksheet. Or, you can delete the data series without losing any data on the worksheet or datasheet.
Switch to the datasheet. If the datasheet is not visible, click View Datasheet to display it.
Do one of the following:
Delete data from a chart and worksheet
Select the information you want to delete.
Delete a data series from the chart without deleting the corresponding data from the worksheet or datasheet
Note If you want to put the data series back in the chart, double-click the row or column header again.