Microsoft Office Development and Consultancy
 Home|

Excel

|VBA|C#|Finance|Tools|Newsletter|Feedback|Contact 
 Excel > AutoFill > Linear and Growth Trends< Previous | Next > 

 

Linear Trends

 
 

In a linear series each cell differs from the previous cell by a fixed amount.

 
 

Adds the "step" value to the starting value and each cell in turn

 

   
 

Linear - Creates a linear series or linear best-fit trend. This is selected by default. If the Trend box is cleared, a linear series is calculated by adding the value in the Step value box to each cell value in turn. If the Trend box is selected, the value in the Step value box is ignored, and a linear trend is calculated based on the selected values. The selected original values are replaced with values that fit the trend. This is covered in more detail on a subsequent page.

 
 

Trend - Calculates a best-fit line using the values that appear at the top or to the left of the selection. Any value in the Step value box is ignored if the Trend check box is selected. Excel will calculate the average change between the values already entered and uses that information to calculate a series to populate the remaining cells.

 

   


 

Growth Trends

 
 

Multiplies the starting value by each value in turn by the step value

 
 

Each cell is multiplied by the "step" value.

 
   
 

Growth - Creates a growth series or geometric growth trend. If the Trend box is cleared, a series is calculated by multiplying the value in the Step value box by each cell value in turn. If the Trend box is selected, the value in the Step value box is ignored, and a geometric growth trend is calculated based on the selected values. This is covered in more detail on a subsequent page.

 
 

Trend - Calculates a geometric growth trend using the values that appear at the top or to the left of the selection. Any value in the Step value box is ignored if the Trend check box is selected. Excel will calculate the average change between the values already entered and uses that information to calculate a series to populate the remaining cells.

 

   


 

Things to Remember

 


 © Better Solutions Limited 10-May-2013< Previous | Top | Next >