//OpensthespreadsheetfilebyitsID.IfyoucreatedyourscriptfromaGoogleSheetsfile,//useSpreadsheetApp.getActiveSpreadsheet().//TODO(developer):ReplacetheIDwithyourown.constss=SpreadsheetApp.openById('abc123456');//GetsSheet1byitsname.constsheet=ss.getSheetByName('Sheet1');//GetstherangeA1:B7onSheet1.constrange=sheet.getRange('A1:B7');//GetstherangeA1:B7asadatatable.Thevaluesineachcolumnmustbeofthesametype.constdatatable=range.getDataTable();//UsestheChartsservicetobuildabarchartfromthedatatable.//Thisdoesn't build an embedded chart. To do that, use sheet.newChart().addRange() instead.constchart=Charts.newBarChart().setDataTable(datatable).setOption('title','Your Chart Title Here').build();
[[["Łatwo zrozumieć","easyToUnderstand","thumb-up"],["Rozwiązało to mój problem","solvedMyProblem","thumb-up"],["Inne","otherUp","thumb-up"]],[["Brak potrzebnych mi informacji","missingTheInformationINeed","thumb-down"],["Zbyt skomplikowane / zbyt wiele czynności do wykonania","tooComplicatedTooManySteps","thumb-down"],["Nieaktualne treści","outOfDate","thumb-down"],["Problem z tłumaczeniem","translationIssue","thumb-down"],["Problem z przykładami/kodem","samplesCodeIssue","thumb-down"],["Inne","otherDown","thumb-down"]],["Ostatnia aktualizacja: 2024-09-10 UTC."],[[["`DataTableSource` is an interface for objects that can present their data as a `DataTable` for use in Google Charts."],["Classes such as `DataTable` and `Range` implement the `DataTableSource` interface."],["The primary method of `DataTableSource` is `getDataTable()`, which returns the object's data formatted as a `DataTable`."],["You can access data from spreadsheet ranges and use it to create charts using the `DataTableSource` and the Charts service."]]],[]]