Google Apps Script API
    Preparing search index...

    Interface Charts

    Entry point for creating Charts in scripts.

    This example creates a basic data table, populates an area chart with the data, and adds it into a web page as an image:

    function doGet() {
  var data = Charts.newDataTable()
      .addColumn(Charts.ColumnType.STRING, "Month")
      .addColumn(Charts.ColumnType.NUMBER, "In Store")
      .addColumn(Charts.ColumnType.NUMBER, "Online")
      .addRow(["January", 10, 1])
      .addRow(["February", 12, 1])
      .addRow(["March", 20, 2])
      .addRow(["April", 25, 3])
      .addRow(["May", 30, 4])
      .build();

  var chart = Charts.newAreaChart()
      .setDataTable(data)
      .setStacked()
      .setRange(0, 40)
      .setTitle("Sales per Month")
      .build();

   var htmlOutput = HtmlService.createHtmlOutput().setTitle('My Chart');
   var imageData = Utilities.base64Encode(chart.getAs('image/png').getBytes());
   var imageUrl = "data:image/png;base64," + encodeURI(imageData);
   htmlOutput.append("Render chart server side: <br/>");
   htmlOutput.append("<img border=\"1\" src=\"" + imageUrl + "\">");
   return htmlOutput;
}
    interface Charts {
        ChartHiddenDimensionStrategy: typeof ChartHiddenDimensionStrategy;
        ChartMergeStrategy: typeof ChartMergeStrategy;
        ChartType: typeof ChartType;
        ColumnType: typeof ColumnType;
        CurveStyle: typeof CurveStyle;
        PointStyle: typeof PointStyle;
        Position: typeof GoogleAppsScript.Charts.Position;
        newAreaChart(): AreaChartBuilder;
        newBarChart(): BarChartBuilder;
        newColumnChart(): ColumnChartBuilder;
        newDataTable(): DataTableBuilder;
        newDataViewDefinition(): DataViewDefinitionBuilder;
        newLineChart(): LineChartBuilder;
        newPieChart(): PieChartBuilder;
        newScatterChart(): ScatterChartBuilder;
        newTableChart(): TableChartBuilder;
        newTextStyle(): GoogleAppsScript.Charts.TextStyleBuilder;
    }
    Index

    Properties

    ChartHiddenDimensionStrategy ChartMergeStrategy ChartType ColumnType CurveStyle PointStyle Position

    Methods

    newAreaChart newBarChart newColumnChart newDataTable newDataViewDefinition newLineChart newPieChart newScatterChart newTableChart newTextStyle

    Properties
    ChartHiddenDimensionStrategy: typeof ChartHiddenDimensionStrategy
    ChartMergeStrategy: typeof ChartMergeStrategy
    ChartType: typeof ChartType
    ColumnType: typeof ColumnType
    CurveStyle: typeof CurveStyle
    PointStyle: typeof PointStyle
    Position: typeof GoogleAppsScript.Charts.Position

    Methods

    Settings
    Member Visibility

    On This Page
    Properties
    Methods