Filling Series
Excel Supports a wide variety of fill options. Go to Home Tab -> Editing Group -> Fill -> Series to display the series dialog box.
There three types of Fill Series in Excel: –
- Linear Series
- Growth Series
- Date Series
Table of Contents
Linear Series
Linear series is for the series that increases by adding the same value to each successive cell
Growth Series
Growth Series is a series that increases geometrically multiplying by a value.
Data Series
Select data and select the data interval from the Data Unit. Your choices are Day, Weekday, Month, and Year. The Data Unit is only enabled if the source cell contains a date.
Using Trend to generate a series
