Microsoft Office Tutorials and References
In Depth Information
Filling cells and creating data series
Dragging the ill handle with the right mouse button
When you use the right mouse button to ill a range or extend a series, a shortcut menu
appears when you release the button, as shown in Figure 8-26. This menu differs somewhat
from the Auto Fill Options menu and lets you specify what you want to happen in advance,
as opposed to the Auto Fill Options menu giving you the ability to change the action after
Figure 8-26 If you right-click and drag the ill handle, this shortcut menu appears when you
release the mouse button.
The box that appears on the screen adjacent to the pointer indicates what the last number
of this sequence would be if we dragged the ill handle as usual (with the left mouse
button)—in this case, 160. The Linear Trend command creates a simple linear series similar to
that which you can create by dragging the ill handle with the left mouse button. Growth
Trend creates a simple nonlinear growth series by using the selected cells to extrapolate
points along an exponential growth curve. In Figure 8-27, rows 4 through 6 in column A
contain a series created using Linear Trend, and the same rows in column C contain a series
created using Growth Trend, starting with the same values.
Figure 8-27 We created a linear trend series in column A and a growth trend series in column C.