Microsoft Office Tutorials and References
In Depth Information
l Excel redefines the
data series area.
A DD A L EGEND I TEM
Perform Steps 1 to 3
under Change the
l The Select Data Source
dialog box appears.
l The Edit Series dialog box appears.
Click the cell with the name you want for
your new data series or type the cell
Click and drag to select the data series or
type the range.
l Excel adds the data series and legend
name to your chart.
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
Chapter 6: Create Charts