1

So basically you just need to know the name of the sheet where your chart is. function updateCHARTtitleOnEdit() { var sheet = SpreadsheetApp.getActiveSpreadsheet().getSheetByName("SHEET_NAME"); var chart = sheet.getCharts()[0];// in my case I had only 1 chart on this sheet chart = chart.modify().setOption('title', "DYNAMIC CHART TITLE" || 'Empty')....


Only top voted, non community-wiki answers of a minimum length are eligible