Download Excel Start File: https://people.highline.edu/mgirvin/Y...
Download Excel Finished File: https://people.highline.edu/mgirvin/Y...
See how to use the OFFSET function for two different types of dynamic ranges for a chart:
1)Dynamic Range that adds latest records
2)Dynamic Range that shows only last 4 Months of data
Learn about named formulas that use OFFSET function to create dynamic ranges and see how to insert named ranges into a chart. Learn about the OFFSETs 5 arguments:
1)Starting point
2)How many rows (up or down) do you want to move the starting point?
3)How many columns (left or right) do you want to move the starting point?
4)How tall is the range?
5)How wide is the range?