Removing Data from a Chart
You can delete values from only a chart, leaving them in the related table, or you can
delete values from both a chart and its related table.
Here are ways to remove data:
To remove a data point from both a chart and the table where it appears, select the
m
cell in which the data resides, and then press Delete. The value is removed from the
table and the chart.
If you delete a column or row that is part of a two-column pair plotted in a scatter
chart, the related two-value data point is removed from the chart.
To remove multiple individual cell values from both a chart and the table where it
m
appears, select the table, hold down the Shift (for contiguous cells) or Command (for
noncontiguous cells) keys as you click to select the cells, and then press Delete. The
values are removed from both the table and the chart.
To shrink a contiguous range of cells comprising a chart, select the chart. In the table,
m
drag the circular control in the lower right of the range up or to the left. The cells
that are deselected are no longer represented in the chart, but the values remain in
the table.
To remove a data series from a chart, select the chart, and then select an element in
m
the series or click the series label in the table. Press Delete. The values are removed
from the chart but remain in the table.
To remove a data set, select the chart, and then select the category label in the table.
m
Press Delete. The values are removed from the chart but remain in the table.
If the category has no label in the table, click the data series button in the table to
convert the category to a series, select the series that contains the data you want to
remove, and press Delete.
142
Chapter 7
Creating Charts from Data
Chapter 7
Creating Charts from Data
143