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.
Animating changes over time - Microsoft Excel Tutorial
From the course: Excel Data Visualization: Designing Custom Visualizations
Animating changes over time
- [Instructor] So the other day I was online and I came across a very cool example of data vis that I want to share with you guys. I found it on the PewResearchCenter site, which is an organization that captures a lot of US politics and policy related data. And basically they had this really cool piece about political polarization and they built out this animated visual that I thought was just the coolest thing ever. It's a really great example of using overlapping area charts and animating them over time to tell a really clear story. And what we're looking at here is basically Democrat and Republican viewpoints in terms of being consistently liberal versus consistently conservative. And essentially what this area chart is doing is it's almost acting like a dual histogram where you're seeing the distribution of two different datasets changing over time, as well as the overlap between them. And so they've got five different years in the sample and as you page through you can see how…
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)
-