Microsoft Office Tutorials and References
In Depth Information
l Excel redefines the
data series area.
A DD A L EGEND I TEM
1
Perform Steps 1 to 3
under Change the
Data Area.
l The Select Data Source
dialog box appears.
2
2
Click Add.
l The Edit Series dialog box appears.
3
Click the cell with the name you want for
your new data series or type the cell
address.
4
Click and drag to select the data series or
type the range.
3
4
5
Click OK.
l Excel adds the data series and legend
name to your chart.
3
4
5
Delete It!
To delete data from your chart, click the data you
want to delete in the Legend Series box of the
Select Data Source dialog box and then click
Remove. Or, click the legend item on the chart
and then press the Delete key.
Did You Know?
Here is a quick way to add data to a chart. Click
and drag to select the data you want to include
in the chart. Click the Copy button on the Home
tab. Click the chart to select it and click Paste
on the Home tab. The chart reflects the added
data series.
Chapter 6: Create Charts
145
 
Search JabSto ::




Custom Search