Sankey Chart Excel

What this does

A Sankey diagram shows flows between stages, with band width proportional to the quantity moving along it. No Excel release, including Microsoft 365, ships it as a chart type, and nothing in the Insert gallery approximates it. The three honest routes are a manual construction from stacked bars and shapes, a marketplace add-in, or an external tool whose output is pasted in as an image. Before you run it on a workbook other people depend on, try it on a copy or a few rows first. Undo only reaches back through the current session, so a quick trial run is the cheapest way to see exactly what will change before the file is saved and shared. The difference between a quick fix and a sheet you can trust is the extra minute you spend validating “sankey chart excel”. Start on a copy or a tiny sample, keep the affected chart visible, and compare the result with the tool above before you touch the real workbook. When this is a ribbon command, the selection matters more than the button: confirm the range, apply the command, then spot-check the output before saving. The point is a visual that makes the number obvious at a glance, but the practical win is that someone else can open the file and understand what happened without asking you.

A worked example

A funnel of 1,000 visitors splits into 300 sign-ups and 700 drop-offs, and the sign-ups split again into 90 paid and 210 free. Written as a Source, Target, Value table, that is four rows — visitors to sign-ups, visitors to drop-offs, sign-ups to paid, sign-ups to free. That table is the shape every Sankey tool expects as input, and the thing to prepare before choosing a route. The honest answer saves an afternoon: people search for the chart type, find blog posts implying it exists, and rebuild the same disappointment from scratch. When the result is not what you expected, undo straight away rather than repairing it by hand — undo restores the sheet exactly, while manual fixes tend to leave small inconsistencies behind that surface later.

In Google Sheets

This is a command rather than a formula, so there is no syntax to carry over. Google Sheets arranges its commands in menus across the top instead of a ribbon, names some of them differently and does not have every Excel command — look for the equivalent in the Sheets menus or its help before assuming the steps match. Keep this page bookmarked for the next time the same question comes up. Better still, repeat the steps once in your own workbook — doing it yourself is what turns a copied answer into something you remember. Treat “sankey chart excel” as a routine rather than a one-off. Once you know which setting or command controls it, the same few steps handle every workbook where it comes up in Excel, and you can explain them to a colleague in a sentence.

Common mistakes

• Searching the Insert gallery for a chart type that does not exist in any version.
• Drawing the bands by hand at arbitrary widths, which quietly breaks the one property that makes a Sankey a Sankey.
• Letting inflow and outflow disagree at a node, so the diagram reads as though volume appeared or vanished.
• Shipping a watermarked add-in export into a client deck without checking the licence terms.

Frequently asked questions