Class EmbeddedColumnChartBuilder

constss=SpreadsheetApp.getActiveSpreadsheet();
constsheet=ss.getSheets()[0];
constchart=sheet.newChart()
.setChartType(Charts.ChartType.BAR)
.addRange(sheet.getRange('A1:B8'))
.setPosition(5,5,0,0)
.build();
sheet.insertChart(chart);

constss=SpreadsheetApp.getActiveSpreadsheet();
constsheet=ss.getSheets()[0];
constrange=sheet.getRange('A1:B5');
constchart=sheet.newChart()
.setChartType(Charts.ChartType.BAR)
.addRange(range)
.setPosition(5,5,0,0)
.build();
sheet.insertChart(chart);

constss=SpreadsheetApp.getActiveSpreadsheet();
constsheet=ss.getSheets()[0];
// This code updates the chart to use only the new ranges while preserving the
// existing formatting of the chart.
constchart=sheet.getCharts()[0];
constnewChart=chart.modify()
.clearRanges()
.addRange(sheet.getRange('A1:A5'))
.addRange(sheet.getRange('B1:B5'))
.build();
sheet.updateChart(newChart);

constss=SpreadsheetApp.getActiveSpreadsheet();
constsheet=ss.getSheets()[0];
constchartBuilder=sheet.newChart()
.setChartType(Charts.ChartType.BAR)
.addRange(sheet.getRange('A1:B8'))
.setPosition(5,5,0,0);
// This method returns the exact same data as Chart#getContainerInfo()
constcontainerInfo=chartBuilder.getContainer();
// Logs the values used in setPosition()
Logger.log(
'Anchor Column: %s\r\nAnchor Row %s\r\nOffset X %s\r\nOffset Y %s',
containerInfo.getAnchorColumn(),
containerInfo.getAnchorRow(),
containerInfo.getOffsetX(),
containerInfo.getOffsetY(),
);

constss=SpreadsheetApp.getActiveSpreadsheet();
constsheet=ss.getSheets()[0];
constchartBuilder=sheet.newChart()
.setChartType(Charts.ChartType.BAR)
.addRange(sheet.getRange('A1:B8'))
.setPosition(5,5,0,0);
constranges=chartBuilder.getRanges();
// There's only one range as a data source for this chart,
// so this logs "A1:B8"
for(constiinranges){
constrange=ranges[i];
Logger.log(range.getA1Notation());
}

constss=SpreadsheetApp.getActiveSpreadsheet();
constsheet=ss.getSheets()[0];
constfirstRange=sheet.getRange('A1:B5');
constsecondRange=sheet.getRange('A6:B8');
constchartBuilder=sheet.newChart()
.setChartType(Charts.ChartType.BAR)
.addRange(firstRange)
// This range renders in a different color
.addRange(secondRange)
.setPosition(5,5,0,0);
// Note that you can use either of these two formats, but the range
// MUST match up with a range that was added via addRange(), or it
// is not removed, and does not throw an exception
chartBuilder.removeRange(firstRange);
chartBuilder.removeRange(sheet.getRange('A6:B8'));
constchart=chartBuilder.build();
sheet.insertChart(chart);

// Creates a pie chart builder and sets drawing of the slices in a
// counter-clockwise manner.
constbuilder=Charts.newPieChart();
builder.reverseCategories();

// Creates a line chart builder and sets the background color to gray
constbuilder=Charts.newLineChart();
builder.setBackgroundColor('gray');

constss=SpreadsheetApp.getActiveSpreadsheet();
constsheet=ss.getSheets()[0];
constrange=sheet.getRange('A1:B5');
constchart=sheet.newChart()
.setChartType(Charts.ChartType.BAR)
.addRange(range)
.setPosition(5,5,0,0)
.build();
sheet.insertChart(chart);

// Creates a line chart builder and sets the first two lines to be drawn in
// green and red, respectively.
constbuilder=Charts.newLineChart();
builder.setColors(['green','red']);

constss=SpreadsheetApp.getActiveSpreadsheet();
constsheet=ss.getSheets()[0];
constrange=sheet.getRange('A1:B5');
constchart=sheet.newChart()
.setChartType(Charts.ChartType.BAR)
.addRange(range)
.setHiddenDimensionStrategy(
Charts.ChartHiddenDimensionStrategy.IGNORE_COLUMNS,
)
.setPosition(5,5,0,0)
.build();
sheet.insertChart(chart);

