Excel Data Visualization: Designing Custom Visualizations

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.

Introduction

• Part 2: Introduction

1. Next-Level Data Visualization Demos

• 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

• Wrapping up