Overview
-
Go beyond the built-in chart and graph tools in Excel. Learn how to create custom data visualizations, including how to build dynamic dashboards and gauge charts.
Syllabus
-
Introduction
- Part 2: Introduction
- Setting expectations
- Image overlay chart
- Binary ranges
- Automation with OFFSET and COUNTA
- Interactivity with form controls
- Animating changes over time
- Building a dynamic dashboard, part 1
- Building a dynamic dashboard, part 2
- Value-based formatting
- Dynamic series selection
- Custom pacing chart
- Custom gauge chart
- Visualizing percentages with arrays
- Wrapping up
