Adding and Deleting a Data Series

Many components make up a chart. Each range of data that comprises a bar, column, or pie slice is called a data series ; each value in a data series is called a data point . The data series is defined when you select a range on a worksheet and then open the Chart Wizard. But what if you want to add a data series once a chart is complete? Using Excel, you can add a data series by using the mouse, the Chart menu, or the Chart Wizard. As you create and modify more charts , you might also find it necessary to delete or change the order of one or more data series. You can delete a data series without re-creating the chart.

Add a Data Series Quickly

graphics/one_icon.jpg

Select the range that contains the data series you want to add to your chart.

graphics/tow_icon.jpg

Drag the range into the existing chart.

graphics/three_icon.jpg

Release the mouse button to display the chart with the added data series.

graphics/09inf18.jpg

Delete a Data Series

graphics/one_icon.jpg

Select the chart that contains the data series you want to delete.

graphics/tow_icon.jpg Click any data point in the data series to select the series in the chart and the worksheet.

To delete one data point but keep the rest of the series in the chart, click the data point twice.

graphics/three_icon.jpg

Press Delete.

graphics/09inf19.jpg

Change a Data Series

graphics/one_icon.jpg

Select the chart that contains the data series you want to change.

graphics/tow_icon.jpg

Click the Chart menu, and then click Source Data.

graphics/three_icon.jpg

Click the Series tab.

graphics/foure_icon.jpg

Click the series name you want to change.

graphics/five_icon.jpg

Click the Name or Values Collapse Dialog button to change the name or value, make the change, and then click the Expand Dialog button.

graphics/six_icon.jpg

Click OK.

graphics/09inf20.jpg

Change Data Series Order

graphics/one_icon.jpg

Select the chart and the data series you want to change.

graphics/tow_icon.jpg

Click the Format menu, and then click Selected Data Series.

graphics/three_icon.jpg

Click the Series Order tab.

graphics/foure_icon.jpg

Click the series you want to reorder.

graphics/five_icon.jpg

Click Move Up or Move Down.

graphics/six_icon.jpg

Click OK.

graphics/09inf21.jpg

Did You Know?

You can add a trendline . A trendline helps you analyze problems of prediction. Select the chart to which you want to add a trendline, click the Chart menu, click Add Trendline, select a trend type, select a series, and then click OK.



Show Me Microsoft Office Excel 2003
Show Me Microsoft Office Excel 2003
ISBN: 0789730057
EAN: 2147483647
Year: 2002
Pages: 291

flylib.com © 2008-2017.
If you may any questions please contact us: flylib@qtcs.net