// Creates a line chart builder and sets the legend position to right.
constbuilder=Charts.newLineChart();
builder.setLegendPosition(Charts.Position.RIGHT);

// Creates a line chart builder and sets it up for a blue, 26-point legend.
consttextStyleBuilder=
Charts.newTextStyle().setColor('#0000FF').setFontSize(26);
conststyle=textStyleBuilder.build();
constbuilder=Charts.newLineChart();
builder.setLegendTextStyle(style);

constss=SpreadsheetApp.getActiveSpreadsheet();
constsheet=ss.getSheets()[0];
constrange=sheet.getRange('A1:B10');
constrange2=sheet.getRange('C:C10');
constchart=sheet.newChart()
.setChartType(Charts.ChartType.BAR)
.addRange(range)
.addRange(range2)
.setMergeStrategy(Charts.ChartMergeStrategy.MERGE_ROWS)
.setPosition(5,5,0,0)
.build();
sheet.insertChart(chart);

constss=SpreadsheetApp.getActiveSpreadsheet();
constsheet=ss.getSheets()[0];
constrange=sheet.getRange('A1:B5');
constchart=sheet.newChart()
.setChartType(Charts.ChartType.BAR)
.addRange(range)
.setNumHeaders(1)
.setPosition(5,5,0,0)
.build();
sheet.insertChart(chart);

constspreadsheet=SpreadsheetApp.getActiveSpreadsheet();
constsheet=spreadsheet.getSheets()[0];
constchart=sheet.newChart()
.setOption('title','Earnings projections')
.setOption('legend',{
position:'top',
textStyle:{color:'blue',fontSize:16},
}).build();

constss=SpreadsheetApp.getActiveSpreadsheet();
constsheet=ss.getSheets()[0];
constrange=sheet.getRange('A1:B5');
constchart=sheet.newChart()
.setChartType(Charts.ChartType.BAR)
.addRange(range)
.setPosition(5,5,0,0)
.build();
sheet.insertChart(chart);

// Creates a line chart builder and title to 'My Line Chart'.
constbuilder=Charts.newLineChart();
builder.setTitle('My Line Chart');

// Creates a line chart builder and sets it up for a blue, 26-point title.
consttextStyleBuilder=
Charts.newTextStyle().setColor('#0000FF').setFontSize(26);
conststyle=textStyleBuilder.build();
constbuilder=Charts.newLineChart();
builder.setTitleTextStyle(style);

constss=SpreadsheetApp.getActiveSpreadsheet();
constsheet=ss.getSheets()[0];
constrange=sheet.getRange('A1:B5');
constchart=sheet.newChart()
.setChartType(Charts.ChartType.BAR)
.addRange(range)
.setTransposeRowsAndColumns(true)
.setPosition(5,5,0,0)
.build();
sheet.insertChart(chart);

// Creates a line chart builder and sets the X-axis text style to blue, 18-point
// font.
consttextStyle=
Charts.newTextStyle().setColor('blue').setFontSize(18).build();
constbuilder=Charts.newLineChart();
builder.setXAxisTextStyle(textStyle);

// Creates a line chart builder and sets the X-axis title.
constbuilder=Charts.newLineChart();
builder.setTitle('X-axis Title');

// Creates a line chart builder and sets the X-axis title text style to blue,
// 18-point font.
consttextStyle=
Charts.newTextStyle().setColor('blue').setFontSize(18).build();
constbuilder=Charts.newLineChart();
builder.setXAxisTitleTextStyle(textStyle);

// Creates a line chart builder and sets the Y-axis text style to blue, 18-point
// font.
consttextStyle=
Charts.newTextStyle().setColor('blue').setFontSize(18).build();
constbuilder=Charts.newLineChart();
builder.setYAxisTextStyle(textStyle);

// Creates a line chart builder and sets the Y-axis title.
constbuilder=Charts.newLineChart();
builder.setYAxisTitle('Y-axis Title');

// Creates a line chart builder and sets the Y-axis title text style to blue,
// 18-point font.
consttextStyle=
Charts.newTextStyle().setColor('blue').setFontSize(18).build();
constbuilder=Charts.newLineChart();
builder.setYAxisTitleTextStyle(textStyle);