Main Profile

At A Glance

Excel Dynamic Chart #10: OFFSET Function Dynamic Range

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?
Length: 14:49

Contact

Questions about Excel Dynamic Chart #10: OFFSET Function Dynamic Range

Want more info about Excel Dynamic Chart #10: OFFSET Function Dynamic Range? Get free advice from education experts and Noodle community members.

  • Answer

Ask a New Question