Page 43 - Excel Data Analysis

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

ORGANIZE WORKSHEET DATA 2

You may want to choose the amount to increment a series of data
values. To do so, click Edit ➪ Fill ➪ Series. In the Series dialog box
that displays, you can enter exactly how you want values to
increment, the type of increment, and even a stop value. For
example, if you have the date 5/15 in a cell, the Fill Handle
automatically increments by days, making the next value 5/16. If
you want to display dates that are 15 days apart, you simply type 15
in the Step Value field and click the Day option ( changes to )
in the Date Unit section. If you want dates that are exactly one
month apart, you click the Month option and type 1 in the Step
Value field. If you want all dates from May 15 to the end of the
year, you type 12/31 in the Stop value field.
When you use the Series dialog box with dates, you must select
the Date Unit options ( change to ) corresponding to the part
of the date you want to increment. In other words, if you want the
date to increase by one month, you click the Month option.

■ As you drag, Excel outlines ■ Excel displays the value ■ Excel creates the series in
the range of cells that will that it will place in last cell. the specified cells.
contain the series.
› Release the mouse
button.

29