EAF#9 - Dynamic Excel Chart Using Offset

Excel Tips for Fitness Trainers and Sport Scientists Use functions and built in features of excel 2010 to make your life easier Make a dynamic chart that allows you to expand and contract the data set using controls (data validation and spin button). Use Conditional Formatting to highlight the selected range OFFSET, MATCH