From the course: Excel Data Visualization: Designing Custom Visualizations

Unlock this course with a free trial

Join today to access over 22,400 courses taught by industry experts.

Interactivity with form controls

Interactivity with form controls

- [Instructor] This next demo is one of my favorites. It's a really cool one and it's something that a lot of people don't realize that you could even do in Excel. And it's all about building charts that can automatically scroll and zoom. To do that we're going to use the OFFSET function, but instead of combining it with Count Day, like we've done in the past, this time we're going to insert something called Form Controls, which will allow users to actually click and drag and manipulate Scroll Bars in the workbook to dynamically change the view that they're seeing within the chart. So it's a really cool combination of tools to create a really interesting effect. So in the Scroll and Zoom Charts tab, first things first, make sure that you have the Developer tab in your ribbon. If not, it's super easy to add. Just head to the File option, go into Options at the bottom, Customize Ribbon, and here on the right side of the pane you should see a checkbox next to the Developer line. If…

Contents