How to make a Sankey diagram in Excel (and a faster way)

If you've searched for a Sankey diagram in Excel, you've probably already hit the wall: there isn't one. Excel ships with bars, lines, pies and even treemaps, but the flowing ribbon chart that makes an income statement or a budget so easy to read is simply not in the chart menu. That doesn't mean it's impossible — it means you either fight the spreadsheet or route around it. This guide covers both, honestly.

Why Excel has no Sankey button

A Sankey isn't a plot of x against y; it's a graph of nodes connected by weighted flows, laid out so ribbons never overlap. Excel's charting engine was never designed for that kind of layout math, and Microsoft has never added a native Sankey type. So every method below is a workaround stacked on top of tools built for something else.

The manual route 1: draw it by hand with Shapes

The most common thing people actually do is fake it. They insert rectangles for nodes, then draw thick freeform or curved connectors between them and eyeball the widths to roughly match the numbers. It works for a screenshot, but it's fragile: nothing is tied to your data, so when a figure changes you're back to nudging shapes by hand, and the ribbon widths are never truly proportional. It's a drawing, not a chart.

The manual route 2: stacked bars and add-ins

The more technical approach is to build a set of stacked bar charts and align them so the segments read like flows, or to install a third-party Sankey add-in from the Office store. Both can produce something, but you'll spend real time wrangling helper columns, sort orders and spacer series — and add-ins often stamp a watermark or cap how many flows you can draw. For a one-off it's a long afternoon; for a chart you update every month it's a recurring tax.

• No native Sankey type means every Excel method is a workaround.
• Hand-drawn shapes aren't linked to your data, so updates are manual.
• Stacked-bar tricks need spacer rows and constant re-sorting.
• Add-ins frequently watermark the output or limit the number of flows.

The shortcut: keep your data in Excel, draw the chart elsewhere

Here's the thing — you don't have to abandon your spreadsheet. Your P&L or budget can live in Excel exactly as it is. The layout is the hard part, not the numbers, so the fastest path is to let a purpose-built tool handle the layout while Excel keeps doing the math. Export the relevant range as CSV, or literally copy the cells and paste them into MakeCharts, and the flows are read straight from your columns.

The pattern is simple: one column for the source, one for the target, one for the amount — or paste a normal income-statement block and let the AI copilot infer the flows for you. From there you can color costs red and profit green in a click, then export a clean SVG or PNG watermark-free on paid plans. Next month you paste the new numbers over the old ones and the chart redraws itself.

So yes, you can technically make a Sankey in Excel with enough patience — but for anything you plan to reuse, keeping the data in the spreadsheet and drawing the chart where Sankeys are a first-class citizen will save you the afternoon.