From the course: Excel Data Visualization: Designing Custom Visualizations
Unlock this course with a free trial
Join today to access over 23,100 courses taught by industry experts.
Interactivity with form controls - Microsoft Excel Tutorial
From the course: Excel Data Visualization: Designing Custom Visualizations
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…
Practice while you learn with exercise files
Download the files the instructor uses to teach the course. Follow along and learn by watching, listening and practicing.
Contents
-
-
-
(Locked)
Setting expectations1m 8s
-
(Locked)
Image overlay chart6m 1s
-
Binary ranges5m 2s
-
(Locked)
Automation with OFFSET and COUNTA7m 8s
-
(Locked)
Interactivity with form controls12m 30s
-
(Locked)
Animating changes over time14m 3s
-
(Locked)
Building a dynamic dashboard, part 116m 10s
-
(Locked)
Building a dynamic dashboard, part 212m 8s
-
(Locked)
Value-based formatting10m 10s
-
(Locked)
Dynamic series selection10m 26s
-
Custom pacing chart10m 23s
-
(Locked)
Custom gauge chart9m 58s
-
(Locked)
Visualizing percentages with arrays7m 16s
-
(Locked)
-