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.
Excel Data Visualization: Designing Custom Visualizations
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
- Wrapping up
Taught by
Chris Dutton
Related Courses
-
Excel Data Visualization Part 2: Advanced Demos
-
Excel Data Visualization Part 1: Charts & Graphs
-
Data Visualization in Excel
5.0 -
Excel Data Visualization - Guide to Charts and Dashboards
-
Microsoft Excel: Data Visualization w/ Excel Charts & Graphs
-
Data Visualization and Dashboards with Excel and Cognos
