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/
I'm very excited to use this, however, I am getting an error:
Invalid format in datatable: column #3 must be of type 'number'.×
I have confirmed that the entire col 3 is Format>Number>Number, and that the right sheet is indicated.