-
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.
Interested in using more than the built-in chart and graph tools to showcase your data in Excel? In this courseâthe second and final installment in the Excel Data Visualization seriesâinstructor Chris Dutton steps through how to create unique, custom data visualizations in Excel. Since Chris covered the core data visualization capabilities of Excel in the previous installment of the series, he dives into some more sophisticated techniques here. As he moves through a series of hands-on demos, Chris covers everything from building dynamic dashboards to advanced maneuvers like value-based formatting and dynamic series selection.
Overview
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
- Part 2: Conclusion
