Excel Hack 74: Dynamic scroll bars for interactive dashboards in MS Excel
Have you come across a scroll bar that makes an Excel chart dynamic, like shown below: This scroll bar is a form control that has been programmed to increment on click, and this action automatically adjusts the range of the chart in view. The chart data is made dynamic by the use of the OFFSET