From the course: Access 2019: Building Dashboards for Excel
Unlock the full course today
Join today to access over 22,600 courses taught by industry experts or purchase this course individually.
Set slicer options
From the course: Access 2019: Building Dashboards for Excel
Set slicer options
- [Instructor] Now that we've added slicers to our Dashboard file, let's go set some options to make them even better. OK, so let's choose the Department slicer first, and if you look up top, you have a ribbon tab. Alright, let's go ahead and double-click that to bring our ribbon back active, we minimized it earlier. Maybe we want to change the color of it so that it's stands out a little bit different from the Manager display. So here I'm going to go ahead and make this one green. Again, I can size it, for the size that it needs to be. And then you see this Slicer Caption? Let's click at the front of that, let's go ahead and say Select Department. Perfect, and let's go see our Slicer Settings. Here it's called Department, we're displaying the header called Select Department, we can choose how to sort it, we can hide items with no data, and right now it's set to visually indicate, so if we choose a department and the managers…
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.