Class Central is learner-supported. When you buy through links on our site, we may earn an affiliate commission.

LinkedIn Learning

Excel Data Visualization: Designing Custom Visualizations

via LinkedIn Learning

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.

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.

Syllabus

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
  • Part 2: Conclusion

Taught by

Chris Dutton

Related Courses

Reviews

Start your review of Excel Data Visualization: Designing Custom Visualizations

Never Stop Learning!

Get personalized course recommendations, track subjects and courses with reminders, and more.

Sign up for free