Tom’s Tutorials For Excel: Filling Series For Linear and Growth

Tom’s Tutorials For Excel: Filling Series For Linear and Growth
Here is an example of building a table of projected sales and income, using three Fill methods of Series, Linear, and Growth.

TIP:


First Example: Fill Series (add a year number to each filled cell)
• Enter the first year of your data, example 2010 in cell A4.
• Select cell A4 and drag its fill handle down while pressing the right mouse button.
• Release the right mouse button, and from the popup menu, select Fill Series.



Second Example: Series, Growth (project your Unit Sales to double every year)
• Enter your first item of data in the Unit Sales column, example 31 in cell B4.
• Select cell B4 and drag its fill handle down while pressing the right mouse button.
• Release the right mouse button, and from the popup menu, select Series.
• In the Series dialog box, select Growth (as Type).
• I entered 2 for Step value, projecting each year’s Unit Sales to double.
• Click OK.



Third Example: Series, Linear (add a specific static number to its previous number)
• Enter your first item of data in the Unit Price column, example $49 in cell C4.
• Select cell C4 and drag its fill handle down while pressing the right mouse button.
• Release the right mouse button, and from the popup menu, select Series.
• In the Series dialog box, select Linear (as Type).
• I entered 3 for Step value, because I expect to raise my Unit Price by $3 every year.
• Click OK.



Final Result !!

Share Button
Posted in Tom's Tutorials for Excel
Tags: , , , , , , , , , , , , ,
3 comments on “Tom’s Tutorials For Excel: Filling Series For Linear and Growth
  1. San says:

    Simply great. Great way of explaining.

  2. sandeep kothari says:

    Fantastic Three!

Leave a Reply

Your email address will not be published. Required fields are marked *

*