Excel Chart Tutorials
Browse our collection of actionable guides, templates, and troubleshooting fixes.
How to Make a Waterfall Chart in Excel (Modern Method + Legacy)
Build a waterfall chart in Excel the modern way with the native chart type, fix the Set as Total trap, plus a legacy fallback for older versions.
Dynamic Charts in Excel: Build Charts That Update Themselves
Make Excel charts that auto-update as data grows. The modern way uses Tables and dynamic arrays — no OFFSET, no named-range gymnastics.
How to Add a Secondary Axis in Excel (and When You Should)
Add a secondary axis in Excel the modern way — plus the honest guide to when a dual-axis chart helps and when it quietly misleads your audience.
How to Build a Heat Map in Excel (Without Add-Ins)
Create a heat map in Excel in three clicks with conditional formatting — no add-ins. Includes custom color rules, PivotTable heat maps, and geographic maps.
How to Make a Combo Chart in Excel (Two Chart Types, One Chart)
Build a combo chart in Excel step by step — columns plus a line, with or without a secondary axis — and learn which combinations clarify vs confuse.
How to Make a Pareto Chart in Excel (the Modern Way)
Build a Pareto chart in Excel in four clicks with the native Statistic Chart — plus the manual method for when the built-in version isn't enough.
How to Make a Sankey Diagram in Excel (Yes, It's Possible)
Excel has no native Sankey chart. Here's the least-painful way to build one anyway, plus when a free tool beats Excel entirely.
PivotCharts in Excel: The Complete Guide
Create, filter, slice and refresh PivotCharts in Excel. A complete guide from first chart to slicer-driven dashboards — with the refresh gotcha explained.
How to Create a Bell Curve in Excel (Step by Step)
Build a bell curve in Excel the modern way with NORM.DIST and dynamic arrays — one spill formula, no fill handle. Free working .xlsx included.
How to Make a Bullet Chart in Excel (KPI Tracking Done Right)
Build a bullet chart in Excel step by step — bands, actual bar, and target marker — and see why bullets beat gauge charts for KPI dashboards.
How to Make a Funnel Chart in Excel
Build a funnel chart in Excel with the native chart type in three clicks — plus conversion-rate labels and a legacy method for Excel 2016 and earlier.
How to Make a Tornado Chart in Excel for Sensitivity Analysis
Build a clean tornado chart in Excel for sensitivity analysis: diverging bars, auto-sorted by impact with dynamic arrays. No add-ins, no helper-column hacks.
How to Make a Dumbbell Chart in Excel
Build a dumbbell chart in Excel with one scatter plot and one error bar — the simplest reliable method. Before/after comparisons without add-ins.
How to Make a Waffle Chart in Excel
Build a waffle chart in Excel with conditional formatting — no add-ins. A 10x10 grid that shows percentages better than any pie chart.