In the Step value box, enter the value that you want to increase the series by. To fill the series across the worksheet, click Rows. To fill the series down the worksheet, click Columns. On the Home tab, in the Editing group, click Fill, and then click Series. If you want to save the original values, copy them to a different row or column, and then create the series by selecting the copied values. When you click the Series command, the resulting series replaces the original selected values. The cell must contain the first value in the series. Select the cell where you want to start the series. To fill in the values manually, do the following: The series that is created is equivalent to the values that are returned by the TREND function or GROWTH function. In either case, the step value is ignored. In a growth series, the starting values are applied to the exponential curve algorithm (y=b*m^x) to generate the series. In a linear series, the starting values are applied to the least-squares algorithm (y=mx+b) to generate the series. When you click the Series command, you can manually control how a linear trend or growth trend is created and then use the keyboard to fill in the values.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |