From the course: Excel Data Visualization: Mastering 20+ Charts and Graphs
Join today to access over 22,600 courses taught by industry experts.
The good, the bad, and the ugly - Microsoft Excel Tutorial
From the course: Excel Data Visualization: Mastering 20+ Charts and Graphs
The good, the bad, and the ugly
- [Instructor] Alright, it's time for one of my favorite sections of the course called, The GOOD, THE BAD, AND THE UGLY. Now, in this section I'm going to walk through some examples that I feel are strong, weak, and downright ugly cases of data visualization. So, first, let's start with the good. Here we have a nice overlapping area chart. It shows political polarization in the US. It also has the option to change the date range to show animations over time. Really nice, really simple, really effective. Next, we have a custom built pacing chart. Where we're looking at cumulative revenue overtime against a goal, or a target. And here, we're using some really clever dynamic formatting rules to shade the difference, different colors based on whether we're under-pacing or over-pacing that target. And third, simple, intuitive custom-designed gauge chart. This chart is really only intended to show one thing. Which is where a particular value falls along a given range. In this case from zero…
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.
Download courses and learn on the go
Watch courses on your mobile device without an internet connection. Download courses using your iOS or Android LinkedIn Learning app.