Microsoft Office Tutorials and References
In Depth Information
Choosing a Data Source
In the second step of the Chart Wizard, shown in Figure 4-7, you specify the data source
for the chart, indicating the cell range that contains the chart’s data. Excel organizes the
data source into a collection of data series , where each data series is a range of data val-
ues that is plotted as a unit on the chart. In the case of this column chart, each data series
contains the sales values of each sales region. A data series consists of data values , which
are plotted on the chart’s vertical axis, or y-axis . On the horizontal axis, or x-axis , are the
data series’ category values , or x values . In this chart, the data values are the sales values
and the category values are the names of the different telescope models.
Specifying the data source
co lor represents
data values are
plotted on the
category values are
plotted on the
cell reference of
the data source
different data series
In this case, the Chart Wizard has organized the data source by columns, so that the left-
most column contains the category values and the subsequent columns each contain a dif-
ferent data series. The first row of the data contains the labels that identify each data series.
In general, if the data spans more rows than columns, then the Chart Wizard interprets the
data series by columns; otherwise, the Chart Wizard interprets the data series by rows.
In Alicia’s sketch, she has indicated that she wants the name of the region to be the
category value, which means that each telescope model represents a different data series.
Therefore, you need to ensure that the Chart Wizard organizes the data source by rows
and not columns. The first row will contain the category values, and each subsequent row
will contain a data series. The first column will then contain the labels of each series.