Charts

This service allows users to create charts using
[Google Charts Tools](https://developers.google.com/chart/interactive/docs/gallery) and render them server side.
If you want to render charts in a web browser, use the
[Google Charts API](https://developers.google.com/chart/interactive/docs/reference) instead.

This example creates a basic data table, populates an area chart with the data,
and adds it to 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;

    }

## Classes

| Name | Brief description |
|---|---|
| `https://developers.google.com/apps-script/reference/charts/area-chart-builder` | Builder for area charts. |
| `https://developers.google.com/apps-script/reference/charts/bar-chart-builder` | Builder for bar charts. |
| `https://developers.google.com/apps-script/reference/charts/chart` | A Chart object, which can be converted to a static image. |
| `https://developers.google.com/apps-script/reference/charts/chart-hidden-dimension-strategy` | An enumeration of how hidden dimensions in a source are expressed in a chart. |
| `https://developers.google.com/apps-script/reference/charts/chart-merge-strategy` | An enumeration of how multiple ranges in the source are expressed in a chart. |
| `https://developers.google.com/apps-script/reference/charts/chart-options` | Exposes options currently configured for a `https://developers.google.com/apps-script/reference/charts/chart`, such as height, color, etc. |
| `https://developers.google.com/apps-script/reference/charts/chart-type` | Chart types supported by the Charts service. |
| `https://developers.google.com/apps-script/reference/charts/charts` | Entry point for creating Charts in scripts. |
| `https://developers.google.com/apps-script/reference/charts/column-chart-builder` | Builder for column charts. |
| `https://developers.google.com/apps-script/reference/charts/column-type` | An enumeration of the valid data types for columns in a `https://developers.google.com/apps-script/reference/charts/data-table`. |
| `https://developers.google.com/apps-script/reference/charts/curve-style` | An enumeration of the styles for curves in a chart. |
| `https://developers.google.com/apps-script/reference/charts/data-table` | A Data Table to be used in charts. |
| `https://developers.google.com/apps-script/reference/charts/data-table-builder` | Builder of DataTable objects. |
| `https://developers.google.com/apps-script/reference/charts/data-table-source` | Interface for objects that can represent their data as a `https://developers.google.com/apps-script/reference/charts/data-table`. |
| `https://developers.google.com/apps-script/reference/charts/data-view-definition` | A data view definition for visualizing chart data. |
| `https://developers.google.com/apps-script/reference/charts/data-view-definition-builder` | Builder for `https://developers.google.com/apps-script/reference/charts/data-view-definition` objects. |
| `https://developers.google.com/apps-script/reference/charts/line-chart-builder` | Builder for line charts. |
| `https://developers.google.com/apps-script/reference/charts/match-type` | An enumeration of how a string value should be matched. |
| `https://developers.google.com/apps-script/reference/charts/number-range-filter-builder` | A builder for number range filter controls. |
| `https://developers.google.com/apps-script/reference/charts/orientation` | An enumeration of the orientation of an object. |
| `https://developers.google.com/apps-script/reference/charts/picker-values-layout` | An enumeration of how to display selected values in picker widget. |
| `https://developers.google.com/apps-script/reference/charts/pie-chart-builder` | A builder for pie charts. |
| `https://developers.google.com/apps-script/reference/charts/point-style` | An enumeration of the styles of points in a line. |
| `https://developers.google.com/apps-script/reference/charts/position` | An enumeration of legend positions within a chart. |
| `https://developers.google.com/apps-script/reference/charts/scatter-chart-builder` | Builder for scatter charts. |
| `https://developers.google.com/apps-script/reference/charts/string-filter-builder` | A builder for string filter controls. |
| `https://developers.google.com/apps-script/reference/charts/table-chart-builder` | A builder for table charts. |
| `https://developers.google.com/apps-script/reference/charts/text-style` | A text style configuration object. |
| `https://developers.google.com/apps-script/reference/charts/text-style-builder` | A builder used to create `https://developers.google.com/apps-script/reference/charts/text-style` objects. |

## `https://developers.google.com/apps-script/reference/charts/area-chart-builder`

### Methods

| Method | Return type | Brief description |
|---|---|---|
| `https://developers.google.com/apps-script/reference/charts/area-chart-builder#build()` | `https://developers.google.com/apps-script/reference/charts/chart` | Builds the chart. |
| `https://developers.google.com/apps-script/reference/charts/area-chart-builder#reverseCategories()` | `https://developers.google.com/apps-script/reference/charts/area-chart-builder` | Reverses the drawing of series in the domain axis. |
| `https://developers.google.com/apps-script/reference/charts/area-chart-builder#setBackgroundColor(String)` | `https://developers.google.com/apps-script/reference/charts/area-chart-builder` | Sets the background color for the chart. |
| `https://developers.google.com/apps-script/reference/charts/area-chart-builder#setColors(String)` | `https://developers.google.com/apps-script/reference/charts/area-chart-builder` | Sets the colors for the lines in the chart. |
| `https://developers.google.com/apps-script/reference/charts/area-chart-builder#setDataSourceUrl(String)` | `https://developers.google.com/apps-script/reference/charts/area-chart-builder` | Sets the data source URL that is used to pull data in from an external source, such as Google Sheets. |
| `https://developers.google.com/apps-script/reference/charts/area-chart-builder#setDataTable(DataTableBuilder)` | `https://developers.google.com/apps-script/reference/charts/area-chart-builder` | Sets the data table to use for the chart using a DataTableBuilder. |
| `https://developers.google.com/apps-script/reference/charts/area-chart-builder#setDataTable(DataTableSource)` | `https://developers.google.com/apps-script/reference/charts/area-chart-builder` | Sets the data table which contains the lines for the chart, as well as the X-axis labels. |
| `https://developers.google.com/apps-script/reference/charts/area-chart-builder#setDataViewDefinition(DataViewDefinition)` | `https://developers.google.com/apps-script/reference/charts/area-chart-builder` | Sets the data view definition to use for the chart. |
| `https://developers.google.com/apps-script/reference/charts/area-chart-builder#setDimensions(Integer,Integer)` | `https://developers.google.com/apps-script/reference/charts/area-chart-builder` | Sets the dimensions for the chart. |
| `https://developers.google.com/apps-script/reference/charts/area-chart-builder#setLegendPosition(Position)` | `https://developers.google.com/apps-script/reference/charts/area-chart-builder` | Sets the position of the legend with respect to the chart. |
| `https://developers.google.com/apps-script/reference/charts/area-chart-builder#setLegendTextStyle(TextStyle)` | `https://developers.google.com/apps-script/reference/charts/area-chart-builder` | Sets the text style of the chart legend. |
| `https://developers.google.com/apps-script/reference/charts/area-chart-builder#setOption(String,Object)` | `https://developers.google.com/apps-script/reference/charts/area-chart-builder` | Sets advanced options for this chart. |
| `https://developers.google.com/apps-script/reference/charts/area-chart-builder#setPointStyle(PointStyle)` | `https://developers.google.com/apps-script/reference/charts/area-chart-builder` | Sets the style for points in the line. |
| `https://developers.google.com/apps-script/reference/charts/area-chart-builder#setRange(Number,Number)` | `https://developers.google.com/apps-script/reference/charts/area-chart-builder` | Sets the range for the chart. |
| `https://developers.google.com/apps-script/reference/charts/area-chart-builder#setStacked()` | `https://developers.google.com/apps-script/reference/charts/area-chart-builder` | Uses stacked lines, meaning that line and bar values are stacked (accumulated). |
| `https://developers.google.com/apps-script/reference/charts/area-chart-builder#setTitle(String)` | `https://developers.google.com/apps-script/reference/charts/area-chart-builder` | Sets the title of the chart. |
| `https://developers.google.com/apps-script/reference/charts/area-chart-builder#setTitleTextStyle(TextStyle)` | `https://developers.google.com/apps-script/reference/charts/area-chart-builder` | Sets the text style of the chart title. |
| `https://developers.google.com/apps-script/reference/charts/area-chart-builder#setXAxisTextStyle(TextStyle)` | `https://developers.google.com/apps-script/reference/charts/area-chart-builder` | Sets the horizontal axis text style. |
| `https://developers.google.com/apps-script/reference/charts/area-chart-builder#setXAxisTitle(String)` | `https://developers.google.com/apps-script/reference/charts/area-chart-builder` | Adds a title to the horizontal axis. |
| `https://developers.google.com/apps-script/reference/charts/area-chart-builder#setXAxisTitleTextStyle(TextStyle)` | `https://developers.google.com/apps-script/reference/charts/area-chart-builder` | Sets the horizontal axis title text style. |
| `https://developers.google.com/apps-script/reference/charts/area-chart-builder#setYAxisTextStyle(TextStyle)` | `https://developers.google.com/apps-script/reference/charts/area-chart-builder` | Sets the vertical axis text style. |
| `https://developers.google.com/apps-script/reference/charts/area-chart-builder#setYAxisTitle(String)` | `https://developers.google.com/apps-script/reference/charts/area-chart-builder` | Adds a title to the vertical axis. |
| `https://developers.google.com/apps-script/reference/charts/area-chart-builder#setYAxisTitleTextStyle(TextStyle)` | `https://developers.google.com/apps-script/reference/charts/area-chart-builder` | Sets the vertical axis title text style. |
| `https://developers.google.com/apps-script/reference/charts/area-chart-builder#useLogScale()` | `https://developers.google.com/apps-script/reference/charts/area-chart-builder` | Makes the range axis into a logarithmic scale (requires all values to be positive). |

## `https://developers.google.com/apps-script/reference/charts/bar-chart-builder`

### Methods

| Method | Return type | Brief description |
|---|---|---|
| `https://developers.google.com/apps-script/reference/charts/bar-chart-builder#build()` | `https://developers.google.com/apps-script/reference/charts/chart` | Builds the chart. |
| `https://developers.google.com/apps-script/reference/charts/bar-chart-builder#reverseCategories()` | `https://developers.google.com/apps-script/reference/charts/bar-chart-builder` | Reverses the drawing of series in the domain axis. |
| `https://developers.google.com/apps-script/reference/charts/bar-chart-builder#reverseDirection()` | `https://developers.google.com/apps-script/reference/charts/bar-chart-builder` | Reverses the direction in which the bars grow along the horizontal axis. |
| `https://developers.google.com/apps-script/reference/charts/bar-chart-builder#setBackgroundColor(String)` | `https://developers.google.com/apps-script/reference/charts/bar-chart-builder` | Sets the background color for the chart. |
| `https://developers.google.com/apps-script/reference/charts/bar-chart-builder#setColors(String)` | `https://developers.google.com/apps-script/reference/charts/bar-chart-builder` | Sets the colors for the lines in the chart. |
| `https://developers.google.com/apps-script/reference/charts/bar-chart-builder#setDataSourceUrl(String)` | `https://developers.google.com/apps-script/reference/charts/bar-chart-builder` | Sets the data source URL that is used to pull data in from an external source, such as Google Sheets. |
| `https://developers.google.com/apps-script/reference/charts/bar-chart-builder#setDataTable(DataTableBuilder)` | `https://developers.google.com/apps-script/reference/charts/bar-chart-builder` | Sets the data table to use for the chart using a DataTableBuilder. |
| `https://developers.google.com/apps-script/reference/charts/bar-chart-builder#setDataTable(DataTableSource)` | `https://developers.google.com/apps-script/reference/charts/bar-chart-builder` | Sets the data table which contains the lines for the chart, as well as the X-axis labels. |
| `https://developers.google.com/apps-script/reference/charts/bar-chart-builder#setDataViewDefinition(DataViewDefinition)` | `https://developers.google.com/apps-script/reference/charts/bar-chart-builder` | Sets the data view definition to use for the chart. |
| `https://developers.google.com/apps-script/reference/charts/bar-chart-builder#setDimensions(Integer,Integer)` | `https://developers.google.com/apps-script/reference/charts/bar-chart-builder` | Sets the dimensions for the chart. |
| `https://developers.google.com/apps-script/reference/charts/bar-chart-builder#setLegendPosition(Position)` | `https://developers.google.com/apps-script/reference/charts/bar-chart-builder` | Sets the position of the legend with respect to the chart. |
| `https://developers.google.com/apps-script/reference/charts/bar-chart-builder#setLegendTextStyle(TextStyle)` | `https://developers.google.com/apps-script/reference/charts/bar-chart-builder` | Sets the text style of the chart legend. |
| `https://developers.google.com/apps-script/reference/charts/bar-chart-builder#setOption(String,Object)` | `https://developers.google.com/apps-script/reference/charts/bar-chart-builder` | Sets advanced options for this chart. |
| `https://developers.google.com/apps-script/reference/charts/bar-chart-builder#setRange(Number,Number)` | `https://developers.google.com/apps-script/reference/charts/bar-chart-builder` | Sets the range for the chart. |
| `https://developers.google.com/apps-script/reference/charts/bar-chart-builder#setStacked()` | `https://developers.google.com/apps-script/reference/charts/bar-chart-builder` | Uses stacked lines, meaning that line and bar values are stacked (accumulated). |
| `https://developers.google.com/apps-script/reference/charts/bar-chart-builder#setTitle(String)` | `https://developers.google.com/apps-script/reference/charts/bar-chart-builder` | Sets the title of the chart. |
| `https://developers.google.com/apps-script/reference/charts/bar-chart-builder#setTitleTextStyle(TextStyle)` | `https://developers.google.com/apps-script/reference/charts/bar-chart-builder` | Sets the text style of the chart title. |
| `https://developers.google.com/apps-script/reference/charts/bar-chart-builder#setXAxisTextStyle(TextStyle)` | `https://developers.google.com/apps-script/reference/charts/bar-chart-builder` | Sets the horizontal axis text style. |
| `https://developers.google.com/apps-script/reference/charts/bar-chart-builder#setXAxisTitle(String)` | `https://developers.google.com/apps-script/reference/charts/bar-chart-builder` | Adds a title to the horizontal axis. |
| `https://developers.google.com/apps-script/reference/charts/bar-chart-builder#setXAxisTitleTextStyle(TextStyle)` | `https://developers.google.com/apps-script/reference/charts/bar-chart-builder` | Sets the horizontal axis title text style. |
| `https://developers.google.com/apps-script/reference/charts/bar-chart-builder#setYAxisTextStyle(TextStyle)` | `https://developers.google.com/apps-script/reference/charts/bar-chart-builder` | Sets the vertical axis text style. |
| `https://developers.google.com/apps-script/reference/charts/bar-chart-builder#setYAxisTitle(String)` | `https://developers.google.com/apps-script/reference/charts/bar-chart-builder` | Adds a title to the vertical axis. |
| `https://developers.google.com/apps-script/reference/charts/bar-chart-builder#setYAxisTitleTextStyle(TextStyle)` | `https://developers.google.com/apps-script/reference/charts/bar-chart-builder` | Sets the vertical axis title text style. |
| `https://developers.google.com/apps-script/reference/charts/bar-chart-builder#useLogScale()` | `https://developers.google.com/apps-script/reference/charts/bar-chart-builder` | Makes the range axis into a logarithmic scale (requires all values to be positive). |

## `https://developers.google.com/apps-script/reference/charts/chart`

### Methods

| Method | Return type | Brief description |
|---|---|---|
| `https://developers.google.com/apps-script/reference/charts/chart#getAs(String)` | `https://developers.google.com/apps-script/base/blob.html` | Return the data inside this object as a blob converted to the specified content type. |
| `https://developers.google.com/apps-script/reference/charts/chart#getBlob()` | `https://developers.google.com/apps-script/base/blob.html` | Return the data inside this object as a blob. |
| `https://developers.google.com/apps-script/reference/charts/chart#getOptions()` | `https://developers.google.com/apps-script/reference/charts/chart-options` | Returns the options for this chart, such as height, colors, and axes. |

## `https://developers.google.com/apps-script/reference/charts/chart-hidden-dimension-strategy`

### Properties

| Property | Type | Description |
|---|---|---|
| `IGNORE_BOTH` | `Enum` | Default; charts skips any hidden columns and hidden rows. |
| `IGNORE_ROWS` | `Enum` | Charts skips hidden rows only. |
| `IGNORE_COLUMNS` | `Enum` | Charts skips hidden columns only. |
| `SHOW_BOTH` | `Enum` | Charts does not skip hidden columns or hidden rows. |

## `https://developers.google.com/apps-script/reference/charts/chart-merge-strategy`

### Properties

| Property | Type | Description |
|---|---|---|
| `MERGE_COLUMNS` | `Enum` | Default. |
| `MERGE_ROWS` | `Enum` | Charts merges the rows of multiple ranges. |

## `https://developers.google.com/apps-script/reference/charts/chart-options`

### Methods

| Method | Return type | Brief description |
|---|---|---|
| `https://developers.google.com/apps-script/reference/charts/chart-options#get(String)` | `Object` | Returns a configured option for this chart. |
| `https://developers.google.com/apps-script/reference/charts/chart-options#getOrDefault(String)` | `Object` | Returns a configured option for this chart. |

## `https://developers.google.com/apps-script/reference/charts/chart-type`

### Properties

| Property | Type | Description |
|---|---|---|
| `TIMELINE` | `Enum` | Timeline chart. |
| `AREA` | `Enum` | Area chart |
| `BAR` | `Enum` | Bar chart |
| `BUBBLE` | `Enum` | Bubble chart. |
| `CANDLESTICK` | `Enum` | Candlestick chart. |
| `COLUMN` | `Enum` | Column chart |
| `COMBO` | `Enum` | Combo chart |
| `GAUGE` | `Enum` | Gauge chart. |
| `GEO` | `Enum` | Geo chart. |
| `HISTOGRAM` | `Enum` | Histogram |
| `RADAR` | `Enum` | Radar chart. |
| `LINE` | `Enum` | Line chart |
| `ORG` | `Enum` | Org chart. |
| `PIE` | `Enum` | Pie chart |
| `SCATTER` | `Enum` | Scatter chart |
| `SPARKLINE` | `Enum` | Sparkline chart. |
| `STEPPED_AREA` | `Enum` | Stepped area chart. |
| `TABLE` | `Enum` | Table chart |
| `TREEMAP` | `Enum` | Treemap chart. |
| `WATERFALL` | `Enum` | Waterfall chart. |

## `https://developers.google.com/apps-script/reference/charts/charts`

### Properties

| Property | Type | Description |
|---|---|---|
| `ChartHiddenDimensionStrategy` | `https://developers.google.com/apps-script/reference/charts/chart-hidden-dimension-strategy` | An enumeration of how hidden dimensions in a source are expressed in a chart. |
| `ChartMergeStrategy` | `https://developers.google.com/apps-script/reference/charts/chart-merge-strategy` | An enumeration of how multiple ranges in the source are expressed in a chart. |
| `ChartType` | `https://developers.google.com/apps-script/reference/charts/chart-type` | An enumeration of chart types supported by the Charts service. |
| `ColumnType` | `https://developers.google.com/apps-script/reference/charts/column-type` | An enumeration of the valid data types for columns in a `https://developers.google.com/apps-script/reference/charts/data-table`. |
| `CurveStyle` | `https://developers.google.com/apps-script/reference/charts/curve-style` | An enumeration of the styles for curves in a chart. |
| `PointStyle` | `https://developers.google.com/apps-script/reference/charts/point-style` | An enumeration of the styles of points in a line. |
| `Position` | `https://developers.google.com/apps-script/reference/charts/position` | An enumeration of legend positions within a chart. |

### Methods

| Method | Return type | Brief description |
|---|---|---|
| `https://developers.google.com/apps-script/reference/charts/charts#newAreaChart()` | `https://developers.google.com/apps-script/reference/charts/area-chart-builder` | Starts building an area chart, as described in the [Google Chart Tools](https://developers.google.com/chart/interactive/docs/gallery/areachart) documentation. |
| `https://developers.google.com/apps-script/reference/charts/charts#newBarChart()` | `https://developers.google.com/apps-script/reference/charts/bar-chart-builder` | Starts building a bar chart, as described in the [Google Chart Tools](https://developers.google.com/chart/interactive/docs/gallery/barchart) documentation. |
| `https://developers.google.com/apps-script/reference/charts/charts#newColumnChart()` | `https://developers.google.com/apps-script/reference/charts/column-chart-builder` | Starts building a column chart, as described in the [Google Chart Tools](https://developers.google.com/chart/interactive/docs/gallery/columnchart) documentation. |
| `https://developers.google.com/apps-script/reference/charts/charts#newDataTable()` | `https://developers.google.com/apps-script/reference/charts/data-table-builder` | Creates an empty data table, which can have its values set manually. |
| `https://developers.google.com/apps-script/reference/charts/charts#newDataViewDefinition()` | `https://developers.google.com/apps-script/reference/charts/data-view-definition-builder` | Creates a new data view definition. |
| `https://developers.google.com/apps-script/reference/charts/charts#newLineChart()` | `https://developers.google.com/apps-script/reference/charts/line-chart-builder` | Starts building a line chart, as described in the [Google Chart Tools](https://developers.google.com/chart/interactive/docs/gallery/linechart) documentation. |
| `https://developers.google.com/apps-script/reference/charts/charts#newPieChart()` | `https://developers.google.com/apps-script/reference/charts/pie-chart-builder` | Starts building a pie chart, as described in the [Google Chart Tools](https://developers.google.com/chart/interactive/docs/gallery/piechart) documentation. |
| `https://developers.google.com/apps-script/reference/charts/charts#newScatterChart()` | `https://developers.google.com/apps-script/reference/charts/scatter-chart-builder` | Starts building a scatter chart, as described in the [Google Chart Tools](https://developers.google.com/chart/interactive/docs/gallery/scatterchart) documentation. |
| `https://developers.google.com/apps-script/reference/charts/charts#newTableChart()` | `https://developers.google.com/apps-script/reference/charts/table-chart-builder` | Starts building a table chart, as described in the [Google Chart Tools](https://developers.google.com/chart/interactive/docs/gallery/table) documentation. |
| `https://developers.google.com/apps-script/reference/charts/charts#newTextStyle()` | `https://developers.google.com/apps-script/reference/charts/text-style-builder` | Creates a new text style builder. |

## `https://developers.google.com/apps-script/reference/charts/column-chart-builder`

### Methods

| Method | Return type | Brief description |
|---|---|---|
| `https://developers.google.com/apps-script/reference/charts/column-chart-builder#build()` | `https://developers.google.com/apps-script/reference/charts/chart` | Builds the chart. |
| `https://developers.google.com/apps-script/reference/charts/column-chart-builder#reverseCategories()` | `https://developers.google.com/apps-script/reference/charts/column-chart-builder` | Reverses the drawing of series in the domain axis. |
| `https://developers.google.com/apps-script/reference/charts/column-chart-builder#setBackgroundColor(String)` | `https://developers.google.com/apps-script/reference/charts/column-chart-builder` | Sets the background color for the chart. |
| `https://developers.google.com/apps-script/reference/charts/column-chart-builder#setColors(String)` | `https://developers.google.com/apps-script/reference/charts/column-chart-builder` | Sets the colors for the lines in the chart. |
| `https://developers.google.com/apps-script/reference/charts/column-chart-builder#setDataSourceUrl(String)` | `https://developers.google.com/apps-script/reference/charts/column-chart-builder` | Sets the data source URL that is used to pull data in from an external source, such as Google Sheets. |
| `https://developers.google.com/apps-script/reference/charts/column-chart-builder#setDataTable(DataTableBuilder)` | `https://developers.google.com/apps-script/reference/charts/column-chart-builder` | Sets the data table to use for the chart using a DataTableBuilder. |
| `https://developers.google.com/apps-script/reference/charts/column-chart-builder#setDataTable(DataTableSource)` | `https://developers.google.com/apps-script/reference/charts/column-chart-builder` | Sets the data table which contains the lines for the chart, as well as the X-axis labels. |
| `https://developers.google.com/apps-script/reference/charts/column-chart-builder#setDataViewDefinition(DataViewDefinition)` | `https://developers.google.com/apps-script/reference/charts/column-chart-builder` | Sets the data view definition to use for the chart. |
| `https://developers.google.com/apps-script/reference/charts/column-chart-builder#setDimensions(Integer,Integer)` | `https://developers.google.com/apps-script/reference/charts/column-chart-builder` | Sets the dimensions for the chart. |
| `https://developers.google.com/apps-script/reference/charts/column-chart-builder#setLegendPosition(Position)` | `https://developers.google.com/apps-script/reference/charts/column-chart-builder` | Sets the position of the legend with respect to the chart. |
| `https://developers.google.com/apps-script/reference/charts/column-chart-builder#setLegendTextStyle(TextStyle)` | `https://developers.google.com/apps-script/reference/charts/column-chart-builder` | Sets the text style of the chart legend. |
| `https://developers.google.com/apps-script/reference/charts/column-chart-builder#setOption(String,Object)` | `https://developers.google.com/apps-script/reference/charts/column-chart-builder` | Sets advanced options for this chart. |
| `https://developers.google.com/apps-script/reference/charts/column-chart-builder#setRange(Number,Number)` | `https://developers.google.com/apps-script/reference/charts/column-chart-builder` | Sets the range for the chart. |
| `https://developers.google.com/apps-script/reference/charts/column-chart-builder#setStacked()` | `https://developers.google.com/apps-script/reference/charts/column-chart-builder` | Uses stacked lines, meaning that line and bar values are stacked (accumulated). |
| `https://developers.google.com/apps-script/reference/charts/column-chart-builder#setTitle(String)` | `https://developers.google.com/apps-script/reference/charts/column-chart-builder` | Sets the title of the chart. |
| `https://developers.google.com/apps-script/reference/charts/column-chart-builder#setTitleTextStyle(TextStyle)` | `https://developers.google.com/apps-script/reference/charts/column-chart-builder` | Sets the text style of the chart title. |
| `https://developers.google.com/apps-script/reference/charts/column-chart-builder#setXAxisTextStyle(TextStyle)` | `https://developers.google.com/apps-script/reference/charts/column-chart-builder` | Sets the horizontal axis text style. |
| `https://developers.google.com/apps-script/reference/charts/column-chart-builder#setXAxisTitle(String)` | `https://developers.google.com/apps-script/reference/charts/column-chart-builder` | Adds a title to the horizontal axis. |
| `https://developers.google.com/apps-script/reference/charts/column-chart-builder#setXAxisTitleTextStyle(TextStyle)` | `https://developers.google.com/apps-script/reference/charts/column-chart-builder` | Sets the horizontal axis title text style. |
| `https://developers.google.com/apps-script/reference/charts/column-chart-builder#setYAxisTextStyle(TextStyle)` | `https://developers.google.com/apps-script/reference/charts/column-chart-builder` | Sets the vertical axis text style. |
| `https://developers.google.com/apps-script/reference/charts/column-chart-builder#setYAxisTitle(String)` | `https://developers.google.com/apps-script/reference/charts/column-chart-builder` | Adds a title to the vertical axis. |
| `https://developers.google.com/apps-script/reference/charts/column-chart-builder#setYAxisTitleTextStyle(TextStyle)` | `https://developers.google.com/apps-script/reference/charts/column-chart-builder` | Sets the vertical axis title text style. |
| `https://developers.google.com/apps-script/reference/charts/column-chart-builder#useLogScale()` | `https://developers.google.com/apps-script/reference/charts/column-chart-builder` | Makes the range axis into a logarithmic scale (requires all values to be positive). |

## `https://developers.google.com/apps-script/reference/charts/column-type`

### Properties

| Property | Type | Description |
|---|---|---|
| `DATE` | `Enum` | Corresponds to date values. |
| `NUMBER` | `Enum` | Corresponds to number values. |
| `STRING` | `Enum` | Corresponds to string values. |

## `https://developers.google.com/apps-script/reference/charts/curve-style`

### Properties

| Property | Type | Description |
|---|---|---|
| `NORMAL` | `Enum` | Straight lines without curve. |
| `SMOOTH` | `Enum` | The angles of the line are smoothed. |

## `https://developers.google.com/apps-script/reference/charts/data-table`

## `https://developers.google.com/apps-script/reference/charts/data-table-builder`

### Methods

| Method | Return type | Brief description |
|---|---|---|
| `https://developers.google.com/apps-script/reference/charts/data-table-builder#addColumn(ColumnType,String)` | `https://developers.google.com/apps-script/reference/charts/data-table-builder` | Adds a column to the data table. |
| `https://developers.google.com/apps-script/reference/charts/data-table-builder#addRow(Object)` | `https://developers.google.com/apps-script/reference/charts/data-table-builder` | Adds a row to the data table. |
| `https://developers.google.com/apps-script/reference/charts/data-table-builder#build()` | `https://developers.google.com/apps-script/reference/charts/data-table` | Builds and returns a data table. |
| `https://developers.google.com/apps-script/reference/charts/data-table-builder#setValue(Integer,Integer,Object)` | `https://developers.google.com/apps-script/reference/charts/data-table-builder` | Sets a specific value in the table. |

## `https://developers.google.com/apps-script/reference/charts/data-table-source`

### Methods

| Method | Return type | Brief description |
|---|---|---|
| `https://developers.google.com/apps-script/reference/charts/data-table-source#getDataTable()` | `https://developers.google.com/apps-script/reference/charts/data-table` | Return the data inside this object as a DataTable. |

## `https://developers.google.com/apps-script/reference/charts/data-view-definition`

## `https://developers.google.com/apps-script/reference/charts/data-view-definition-builder`

### Methods

| Method | Return type | Brief description |
|---|---|---|
| `https://developers.google.com/apps-script/reference/charts/data-view-definition-builder#build()` | `https://developers.google.com/apps-script/reference/charts/data-view-definition` | Builds and returns the data view definition object that was built using this builder. |
| `https://developers.google.com/apps-script/reference/charts/data-view-definition-builder#setColumns(Object)` | `https://developers.google.com/apps-script/reference/charts/data-view-definition-builder` | Sets the indexes of the columns to include in the data view as well as specifying role-column information. |

## `https://developers.google.com/apps-script/reference/charts/line-chart-builder`

### Methods

| Method | Return type | Brief description |
|---|---|---|
| `https://developers.google.com/apps-script/reference/charts/line-chart-builder#build()` | `https://developers.google.com/apps-script/reference/charts/chart` | Builds the chart. |
| `https://developers.google.com/apps-script/reference/charts/line-chart-builder#reverseCategories()` | `https://developers.google.com/apps-script/reference/charts/line-chart-builder` | Reverses the drawing of series in the domain axis. |
| `https://developers.google.com/apps-script/reference/charts/line-chart-builder#setBackgroundColor(String)` | `https://developers.google.com/apps-script/reference/charts/line-chart-builder` | Sets the background color for the chart. |
| `https://developers.google.com/apps-script/reference/charts/line-chart-builder#setColors(String)` | `https://developers.google.com/apps-script/reference/charts/line-chart-builder` | Sets the colors for the lines in the chart. |
| `https://developers.google.com/apps-script/reference/charts/line-chart-builder#setCurveStyle(CurveStyle)` | `https://developers.google.com/apps-script/reference/charts/line-chart-builder` | Sets the style to use for curves in the chart. |
| `https://developers.google.com/apps-script/reference/charts/line-chart-builder#setDataSourceUrl(String)` | `https://developers.google.com/apps-script/reference/charts/line-chart-builder` | Sets the data source URL that is used to pull data in from an external source, such as Google Sheets. |
| `https://developers.google.com/apps-script/reference/charts/line-chart-builder#setDataTable(DataTableBuilder)` | `https://developers.google.com/apps-script/reference/charts/line-chart-builder` | Sets the data table to use for the chart using a DataTableBuilder. |
| `https://developers.google.com/apps-script/reference/charts/line-chart-builder#setDataTable(DataTableSource)` | `https://developers.google.com/apps-script/reference/charts/line-chart-builder` | Sets the data table which contains the lines for the chart, as well as the X-axis labels. |
| `https://developers.google.com/apps-script/reference/charts/line-chart-builder#setDataViewDefinition(DataViewDefinition)` | `https://developers.google.com/apps-script/reference/charts/line-chart-builder` | Sets the data view definition to use for the chart. |
| `https://developers.google.com/apps-script/reference/charts/line-chart-builder#setDimensions(Integer,Integer)` | `https://developers.google.com/apps-script/reference/charts/line-chart-builder` | Sets the dimensions for the chart. |
| `https://developers.google.com/apps-script/reference/charts/line-chart-builder#setLegendPosition(Position)` | `https://developers.google.com/apps-script/reference/charts/line-chart-builder` | Sets the position of the legend with respect to the chart. |
| `https://developers.google.com/apps-script/reference/charts/line-chart-builder#setLegendTextStyle(TextStyle)` | `https://developers.google.com/apps-script/reference/charts/line-chart-builder` | Sets the text style of the chart legend. |
| `https://developers.google.com/apps-script/reference/charts/line-chart-builder#setOption(String,Object)` | `https://developers.google.com/apps-script/reference/charts/line-chart-builder` | Sets advanced options for this chart. |
| `https://developers.google.com/apps-script/reference/charts/line-chart-builder#setPointStyle(PointStyle)` | `https://developers.google.com/apps-script/reference/charts/line-chart-builder` | Sets the style for points in the line. |
| `https://developers.google.com/apps-script/reference/charts/line-chart-builder#setRange(Number,Number)` | `https://developers.google.com/apps-script/reference/charts/line-chart-builder` | Sets the range for the chart. |
| `https://developers.google.com/apps-script/reference/charts/line-chart-builder#setTitle(String)` | `https://developers.google.com/apps-script/reference/charts/line-chart-builder` | Sets the title of the chart. |
| `https://developers.google.com/apps-script/reference/charts/line-chart-builder#setTitleTextStyle(TextStyle)` | `https://developers.google.com/apps-script/reference/charts/line-chart-builder` | Sets the text style of the chart title. |
| `https://developers.google.com/apps-script/reference/charts/line-chart-builder#setXAxisTextStyle(TextStyle)` | `https://developers.google.com/apps-script/reference/charts/line-chart-builder` | Sets the horizontal axis text style. |
| `https://developers.google.com/apps-script/reference/charts/line-chart-builder#setXAxisTitle(String)` | `https://developers.google.com/apps-script/reference/charts/line-chart-builder` | Adds a title to the horizontal axis. |
| `https://developers.google.com/apps-script/reference/charts/line-chart-builder#setXAxisTitleTextStyle(TextStyle)` | `https://developers.google.com/apps-script/reference/charts/line-chart-builder` | Sets the horizontal axis title text style. |
| `https://developers.google.com/apps-script/reference/charts/line-chart-builder#setYAxisTextStyle(TextStyle)` | `https://developers.google.com/apps-script/reference/charts/line-chart-builder` | Sets the vertical axis text style. |
| `https://developers.google.com/apps-script/reference/charts/line-chart-builder#setYAxisTitle(String)` | `https://developers.google.com/apps-script/reference/charts/line-chart-builder` | Adds a title to the vertical axis. |
| `https://developers.google.com/apps-script/reference/charts/line-chart-builder#setYAxisTitleTextStyle(TextStyle)` | `https://developers.google.com/apps-script/reference/charts/line-chart-builder` | Sets the vertical axis title text style. |
| `https://developers.google.com/apps-script/reference/charts/line-chart-builder#useLogScale()` | `https://developers.google.com/apps-script/reference/charts/line-chart-builder` | Makes the range axis into a logarithmic scale (requires all values to be positive). |

## `https://developers.google.com/apps-script/reference/charts/match-type`

### Properties

| Property | Type | Description |
|---|---|---|
| `EXACT` | `Enum` | Match exact values only |
| `PREFIX` | `Enum` | Match prefixes starting from the beginning of the value |
| `ANY` | `Enum` | Match any substring |

### Methods

| Method | Return type | Brief description |
|---|---|---|
| `https://developers.google.com/apps-script/reference/charts/match-type#getName()` | `String` | Returns the name of the match type to be used in the options JSON. |

## `https://developers.google.com/apps-script/reference/charts/number-range-filter-builder`

### Methods

| Method | Return type | Brief description |
|---|---|---|
| `https://developers.google.com/apps-script/reference/charts/number-range-filter-builder#setMaxValue(Integer)` | `https://developers.google.com/apps-script/reference/charts/number-range-filter-builder` | Sets the maximum allowed value for the range lower extent. |
| `https://developers.google.com/apps-script/reference/charts/number-range-filter-builder#setMinValue(Integer)` | `https://developers.google.com/apps-script/reference/charts/number-range-filter-builder` | Sets the minimum allowed value for the range lower extent. |
| `https://developers.google.com/apps-script/reference/charts/number-range-filter-builder#setOrientation(Orientation)` | `https://developers.google.com/apps-script/reference/charts/number-range-filter-builder` | Sets the slider orientation. |
| `https://developers.google.com/apps-script/reference/charts/number-range-filter-builder#setShowRangeValues(Boolean)` | `https://developers.google.com/apps-script/reference/charts/number-range-filter-builder` | Sets whether to have labels next to the slider displaying extents of the selected range. |
| `https://developers.google.com/apps-script/reference/charts/number-range-filter-builder#setTicks(Integer)` | `https://developers.google.com/apps-script/reference/charts/number-range-filter-builder` | Sets the number of ticks (fixed positions in a range bar) a number range filter slider thumbs can fall in. |

## `https://developers.google.com/apps-script/reference/charts/orientation`

### Properties

| Property | Type | Description |
|---|---|---|
| `HORIZONTAL` | `Enum` | Horizontal orientation. |
| `VERTICAL` | `Enum` | Vertical orientation. |

## `https://developers.google.com/apps-script/reference/charts/picker-values-layout`

### Properties

| Property | Type | Description |
|---|---|---|
| `ASIDE` | `Enum` | Selected values display in a single text line next to the value picker widget. |
| `BELOW` | `Enum` | Selected values display in a single text line below the widget. |
| `BELOW_WRAPPING` | `Enum` | Similar to below, but entries that cannot fit in the picker wrap to a new line. |
| `BELOW_STACKED` | `Enum` | Selected values display in a column below the widget. |

## `https://developers.google.com/apps-script/reference/charts/pie-chart-builder`

### Methods

| Method | Return type | Brief description |
|---|---|---|
| `https://developers.google.com/apps-script/reference/charts/pie-chart-builder#build()` | `https://developers.google.com/apps-script/reference/charts/chart` | Builds the chart. |
| `https://developers.google.com/apps-script/reference/charts/pie-chart-builder#reverseCategories()` | `https://developers.google.com/apps-script/reference/charts/pie-chart-builder` | Reverses the drawing of series in the domain axis. |
| `https://developers.google.com/apps-script/reference/charts/pie-chart-builder#set3D()` | `https://developers.google.com/apps-script/reference/charts/pie-chart-builder` | Sets the chart to be three-dimensional. |
| `https://developers.google.com/apps-script/reference/charts/pie-chart-builder#setBackgroundColor(String)` | `https://developers.google.com/apps-script/reference/charts/pie-chart-builder` | Sets the background color for the chart. |
| `https://developers.google.com/apps-script/reference/charts/pie-chart-builder#setColors(String)` | `https://developers.google.com/apps-script/reference/charts/pie-chart-builder` | Sets the colors for the lines in the chart. |
| `https://developers.google.com/apps-script/reference/charts/pie-chart-builder#setDataSourceUrl(String)` | `https://developers.google.com/apps-script/reference/charts/pie-chart-builder` | Sets the data source URL that is used to pull data in from an external source, such as Google Sheets. |
| `https://developers.google.com/apps-script/reference/charts/pie-chart-builder#setDataTable(DataTableBuilder)` | `https://developers.google.com/apps-script/reference/charts/pie-chart-builder` | Sets the data table to use for the chart using a DataTableBuilder. |
| `https://developers.google.com/apps-script/reference/charts/pie-chart-builder#setDataTable(DataTableSource)` | `https://developers.google.com/apps-script/reference/charts/pie-chart-builder` | Sets the data table which contains the lines for the chart, as well as the X-axis labels. |
| `https://developers.google.com/apps-script/reference/charts/pie-chart-builder#setDataViewDefinition(DataViewDefinition)` | `https://developers.google.com/apps-script/reference/charts/pie-chart-builder` | Sets the data view definition to use for the chart. |
| `https://developers.google.com/apps-script/reference/charts/pie-chart-builder#setDimensions(Integer,Integer)` | `https://developers.google.com/apps-script/reference/charts/pie-chart-builder` | Sets the dimensions for the chart. |
| `https://developers.google.com/apps-script/reference/charts/pie-chart-builder#setLegendPosition(Position)` | `https://developers.google.com/apps-script/reference/charts/pie-chart-builder` | Sets the position of the legend with respect to the chart. |
| `https://developers.google.com/apps-script/reference/charts/pie-chart-builder#setLegendTextStyle(TextStyle)` | `https://developers.google.com/apps-script/reference/charts/pie-chart-builder` | Sets the text style of the chart legend. |
| `https://developers.google.com/apps-script/reference/charts/pie-chart-builder#setOption(String,Object)` | `https://developers.google.com/apps-script/reference/charts/pie-chart-builder` | Sets advanced options for this chart. |
| `https://developers.google.com/apps-script/reference/charts/pie-chart-builder#setTitle(String)` | `https://developers.google.com/apps-script/reference/charts/pie-chart-builder` | Sets the title of the chart. |
| `https://developers.google.com/apps-script/reference/charts/pie-chart-builder#setTitleTextStyle(TextStyle)` | `https://developers.google.com/apps-script/reference/charts/pie-chart-builder` | Sets the text style of the chart title. |

## `https://developers.google.com/apps-script/reference/charts/point-style`

### Properties

| Property | Type | Description |
|---|---|---|
| `NONE` | `Enum` | Do not display line points. |
| `TINY` | `Enum` | Use tiny line points. |
| `MEDIUM` | `Enum` | Use medium sized line points. |
| `LARGE` | `Enum` | Use large sized line points. |
| `HUGE` | `Enum` | Use largest sized line points. |

## `https://developers.google.com/apps-script/reference/charts/position`

### Properties

| Property | Type | Description |
|---|---|---|
| `TOP` | `Enum` | Above the chart. |
| `RIGHT` | `Enum` | To the right of the chart. |
| `BOTTOM` | `Enum` | Below the chart. |
| `NONE` | `Enum` | No legend is displayed. |

## `https://developers.google.com/apps-script/reference/charts/scatter-chart-builder`

### Methods

| Method | Return type | Brief description |
|---|---|---|
| `https://developers.google.com/apps-script/reference/charts/scatter-chart-builder#build()` | `https://developers.google.com/apps-script/reference/charts/chart` | Builds the chart. |
| `https://developers.google.com/apps-script/reference/charts/scatter-chart-builder#setBackgroundColor(String)` | `https://developers.google.com/apps-script/reference/charts/scatter-chart-builder` | Sets the background color for the chart. |
| `https://developers.google.com/apps-script/reference/charts/scatter-chart-builder#setColors(String)` | `https://developers.google.com/apps-script/reference/charts/scatter-chart-builder` | Sets the colors for the lines in the chart. |
| `https://developers.google.com/apps-script/reference/charts/scatter-chart-builder#setDataSourceUrl(String)` | `https://developers.google.com/apps-script/reference/charts/scatter-chart-builder` | Sets the data source URL that is used to pull data in from an external source, such as Google Sheets. |
| `https://developers.google.com/apps-script/reference/charts/scatter-chart-builder#setDataTable(DataTableBuilder)` | `https://developers.google.com/apps-script/reference/charts/scatter-chart-builder` | Sets the data table to use for the chart using a DataTableBuilder. |
| `https://developers.google.com/apps-script/reference/charts/scatter-chart-builder#setDataTable(DataTableSource)` | `https://developers.google.com/apps-script/reference/charts/scatter-chart-builder` | Sets the data table which contains the lines for the chart, as well as the X-axis labels. |
| `https://developers.google.com/apps-script/reference/charts/scatter-chart-builder#setDataViewDefinition(DataViewDefinition)` | `https://developers.google.com/apps-script/reference/charts/scatter-chart-builder` | Sets the data view definition to use for the chart. |
| `https://developers.google.com/apps-script/reference/charts/scatter-chart-builder#setDimensions(Integer,Integer)` | `https://developers.google.com/apps-script/reference/charts/scatter-chart-builder` | Sets the dimensions for the chart. |
| `https://developers.google.com/apps-script/reference/charts/scatter-chart-builder#setLegendPosition(Position)` | `https://developers.google.com/apps-script/reference/charts/scatter-chart-builder` | Sets the position of the legend with respect to the chart. |
| `https://developers.google.com/apps-script/reference/charts/scatter-chart-builder#setLegendTextStyle(TextStyle)` | `https://developers.google.com/apps-script/reference/charts/scatter-chart-builder` | Sets the text style of the chart legend. |
| `https://developers.google.com/apps-script/reference/charts/scatter-chart-builder#setOption(String,Object)` | `https://developers.google.com/apps-script/reference/charts/scatter-chart-builder` | Sets advanced options for this chart. |
| `https://developers.google.com/apps-script/reference/charts/scatter-chart-builder#setPointStyle(PointStyle)` | `https://developers.google.com/apps-script/reference/charts/scatter-chart-builder` | Sets the style for points in the line. |
| `https://developers.google.com/apps-script/reference/charts/scatter-chart-builder#setTitle(String)` | `https://developers.google.com/apps-script/reference/charts/scatter-chart-builder` | Sets the title of the chart. |
| `https://developers.google.com/apps-script/reference/charts/scatter-chart-builder#setTitleTextStyle(TextStyle)` | `https://developers.google.com/apps-script/reference/charts/scatter-chart-builder` | Sets the text style of the chart title. |
| `https://developers.google.com/apps-script/reference/charts/scatter-chart-builder#setXAxisLogScale()` | `https://developers.google.com/apps-script/reference/charts/scatter-chart-builder` | Makes the horizontal axis into a logarithmic scale (requires all values to be positive). |
| `https://developers.google.com/apps-script/reference/charts/scatter-chart-builder#setXAxisRange(Number,Number)` | `https://developers.google.com/apps-script/reference/charts/scatter-chart-builder` | Sets the range for the horizontal axis of the chart. |
| `https://developers.google.com/apps-script/reference/charts/scatter-chart-builder#setXAxisTextStyle(TextStyle)` | `https://developers.google.com/apps-script/reference/charts/scatter-chart-builder` | Sets the horizontal axis text style. |
| `https://developers.google.com/apps-script/reference/charts/scatter-chart-builder#setXAxisTitle(String)` | `https://developers.google.com/apps-script/reference/charts/scatter-chart-builder` | Adds a title to the horizontal axis. |
| `https://developers.google.com/apps-script/reference/charts/scatter-chart-builder#setXAxisTitleTextStyle(TextStyle)` | `https://developers.google.com/apps-script/reference/charts/scatter-chart-builder` | Sets the horizontal axis title text style. |
| `https://developers.google.com/apps-script/reference/charts/scatter-chart-builder#setYAxisLogScale()` | `https://developers.google.com/apps-script/reference/charts/scatter-chart-builder` | Makes the vertical axis into a logarithmic scale (requires all values to be positive). |
| `https://developers.google.com/apps-script/reference/charts/scatter-chart-builder#setYAxisRange(Number,Number)` | `https://developers.google.com/apps-script/reference/charts/scatter-chart-builder` | Sets the range for the vertical axis of the chart. |
| `https://developers.google.com/apps-script/reference/charts/scatter-chart-builder#setYAxisTextStyle(TextStyle)` | `https://developers.google.com/apps-script/reference/charts/scatter-chart-builder` | Sets the vertical axis text style. |
| `https://developers.google.com/apps-script/reference/charts/scatter-chart-builder#setYAxisTitle(String)` | `https://developers.google.com/apps-script/reference/charts/scatter-chart-builder` | Adds a title to the vertical axis. |
| `https://developers.google.com/apps-script/reference/charts/scatter-chart-builder#setYAxisTitleTextStyle(TextStyle)` | `https://developers.google.com/apps-script/reference/charts/scatter-chart-builder` | Sets the vertical axis title text style. |

## `https://developers.google.com/apps-script/reference/charts/string-filter-builder`

### Methods

| Method | Return type | Brief description |
|---|---|---|
| `https://developers.google.com/apps-script/reference/charts/string-filter-builder#setCaseSensitive(Boolean)` | `https://developers.google.com/apps-script/reference/charts/string-filter-builder` | Sets whether matching should be case sensitive or not. |
| `https://developers.google.com/apps-script/reference/charts/string-filter-builder#setMatchType(MatchType)` | `https://developers.google.com/apps-script/reference/charts/string-filter-builder` | Sets whether the control should match exact values only (`https://developers.google.com/apps-script/reference/charts/match-type#EXACT`), prefixes starting from the beginning of the value (`https://developers.google.com/apps-script/reference/charts/match-type#PREFIX`), or any substring (`https://developers.google.com/apps-script/reference/charts/match-type#ANY`). |
| `https://developers.google.com/apps-script/reference/charts/string-filter-builder#setRealtimeTrigger(Boolean)` | `https://developers.google.com/apps-script/reference/charts/string-filter-builder` | Sets whether the control should match any time a key is pressed or only when the input field 'changes' (loss of focus or pressing the Enter key). |

## `https://developers.google.com/apps-script/reference/charts/table-chart-builder`

### Methods

| Method | Return type | Brief description |
|---|---|---|
| `https://developers.google.com/apps-script/reference/charts/table-chart-builder#build()` | `https://developers.google.com/apps-script/reference/charts/chart` | Builds the chart. |
| `https://developers.google.com/apps-script/reference/charts/table-chart-builder#enablePaging(Boolean)` | `https://developers.google.com/apps-script/reference/charts/table-chart-builder` | Sets whether to enable paging through the data. |
| `https://developers.google.com/apps-script/reference/charts/table-chart-builder#enablePaging(Integer)` | `https://developers.google.com/apps-script/reference/charts/table-chart-builder` | Enables paging and sets the number of rows in each page. |
| `https://developers.google.com/apps-script/reference/charts/table-chart-builder#enablePaging(Integer,Integer)` | `https://developers.google.com/apps-script/reference/charts/table-chart-builder` | Enables paging, sets the number of rows in each page and the first table page to display (page numbers are zero based). |
| `https://developers.google.com/apps-script/reference/charts/table-chart-builder#enableRtlTable(Boolean)` | `https://developers.google.com/apps-script/reference/charts/table-chart-builder` | Adds basic support for right-to-left languages (such as Arabic or Hebrew) by reversing the column order of the table, so that column zero is the right-most column, and the last column is the left-most column. |
| `https://developers.google.com/apps-script/reference/charts/table-chart-builder#enableSorting(Boolean)` | `https://developers.google.com/apps-script/reference/charts/table-chart-builder` | Sets whether to sort columns when the user clicks a column heading. |
| `https://developers.google.com/apps-script/reference/charts/table-chart-builder#setDataSourceUrl(String)` | `https://developers.google.com/apps-script/reference/charts/table-chart-builder` | Sets the data source URL that is used to pull data in from an external source, such as Google Sheets. |
| `https://developers.google.com/apps-script/reference/charts/table-chart-builder#setDataTable(DataTableBuilder)` | `https://developers.google.com/apps-script/reference/charts/table-chart-builder` | Sets the data table to use for the chart using a DataTableBuilder. |
| `https://developers.google.com/apps-script/reference/charts/table-chart-builder#setDataTable(DataTableSource)` | `https://developers.google.com/apps-script/reference/charts/table-chart-builder` | Sets the data table which contains the lines for the chart, as well as the X-axis labels. |
| `https://developers.google.com/apps-script/reference/charts/table-chart-builder#setDataViewDefinition(DataViewDefinition)` | `https://developers.google.com/apps-script/reference/charts/table-chart-builder` | Sets the data view definition to use for the chart. |
| `https://developers.google.com/apps-script/reference/charts/table-chart-builder#setDimensions(Integer,Integer)` | `https://developers.google.com/apps-script/reference/charts/table-chart-builder` | Sets the dimensions for the chart. |
| `https://developers.google.com/apps-script/reference/charts/table-chart-builder#setFirstRowNumber(Integer)` | `https://developers.google.com/apps-script/reference/charts/table-chart-builder` | Sets the row number for the first row in the data table. |
| `https://developers.google.com/apps-script/reference/charts/table-chart-builder#setInitialSortingAscending(Integer)` | `https://developers.google.com/apps-script/reference/charts/table-chart-builder` | Sets the index of the column according to which the table should be initially sorted (ascending). |
| `https://developers.google.com/apps-script/reference/charts/table-chart-builder#setInitialSortingDescending(Integer)` | `https://developers.google.com/apps-script/reference/charts/table-chart-builder` | Sets the index of the column according to which the table should be initially sorted (descending). |
| `https://developers.google.com/apps-script/reference/charts/table-chart-builder#setOption(String,Object)` | `https://developers.google.com/apps-script/reference/charts/table-chart-builder` | Sets advanced options for this chart. |
| `https://developers.google.com/apps-script/reference/charts/table-chart-builder#showRowNumberColumn(Boolean)` | `https://developers.google.com/apps-script/reference/charts/table-chart-builder` | Sets whether to show the row number as the first column of the table. |
| `https://developers.google.com/apps-script/reference/charts/table-chart-builder#useAlternatingRowStyle(Boolean)` | `https://developers.google.com/apps-script/reference/charts/table-chart-builder` | Sets whether alternating color style is assigned to odd and even rows of a table chart. |

## `https://developers.google.com/apps-script/reference/charts/text-style`

### Methods

| Method | Return type | Brief description |
|---|---|---|
| `https://developers.google.com/apps-script/reference/charts/text-style#getColor()` | `String` | Gets the color of the text style. |
| `https://developers.google.com/apps-script/reference/charts/text-style#getFontName()` | `String` | Gets the font name of the text style. |
| `https://developers.google.com/apps-script/reference/charts/text-style#getFontSize()` | `Number` | Gets the font size of the text style. |

## `https://developers.google.com/apps-script/reference/charts/text-style-builder`

### Methods

| Method | Return type | Brief description |
|---|---|---|
| `https://developers.google.com/apps-script/reference/charts/text-style-builder#build()` | `https://developers.google.com/apps-script/reference/charts/text-style` | Builds and returns a text style configuration object that was built using this builder. |
| `https://developers.google.com/apps-script/reference/charts/text-style-builder#setColor(String)` | `https://developers.google.com/apps-script/reference/charts/text-style-builder` | Sets the color of the text style. |
| `https://developers.google.com/apps-script/reference/charts/text-style-builder#setFontName(String)` | `https://developers.google.com/apps-script/reference/charts/text-style-builder` | Sets the font name of the text style. |
| `https://developers.google.com/apps-script/reference/charts/text-style-builder#setFontSize(Number)` | `https://developers.google.com/apps-script/reference/charts/text-style-builder` | Sets the font size of the text style. |