How to include quickchart-js using google app script

[typpo]

How to include quickchart-js using google app script

[typpo]

HI @petertalkman! In Google Apps Script, it's probably easiest to construct the QuickChart URL manually. You don't need quickchart-js for this.

For example:

function GetChartUrl(values) {
  var width = 500;
  var height = 300;
  var backgroundColor = 'white';
  var config = `{
  type: 'bar',
  data: {
    labels: ['Q1', 'Q2', 'Q3', 'Q4'],
    datasets: [{
      label: 'Data',
      data: [${values.join(',')}]
    }]
  }
}
`;
  return `https://quickchart.io/chart?c=${encodeURIComponent(config)}&w=${width}&h=${height}&bkg=${backgroundColor}&devicePixelRatio=1`
}

And the formula in Google Sheets:

=GetChartUrl(A2:A6)

or, to display an image:

=IMAGE(GetChartUrl(A2:A5))

Here's an example sheet that generates a chart URL: https://docs.google.com/spreadsheets/d/1cOjoT4viETplmdTvNOeDKVjwIqZpIr2afMCiK7vgQLY/edit#gid=0