Microsoft Office Tutorials and References
In Depth Information
Selecting a Data Source
Selecting a Data Source
Each chart has a data source. After you select a range to use as the chart’s data source,
Excel uses the fi rst row of the selected range as the series name, the fi rst column as the
category values, and the remaining columns as the series values. If the data source is
organized in rows rather than in columns, the fi rst row contains the category values, the
remaining rows contain the data values for each data series, and the fi rst column of each
series row contains the series names.
The fi rst chart you will create is based on data in the Assets worksheet that indicates
how the New Century Fund’s holdings are divided among different investment
categories. The data source you will select has only one data series that shows the assets for fi ve
investment categories.
To select the data source for the assets chart:
1. Click the Assets sheet tab to make the Assets worksheet active.
2. Select the range A3:B8 . The data source in this range has one data series, named
Assets. Its category values in the range A4:A8 list the different asset
categories, and its series values in the range B4:B8 contain the data to be charted. See
Figure 4-1.
Figure 4-1
Data source selected for the assets chart
series name
series values
series categories
Selecting a Chart Type
You can apply a wide variety of chart types to the selected data source. Excel supports
73 built-in charts organized into 11 categories, which are described in Figure 4-2. You
can also create custom chart types based on the built-in charts.
Search JabSto ::




Custom Search