How to make charts in Google Apps Script

The Charts Service

Google Apps Script offers a charts service. Using this you can build a dataTable as input to a chart, as well as the chart itself. Elsewhere on this site I covered how to get Excel data into Google Visualization Charts, and how to create Google Data Tables in such projects as Using Google Visualization charts and tablesUsing Google Visualization DataViewsEmbedding Google Motion Charts in Excel and various other articles. Now it turns out that Google Apps Script has something like these capabilities, but  rather less feature rich versions. As in What to use in place of Excel Shapes we use a UI panel to contain the chart object. The Excel versions of How to use the Excel Roadmapper shows how to create a ‘cost of ownership chart’ appended to a roadmap, and looks like this.