Microsoft Office Tutorials and References
In Depth Information
Select Data
Select Data
The Select Data button does a few things, most importantly giving you the chance to change the range of
the data in your chart. First click your chart, then click the Select Data button, and you’ll see the Select
Data Source dialog box onscreen (Figure 5-32):
Figure 5–32. The Select Data Source dialog box
If you click in the Chart data range field, you can enter different range coordinates, if you’ve
decided you want the chart to use different data. This command may be particularly relevant if you’ve
selected a chart range and accidently left out a row you wanted to include in the chart. You could thus
replace:
=Sheet1!$C$9:$H$19
with:
=Sheet1!$C$9:$H$20
(Sheet1 refers to the name of the sheet on which the chart data is contained, implying that a chart can be
posted to one sheet even as its data appear on another one. More on multiple sheets in Chapter 7). As
you see, Select Data also lets you execute the Switch Row/Column command, as well as delete a data
series from the chart. If I click on Alice in the above screen shot and click the Remove button, all the
columns representing Alice’s test scores will disappear from the chart (but not from the source data).
The up and down arrows in the Legend Entries (Series) area can reposition a data series (Figure 5-33):
 
Search JabSto ::




Custom Search