Microsoft Office Tutorials and References
In Depth Information
Add and remove
CHART DATA
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
other properties.
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.
2
C HANGE THE D ATA A REA
If the chart is on the worksheet,
position it so it does not overlap
the data.
l Currently charted data.
1 Click your chart.
l The Chart tools become
available.
3
1
2
Click the Design tab.
3
Click Select Data in the Data
group.
The Select Data Source dialog
box appears.
l
4
Click and drag to select the data
you want to include in your chart
or type the cell range.
4
5
Click OK.
4
5
144
 
Search JabSto ::




Custom Search