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.

Dynamic series selection

Dynamic series selection - Microsoft Excel Tutorial

From the course: Excel Data Visualization: Designing Custom Visualizations

Start my 1-month free trial Buy for my team

Dynamic series selection

“

- [Instructor] Our next demo is hands down one of my favorites. It's about dynamically highlighting a specific data series. In the dynamic series selection tab, you'll see some familiar data. We've got our movie ticket sales by month for four different genres, comedy, thriller, documentary, and romance. What I want to do here is build a stack area chart that dynamically features or highlights whichever genre a user has selected in this data validation cell here in B2. To do that, we're going to need to create two versions of each of these four series. One to define the formatting when that genre is not selected in cell B2 and a second to define the formatting when that genre is selected. In other words, each of these four genres will have a light-filled version and a dark-filled version, and only the dark-filled version will populate data and be visualized in the chart when that genre is selected here in the drop-down. To kick things off, I'm going to grab each of our genres and just…

Contents