0

I'm trying an appscript to copy a pie chart from sheets to slide. However, it is inserting in the form of image. I tried - slide.addchart() or slide.insertchart() is also not working. It says type function error.

I need the chart to be dynamic. As updating data on sheet would make changes in the chart and same should be updated in slides.

To summarize, my chart should be linked chart instead of images. Could you look into it?

function copyChartToSlide() {

  var sheetName = "CSAT";
  var chartIndex = 0;
  var slideIndex = 48;
  
  var spreadsheetId = "1qOOkSUOMW6VJdGlfCPqX6v-rudYZBwnCFHBhtYGG8w4"; 
  var sheet = SpreadsheetApp.openById(spreadsheetId).getSheetByName(sheetName);
  var chart = sheet.getCharts()[chartIndex];
  var imageBlob = chart.getAs('image/png').setName('chart');

  var Slidename = Browser.inputBox('Presentation ID', 'Enter the ID of the presentation', Browser.Buttons.OK_CANCEL);
  
  var presentationId = Slidename; 
  var presentation = SlidesApp.openById(presentationId);
  var slide = presentation.getSlides()[slideIndex];
  
  slide.insertImage(imageBlob);
}
Tony
  • 87
  • 6

0 Answers0