What is a Sankey chart?

A Sankey chart or diagram, is a type of flow diagram that is used to visualize the flow of some resource between process nodes of a network. The width of the connectors represents the volume of flow between processes, and typically the overall volume of resource is preserved throughout the system being visualized.Flows are unidirectional, and loops in the system (A sending to B and then B sending something back to A) are invalid. You can read more about Sankey charts here

Sankey Snip is a Google Sheets add-on/Office add-in which maintains a sankey chart preview in the sidebar of the active sheet's data in real time.

Suitable types of data

Sankey charts are often used to show transformations in a system (for example energy sources and uses), or material or money flows between a co-operating group. Google Analytics uses this kind of diagram to report on site navigation behavior.

Data format

A Sankey chart needs 3 data items, which should be laid out as columns with headers in a sheet.

• Source. Sending process name
• Target. Receiving process name
• Volume. Volume of flow between 'Source' and 'Target'

By default, the source data columns will be automatically detected in the active sheet, but you can customize the column names and range via the Data Settings. Any changes you make to the data will periodically be reflected in the chart preview.

Chart image

You can get a scaled up version of the chart preview by copying the code shown in the Chart settings/embed code area. This will be in SVG format so that you can embed the code or link to the drive file in a web site or document.

It is also possible to insert a static version of the chart in your sheet. The scale and look of the chart is controlled by options in Chart settings.

Google Charts are used for visualization. More information about settings and options can be found here.

Additional assistance with using this add-on is available at desktop liberation