Microsoft Office Tutorials and References
In Depth Information
Add and remove
If you want to include new data in your chart or
exclude data from your chart, you can use the Edit
Data Source dialog box to add and remove entire
columns or rows of information or change your data
series entirely without changing your chart’s type or
You can also add data to an existing data series. Use
the Edit Data Source dialog box’s Legend Entries
(Series) to select the cell addresses that define your
data series label and your data series. You can also
use the Legend Entry (Series) box to add or remove
a data series. Click Switch Row/Column if you need
to switch your column and row data.
If you update the data on which your chart is based,
you do not have to regenerate your chart. Excel
charts automatically update to reflect changes you
make to your data.
C HANGE THE D ATA A REA
If the chart is on the worksheet,
position it so it does not overlap
l Currently charted data.
1 Click your chart.
l The Chart tools become
Click the Design tab.
Click Select Data in the Data
The Select Data Source dialog
Click and drag to select the data
you want to include in your chart
or type the cell range.