Creating a Dynamic Chart with Spin Buttons in Excel | Everyday Office 060
4,853 views · Published 9 June 2017 · 14:43 · Indexed 13 October 2026
Channel: Neil Malek · 2017 · Education
Can I change the range of values used in a chart by user interface? Can a spinner button affect a chart's range? In this video tutorial, Neil Malek from Knack Training demonstrates how using Spin Buttons, the OFFSET function, and Named Ranges lets him change the range of cells used in a chart on the fly. Create a dynamic data range for a chart in less than 15 minutes.
