Microsoft® Office Excel 2003 Inside Out

Removing Data

The simplest way to remove a data series from a chart is to select the series on the chart itself and press Delete. This method works even if you've refined the selection to a single point in the series; delete that point and the whole series is gone. If you want to work harder, you can choose Chart, Source Data, click the Series tab, select the series in question, and click Remove. What you don't want to do is try to delete the series by clearing or deleting the source data on the worksheet. Your chart will still reference the empty or nonexistent cells.

To delete points from either end of all the series in a chart, select the chart area or the plot area, and then drag the Fill handle at one of the corners of either the purple or ...