Microsoft Office Tutorials and References

In Depth Information

**Session 4.1**

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

Figure 4-7

each column

co
lor represents

a different

data series

data values are

plotted on the

vertical axis

category values are

plotted on the

horizontal axis

cell reference of

the data source

each column

represents a

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.