This Gist is there to help you creating a Sankey Diagram from your Google Spreadsheets.
- Open a spreadsheet
- Click "Tools" -> "Scripts"
- create the two files
code.gs
andindex.html
- insert the document ID from the URL on line 10,
code.gs
- select which sheet is the base for the sankey diagram
- the layout of the table should be as shown in the Example Spreadsheet
- Open the same document
- Click "Zusatzfunktionen" -> "SankeyDiagram"
https://docs.google.com/spreadsheets/d/1IUmvhYuuBvfYEu8OfDczmW6LQW-xaeh5c6rklOg3x-o/
Hi @njoerd114,
It's working and thanks for sharing.
I would like to share a Google Sheets add-on for Sankey chart. Support up to 8 levels of Sankey diagram. There is no need to add scripting or coding. It's no-code tool with 50+ other advanced visualizations. Hope you will like it. Please share your thoughts.
For Google Sheets
https://chartexpo.com/utmAction/NCtjb21tdW5pdHkrZ3MrcWorR0gr
It's also available for Excel and Office 365.
https://chartexpo.com/utmAction/NCtjb21tdW5pdHkreGwrcWorR0gr
Thanks