• Create BookmarkCreate Bookmark
  • Create Note or TagCreate Note or Tag
  • PrintPrint

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 blue bounding rectangle that surrounds your data. To remove points from a particular series, select that series, and then drag the blue Fill handle. If the Fill handle isn't visible, you can always choose Chart, Source Data and make your changes there.


PREVIEW

                                                                          

Not a subscriber?

Start A Free Trial


  
  • Creative Edge
  • Create BookmarkCreate Bookmark
  • Create Note or TagCreate Note or Tag
  • PrintPrint