O'Reilly logo

Microsoft® Office Excel 2003 Inside Out by Mark Dodge, Craig Stinson

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

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 ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required