Excel Data Visualization Part 1: Charts & Graphs

Chris Dutton, Founder, Excel Maven

Play Speed
  • 0.5x
  • 1x (Normal)
  • 1.25x
  • 1.5x
  • 2x
28 Lessons (2h 27m)
    • 1. Course Structure and Outline

      2:03
    • 2. Key Data Viz Principles & The 10-Second Rule

      2:45
    • 3. The Good, The Bad, and The Ugly

      3:44
    • 4. The 3 Key Questions

      1:49
    • 5. Customizing Charts in Excel: Setting Expectations

      1:02
    • 6. Chart Elements, Layouts, Colors, and Styles

      6:20
    • 7. Chart Formatting Options

      5:27
    • 8. Changing Chart Types & Adding a Secondary Axis

      3:03
    • 9. Creating, Modifying & Applying Custom Templates

      4:06
    • 10. Bar & Column Charts

      8:49
    • 11. Histograms & Pareto Charts

      5:58
    • 12. Line Charts & Trendlines

      5:16
    • 13. Area Charts

      4:41
    • 14. Pies, Donuts, and Race Tracks

      12:04
    • 15. Scatter Plots

      7:30
    • 16. Bubble Charts

      6:36
    • 17. Box & Whisker Charts

      6:05
    • 18. Tree Maps & Sunburst Charts

      6:36
    • 19. Waterfall Charts

      3:17
    • 20. Funnel Charts

      3:42
    • 21. Radar Charts

      7:56
    • 22. Stock Charts

      7:18
    • 23. Heat Maps

      4:41
    • 24. Surface & Contour Charts

      7:35
    • 25. Geo-Spatial Maps with Power Map

      5:28
    • 26. Basic Combo Charts

      7:57
    • 27. Sparklines

      2:07
    • 28. Conclusion

      2:38
33 students are watching this class

Project Description

Download the attached spreadsheet (properly formatted with pre-populated data) to follow along with the demos in each lecture and practice at your own pace.

You'll also find a PDF download containing 20 data viz cheat sheets, summarizing each of the chart types in Excel and how they can be applied to your own work.

Student Projects