Page 42 - Excel Data Analysis

03 537547 Ch02.qxd 3/4/03 11:46 AM Page 28

EXCEL DATA ANALYSIS

ADD A SERIES TO A LIST

ou can quickly create a series in a list and avoid creates the remaining series. If the cell contains a numeric
repetitive entries by using the Fill Handle. A series is value — also known as a label — Excel simply repeats it in
Y simply a list of values that are either the same value the specified cells. If you provide a date, Excel increments
or are incremented by the same value. For example, you the date based on its format. For example, for a date that
can have a series of dates as either 1/1/2003, 2/1/2003, or contains a day, such as 2/14/2002, Excel increments the
January 1, 2003, February 1, 2003. A series of numbers can dates by one day. If the cell only contains the month, Excel
increment by adding, subtracting, multiplying, or even increments the dates by one month.
dividing by the same value. For example, 2, 4, 6, 8 is a list of Excel calls the black square at the bottom-right corner of
numbers that increment by adding 2 to each value. For the selected range of cells the Fill Handle. When you drag
more information on lists, see the section "Create a List."
this handle either down or to the right, Excel uses the values
Although Excel creates a series when you present it one in the originally selected cells to create the series in the
value, to ensure that your series properly increments, you expanded range of cells. As you drag across each cell, Excel
must provide both the first and second values in the series. displays the value that it will place in the cell.
Excel examines these values, assesses the pattern, and

ADD A SERIES TO A LIST

⁄ Type the first and second Note: See Chapter 1 for information ■ Excel highlights the cells to ‹ Click and drag the Fill
data values for the series. on selecting a range of cells. show they are selected. Handle to specify a range of
cells for the series.
¤ Select the cells in the
series, or multiple series.

28