From the course: Excel Data Visualization: Designing Custom Visualizations

Unlock this course with a free trial

Join today to access over 24,100 courses taught by industry experts.

Building a dynamic dashboard, part 2

Building a dynamic dashboard, part 2 - Microsoft Excel Tutorial

From the course: Excel Data Visualization: Designing Custom Visualizations

Start my 1-month free trial Buy for my team

Building a dynamic dashboard, part 2

“

- [Instructor] Okay, so welcome to part two of our interactive dashboard demo. The goal of part two is to essentially add some more interactivity to the dashboard that we built out in part one. So looking at our original dashboard, you'll see that we chose to visualize three different pairs of metrics. We're showing hits and average, at bats, and RBI, and stolen base and stolen base rate, but what if a user would rather see runs and caught stealing or triples and strikeouts? What if they want to see any different combination of the columns that we've included here? To allow that to happen, we need to create a dynamic version of one of these charts, such that a user can select any two metrics and those metrics would be visualized. So let's start by just rearranging things a little bit. I'm going to shift click these two charts, shrink 'em down just a little bit, and I'm going to just reposition one above the other. And then this third one is the one that I'm going to turn into my…

Contents