Sankey Data Preparation & Troubleshooting
Prepare data for a Sankey diagram and fix the usual problems: Excel and CSV input, too many nodes, values that do not match, loops, missing values and unconnected nodes.
Sankey Data Preparation & Troubleshooting in this category
- Sankey Chart From Excel Data: Turn a Spreadsheet Into a Sankey Diagram — Excel has no built-in Sankey chart type. Copy a source, target, value table from Excel, paste it into a new QueryChart Sankey and edit the diagram. No add-ins or macros.
- CSV to Sankey Diagram: The Source, Target, Value Format — A Sankey diagram needs three columns: source, target and value. See the CSV layout, a worked funnel example and how to turn the file into an editable diagram.
- How to Prepare Data for a Sankey Chart — Turn raw rows into the source, target and value list a Sankey chart needs: aggregate first, name nodes consistently and check that every node balances before you chart.
- Sankey Chart With Too Many Nodes: How to Simplify It — A Sankey with dozens of nodes turns into a tangle. Group small categories, split one chart into two, and keep the nodes that carry the story; the example shows how.
- Sankey Chart Values Don't Match: How to Find the Gap — If the ribbons going into a node are not as wide as the ones leaving it, a number is missing or wrong. Learn the usual causes and how QueryChart's warnings help you find them.
- Multi-Stage Sankey Chart: How to Build One With Four Levels — Chain several stages into one Sankey, from order channel to warehouse to carrier to delivery outcome. Learn how to structure multi-level flows and keep them balanced.
- How to Make a Sankey Diagram Readable — Practical rules for a Sankey people can read: fewer nodes, a sensible order, direct labels, restrained colour and printed numbers. The example applies each of them.
- Data Cleaning Pipeline Sankey Diagram: Template — Show how many records from each source pass validation, are fixed automatically or are rejected, and why. Replace the counts with your own import or ETL numbers.
- Sankey Chart Loops and Cycles: How to Handle Rework — Some flows go back to an earlier step, such as rework or returned goods. See how a loop is drawn as a return flow and how the totals count it.
- Sankey Chart Missing or Negative Values: What Happens — A blank, negative or non-numeric amount cannot be drawn as a ribbon. See how the editor treats it, when it falls back to equal-width ribbons, and how to fix the data.
- Sankey Chart Unconnected Nodes: Why a Node Floats Alone — A node that appears in the data but has no flows is drawn dashed and flagged. See what causes it, usually a misspelt name, and how to connect or remove it.