GSC Devices Bar Chart

GSC Devices Bar Chart

function generateCharts() {
  // Access the sheet
  var sheet = SpreadsheetApp.getActiveSpreadsheet().getSheetByName('Devices');
  
  // Sort Column A
  sheet.getRange('A2:E4').sort(1);
  
  // Get the range for your data
  var dataRange = sheet.getRange('A1:E4');

  // Create a pie chart for Clicks
  var pieChartBuilder = sheet.newChart();
  pieChartBuilder.addRange(dataRange)
      .setChartType(Charts.ChartType.PIE)
      .setOption('title', 'Clicks per Device')
      .setPosition(5, 6, 0, 0)
      .setOption('sliceVisibilityThreshold', 0) // Ensures that all slices are shown
      .asPieChart();
  sheet.insertChart(pieChartBuilder.build());
}