- Explain how to define the elements in a thermometer chart.
- Review the purpose of OFFSET and COUNTA functions.
- Relate why a guardrail is used when creating scroll bars and zoom bars.
- Examine the reason for using value-based dynamic formatting.
- Determine what a gauge-and-needle chart is and how to create one.
Skill Level Intermediate
- [Chris] Hey everyone, Chris Dutton here, and welcome to Excel Data Visualization, Part 2: Designing Custom Visuals. In this course, I'll walk you through several hands-on demos and show you how to use tools like named ranges and form controls to build scrolling charts, dynamic dashboards, gauge charts, pacing tools, along with other unique custom visuals. Now keep in mind that this is part two of a two-part series. We'll be picking up right where we left off in part one, Mastering Charts & Graphs, so I'd recommend working through that section first to make sure that you're comfortable with Excel's core database capabilities.
Ready to get started? Let's dive in.