Charts Service

AI-generated Key Takeaways

The Google Apps Script Charts Service enables server-side rendering of charts using Google Charts Tools, offering an alternative to the client-side Google Charts API.
Charts are built using a structured process involving data table creation, chart construction with specific configurations like type, data source, and styling, and HTML output generation for display.
The Charts Service provides a range of chart types, including AreaChart, BarChart, ColumnChart, LineChart, PieChart, ScatterChart, and TableChart, each with corresponding builder classes for customization.
Comprehensive documentation details various classes and methods for data manipulation, visual styling, axes configuration, and interactive element creation, empowering developers to tailor charts to their needs.
Developers can leverage methods from ScatterChartBuilder, StringFilterBuilder, TableChartBuilder, TextStyle, and TextStyleBuilder to fine-tune chart axes, filtering, table layouts, and text styles, enhancing chart customization and functionality.

This service allows users to create charts using Google Charts Tools and render them server side. If you want to render charts in a web browser, use the Google Charts API 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
`AreaChartBuilder`	Builder for area charts.
`BarChartBuilder`	Builder for bar charts.
`Chart`	A Chart object, which can be converted to a static image.
`ChartHiddenDimensionStrategy`	An enumeration of how hidden dimensions in a source are expressed in a chart.
`ChartMergeStrategy`	An enumeration of how multiple ranges in the source are expressed in a chart.
`ChartOptions`	Exposes options currently configured for a `Chart`, such as height, color, etc.
`ChartType`	Chart types supported by the Charts service.
`Charts`	Entry point for creating Charts in scripts.
`ColumnChartBuilder`	Builder for column charts.
`ColumnType`	An enumeration of the valid data types for columns in a `DataTable`.
`CurveStyle`	An enumeration of the styles for curves in a chart.
`DataTable`	A Data Table to be used in charts.
`DataTableBuilder`	Builder of DataTable objects.
`DataTableSource`	Interface for objects that can represent their data as a `DataTable`.
`DataViewDefinition`	A data view definition for visualizing chart data.
`DataViewDefinitionBuilder`	Builder for `DataViewDefinition` objects.
`LineChartBuilder`	Builder for line charts.
`MatchType`	An enumeration of how a string value should be matched.
`NumberRangeFilterBuilder`	A builder for number range filter controls.
`Orientation`	An enumeration of the orientation of an object.
`PickerValuesLayout`	An enumeration of how to display selected values in picker widget.
`PieChartBuilder`	A builder for pie charts.
`PointStyle`	An enumeration of the styles of points in a line.
`Position`	An enumeration of legend positions within a chart.
`ScatterChartBuilder`	Builder for scatter charts.
`StringFilterBuilder`	A builder for string filter controls.
`TableChartBuilder`	A builder for table charts.
`TextStyle`	A text style configuration object.
`TextStyleBuilder`	A builder used to create `TextStyle` objects.

`AreaChartBuilder`

Methods

Method	Return type	Brief description
`build()`	`Chart`	Builds the chart.
`reverseCategories()`	`AreaChartBuilder`	Reverses the drawing of series in the domain axis.
`setBackgroundColor(cssValue)`	`AreaChartBuilder`	Sets the background color for the chart.
`setColors(cssValues)`	`AreaChartBuilder`	Sets the colors for the lines in the chart.
`setDataSourceUrl(url)`	`AreaChartBuilder`	Sets the data source URL that is used to pull data in from an external source, such as Google Sheets.
`setDataTable(tableBuilder)`	`AreaChartBuilder`	Sets the data table to use for the chart using a DataTableBuilder.
`setDataTable(table)`	`AreaChartBuilder`	Sets the data table which contains the lines for the chart, as well as the X-axis labels.
`setDataViewDefinition(dataViewDefinition)`	`AreaChartBuilder`	Sets the data view definition to use for the chart.
`setDimensions(width, height)`	`AreaChartBuilder`	Sets the dimensions for the chart.
`setLegendPosition(position)`	`AreaChartBuilder`	Sets the position of the legend with respect to the chart.
`setLegendTextStyle(textStyle)`	`AreaChartBuilder`	Sets the text style of the chart legend.
`setOption(option, value)`	`AreaChartBuilder`	Sets advanced options for this chart.
`setPointStyle(style)`	`AreaChartBuilder`	Sets the style for points in the line.
`setRange(start, end)`	`AreaChartBuilder`	Sets the range for the chart.
`setStacked()`	`AreaChartBuilder`	Uses stacked lines, meaning that line and bar values are stacked (accumulated).
`setTitle(chartTitle)`	`AreaChartBuilder`	Sets the title of the chart.
`setTitleTextStyle(textStyle)`	`AreaChartBuilder`	Sets the text style of the chart title.
`setXAxisTextStyle(textStyle)`	`AreaChartBuilder`	Sets the horizontal axis text style.
`setXAxisTitle(title)`	`AreaChartBuilder`	Adds a title to the horizontal axis.
`setXAxisTitleTextStyle(textStyle)`	`AreaChartBuilder`	Sets the horizontal axis title text style.
`setYAxisTextStyle(textStyle)`	`AreaChartBuilder`	Sets the vertical axis text style.
`setYAxisTitle(title)`	`AreaChartBuilder`	Adds a title to the vertical axis.
`setYAxisTitleTextStyle(textStyle)`	`AreaChartBuilder`	Sets the vertical axis title text style.
`useLogScale()`	`AreaChartBuilder`	Makes the range axis into a logarithmic scale (requires all values to be positive).

`BarChartBuilder`

Methods

Method	Return type	Brief description
`build()`	`Chart`	Builds the chart.
`reverseCategories()`	`BarChartBuilder`	Reverses the drawing of series in the domain axis.
`reverseDirection()`	`BarChartBuilder`	Reverses the direction in which the bars grow along the horizontal axis.
`setBackgroundColor(cssValue)`	`BarChartBuilder`	Sets the background color for the chart.
`setColors(cssValues)`	`BarChartBuilder`	Sets the colors for the lines in the chart.
`setDataSourceUrl(url)`	`BarChartBuilder`	Sets the data source URL that is used to pull data in from an external source, such as Google Sheets.
`setDataTable(tableBuilder)`	`BarChartBuilder`	Sets the data table to use for the chart using a DataTableBuilder.
`setDataTable(table)`	`BarChartBuilder`	Sets the data table which contains the lines for the chart, as well as the X-axis labels.
`setDataViewDefinition(dataViewDefinition)`	`BarChartBuilder`	Sets the data view definition to use for the chart.
`setDimensions(width, height)`	`BarChartBuilder`	Sets the dimensions for the chart.
`setLegendPosition(position)`	`BarChartBuilder`	Sets the position of the legend with respect to the chart.
`setLegendTextStyle(textStyle)`	`BarChartBuilder`	Sets the text style of the chart legend.
`setOption(option, value)`	`BarChartBuilder`	Sets advanced options for this chart.
`setRange(start, end)`	`BarChartBuilder`	Sets the range for the chart.
`setStacked()`	`BarChartBuilder`	Uses stacked lines, meaning that line and bar values are stacked (accumulated).
`setTitle(chartTitle)`	`BarChartBuilder`	Sets the title of the chart.
`setTitleTextStyle(textStyle)`	`BarChartBuilder`	Sets the text style of the chart title.
`setXAxisTextStyle(textStyle)`	`BarChartBuilder`	Sets the horizontal axis text style.
`setXAxisTitle(title)`	`BarChartBuilder`	Adds a title to the horizontal axis.
`setXAxisTitleTextStyle(textStyle)`	`BarChartBuilder`	Sets the horizontal axis title text style.
`setYAxisTextStyle(textStyle)`	`BarChartBuilder`	Sets the vertical axis text style.
`setYAxisTitle(title)`	`BarChartBuilder`	Adds a title to the vertical axis.
`setYAxisTitleTextStyle(textStyle)`	`BarChartBuilder`	Sets the vertical axis title text style.
`useLogScale()`	`BarChartBuilder`	Makes the range axis into a logarithmic scale (requires all values to be positive).

`Chart`

Methods

Method	Return type	Brief description
`getAs(contentType)`	`Blob`	Return the data inside this object as a blob converted to the specified content type.
`getBlob()`	`Blob`	Return the data inside this object as a blob.
`getOptions()`	`ChartOptions`	Returns the options for this chart, such as height, colors, and axes.

`ChartHiddenDimensionStrategy`

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.

`ChartMergeStrategy`

Properties

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

`ChartOptions`

Methods

Method	Return type	Brief description
`get(option)`	`Object`	Returns a configured option for this chart.
`getOrDefault(option)`	`Object`	Returns a configured option for this chart.

`ChartType`

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.

`Charts`

Properties

Property	Type	Description
`ChartHiddenDimensionStrategy`	`ChartHiddenDimensionStrategy`	An enumeration of how hidden dimensions in a source are expressed in a chart.
`ChartMergeStrategy`	`ChartMergeStrategy`	An enumeration of how multiple ranges in the source are expressed in a chart.
`ChartType`	`ChartType`	An enumeration of chart types supported by the Charts service.
`ColumnType`	`ColumnType`	An enumeration of the valid data types for columns in a `DataTable`.
`CurveStyle`	`CurveStyle`	An enumeration of the styles for curves in a chart.
`PointStyle`	`PointStyle`	An enumeration of the styles of points in a line.
`Position`	`Position`	An enumeration of legend positions within a chart.

Methods

Method	Return type	Brief description
`newAreaChart()`	`AreaChartBuilder`	Starts building an area chart, as described in the Google Chart Tools documentation.
`newBarChart()`	`BarChartBuilder`	Starts building a bar chart, as described in the Google Chart Tools documentation.
`newColumnChart()`	`ColumnChartBuilder`	Starts building a column chart, as described in the Google Chart Tools documentation.
`newDataTable()`	`DataTableBuilder`	Creates an empty data table, which can have its values set manually.
`newDataViewDefinition()`	`DataViewDefinitionBuilder`	Creates a new data view definition.
`newLineChart()`	`LineChartBuilder`	Starts building a line chart, as described in the Google Chart Tools documentation.
`newPieChart()`	`PieChartBuilder`	Starts building a pie chart, as described in the Google Chart Tools documentation.
`newScatterChart()`	`ScatterChartBuilder`	Starts building a scatter chart, as described in the Google Chart Tools documentation.
`newTableChart()`	`TableChartBuilder`	Starts building a table chart, as described in the Google Chart Tools documentation.
`newTextStyle()`	`TextStyleBuilder`	Creates a new text style builder.

`ColumnChartBuilder`

Methods

Method	Return type	Brief description
`build()`	`Chart`	Builds the chart.
`reverseCategories()`	`ColumnChartBuilder`	Reverses the drawing of series in the domain axis.
`setBackgroundColor(cssValue)`	`ColumnChartBuilder`	Sets the background color for the chart.
`setColors(cssValues)`	`ColumnChartBuilder`	Sets the colors for the lines in the chart.
`setDataSourceUrl(url)`	`ColumnChartBuilder`	Sets the data source URL that is used to pull data in from an external source, such as Google Sheets.
`setDataTable(tableBuilder)`	`ColumnChartBuilder`	Sets the data table to use for the chart using a DataTableBuilder.
`setDataTable(table)`	`ColumnChartBuilder`	Sets the data table which contains the lines for the chart, as well as the X-axis labels.
`setDataViewDefinition(dataViewDefinition)`	`ColumnChartBuilder`	Sets the data view definition to use for the chart.
`setDimensions(width, height)`	`ColumnChartBuilder`	Sets the dimensions for the chart.
`setLegendPosition(position)`	`ColumnChartBuilder`	Sets the position of the legend with respect to the chart.
`setLegendTextStyle(textStyle)`	`ColumnChartBuilder`	Sets the text style of the chart legend.
`setOption(option, value)`	`ColumnChartBuilder`	Sets advanced options for this chart.
`setRange(start, end)`	`ColumnChartBuilder`	Sets the range for the chart.
`setStacked()`	`ColumnChartBuilder`	Uses stacked lines, meaning that line and bar values are stacked (accumulated).
`setTitle(chartTitle)`	`ColumnChartBuilder`	Sets the title of the chart.
`setTitleTextStyle(textStyle)`	`ColumnChartBuilder`	Sets the text style of the chart title.
`setXAxisTextStyle(textStyle)`	`ColumnChartBuilder`	Sets the horizontal axis text style.
`setXAxisTitle(title)`	`ColumnChartBuilder`	Adds a title to the horizontal axis.
`setXAxisTitleTextStyle(textStyle)`	`ColumnChartBuilder`	Sets the horizontal axis title text style.
`setYAxisTextStyle(textStyle)`	`ColumnChartBuilder`	Sets the vertical axis text style.
`setYAxisTitle(title)`	`ColumnChartBuilder`	Adds a title to the vertical axis.
`setYAxisTitleTextStyle(textStyle)`	`ColumnChartBuilder`	Sets the vertical axis title text style.
`useLogScale()`	`ColumnChartBuilder`	Makes the range axis into a logarithmic scale (requires all values to be positive).

`ColumnType`

Properties

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

`CurveStyle`

Properties

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

`DataTable`

`DataTableBuilder`

Methods

Method	Return type	Brief description
`addColumn(type, label)`	`DataTableBuilder`	Adds a column to the data table.
`addRow(values)`	`DataTableBuilder`	Adds a row to the data table.
`build()`	`DataTable`	Builds and returns a data table.
`setValue(row, column, value)`	`DataTableBuilder`	Sets a specific value in the table.

`DataTableSource`

Methods

Method	Return type	Brief description
`getDataTable()`	`DataTable`	Return the data inside this object as a DataTable.

`DataViewDefinition`

`DataViewDefinitionBuilder`

Methods

Method	Return type	Brief description
`build()`	`DataViewDefinition`	Builds and returns the data view definition object that was built using this builder.
`setColumns(columns)`	`DataViewDefinitionBuilder`	Sets the indexes of the columns to include in the data view as well as specifying role-column information.

`LineChartBuilder`

Methods

Method	Return type	Brief description
`build()`	`Chart`	Builds the chart.
`reverseCategories()`	`LineChartBuilder`	Reverses the drawing of series in the domain axis.
`setBackgroundColor(cssValue)`	`LineChartBuilder`	Sets the background color for the chart.
`setColors(cssValues)`	`LineChartBuilder`	Sets the colors for the lines in the chart.
`setCurveStyle(style)`	`LineChartBuilder`	Sets the style to use for curves in the chart.
`setDataSourceUrl(url)`	`LineChartBuilder`	Sets the data source URL that is used to pull data in from an external source, such as Google Sheets.
`setDataTable(tableBuilder)`	`LineChartBuilder`	Sets the data table to use for the chart using a DataTableBuilder.
`setDataTable(table)`	`LineChartBuilder`	Sets the data table which contains the lines for the chart, as well as the X-axis labels.
`setDataViewDefinition(dataViewDefinition)`	`LineChartBuilder`	Sets the data view definition to use for the chart.
`setDimensions(width, height)`	`LineChartBuilder`	Sets the dimensions for the chart.
`setLegendPosition(position)`	`LineChartBuilder`	Sets the position of the legend with respect to the chart.
`setLegendTextStyle(textStyle)`	`LineChartBuilder`	Sets the text style of the chart legend.
`setOption(option, value)`	`LineChartBuilder`	Sets advanced options for this chart.
`setPointStyle(style)`	`LineChartBuilder`	Sets the style for points in the line.
`setRange(start, end)`	`LineChartBuilder`	Sets the range for the chart.
`setTitle(chartTitle)`	`LineChartBuilder`	Sets the title of the chart.
`setTitleTextStyle(textStyle)`	`LineChartBuilder`	Sets the text style of the chart title.
`setXAxisTextStyle(textStyle)`	`LineChartBuilder`	Sets the horizontal axis text style.
`setXAxisTitle(title)`	`LineChartBuilder`	Adds a title to the horizontal axis.
`setXAxisTitleTextStyle(textStyle)`	`LineChartBuilder`	Sets the horizontal axis title text style.
`setYAxisTextStyle(textStyle)`	`LineChartBuilder`	Sets the vertical axis text style.
`setYAxisTitle(title)`	`LineChartBuilder`	Adds a title to the vertical axis.
`setYAxisTitleTextStyle(textStyle)`	`LineChartBuilder`	Sets the vertical axis title text style.
`useLogScale()`	`LineChartBuilder`	Makes the range axis into a logarithmic scale (requires all values to be positive).

`MatchType`

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
`getName()`	`String`	Returns the name of the match type to be used in the options JSON.

`NumberRangeFilterBuilder`

Methods

Method	Return type	Brief description
`setMaxValue(maxValue)`	`NumberRangeFilterBuilder`	Sets the maximum allowed value for the range lower extent.
`setMinValue(minValue)`	`NumberRangeFilterBuilder`	Sets the minimum allowed value for the range lower extent.
`setOrientation(orientation)`	`NumberRangeFilterBuilder`	Sets the slider orientation.
`setShowRangeValues(showRangeValues)`	`NumberRangeFilterBuilder`	Sets whether to have labels next to the slider displaying extents of the selected range.
`setTicks(ticks)`	`NumberRangeFilterBuilder`	Sets the number of ticks (fixed positions in a range bar) a number range filter slider thumbs can fall in.

`Orientation`

Properties

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

`PickerValuesLayout`

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.

`PieChartBuilder`

Methods

Method	Return type	Brief description
`build()`	`Chart`	Builds the chart.
`reverseCategories()`	`PieChartBuilder`	Reverses the drawing of series in the domain axis.
`set3D()`	`PieChartBuilder`	Sets the chart to be three-dimensional.
`setBackgroundColor(cssValue)`	`PieChartBuilder`	Sets the background color for the chart.
`setColors(cssValues)`	`PieChartBuilder`	Sets the colors for the lines in the chart.
`setDataSourceUrl(url)`	`PieChartBuilder`	Sets the data source URL that is used to pull data in from an external source, such as Google Sheets.
`setDataTable(tableBuilder)`	`PieChartBuilder`	Sets the data table to use for the chart using a DataTableBuilder.
`setDataTable(table)`	`PieChartBuilder`	Sets the data table which contains the lines for the chart, as well as the X-axis labels.
`setDataViewDefinition(dataViewDefinition)`	`PieChartBuilder`	Sets the data view definition to use for the chart.
`setDimensions(width, height)`	`PieChartBuilder`	Sets the dimensions for the chart.
`setLegendPosition(position)`	`PieChartBuilder`	Sets the position of the legend with respect to the chart.
`setLegendTextStyle(textStyle)`	`PieChartBuilder`	Sets the text style of the chart legend.
`setOption(option, value)`	`PieChartBuilder`	Sets advanced options for this chart.
`setTitle(chartTitle)`	`PieChartBuilder`	Sets the title of the chart.
`setTitleTextStyle(textStyle)`	`PieChartBuilder`	Sets the text style of the chart title.

`PointStyle`

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.

`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.

`ScatterChartBuilder`

Methods

Method	Return type	Brief description
`build()`	`Chart`	Builds the chart.
`setBackgroundColor(cssValue)`	`ScatterChartBuilder`	Sets the background color for the chart.
`setColors(cssValues)`	`ScatterChartBuilder`	Sets the colors for the lines in the chart.
`setDataSourceUrl(url)`	`ScatterChartBuilder`	Sets the data source URL that is used to pull data in from an external source, such as Google Sheets.
`setDataTable(tableBuilder)`	`ScatterChartBuilder`	Sets the data table to use for the chart using a DataTableBuilder.
`setDataTable(table)`	`ScatterChartBuilder`	Sets the data table which contains the lines for the chart, as well as the X-axis labels.
`setDataViewDefinition(dataViewDefinition)`	`ScatterChartBuilder`	Sets the data view definition to use for the chart.
`setDimensions(width, height)`	`ScatterChartBuilder`	Sets the dimensions for the chart.
`setLegendPosition(position)`	`ScatterChartBuilder`	Sets the position of the legend with respect to the chart.
`setLegendTextStyle(textStyle)`	`ScatterChartBuilder`	Sets the text style of the chart legend.
`setOption(option, value)`	`ScatterChartBuilder`	Sets advanced options for this chart.
`setPointStyle(style)`	`ScatterChartBuilder`	Sets the style for points in the line.
`setTitle(chartTitle)`	`ScatterChartBuilder`	Sets the title of the chart.
`setTitleTextStyle(textStyle)`	`ScatterChartBuilder`	Sets the text style of the chart title.
`setXAxisLogScale()`	`ScatterChartBuilder`	Makes the horizontal axis into a logarithmic scale (requires all values to be positive).
`setXAxisRange(start, end)`	`ScatterChartBuilder`	Sets the range for the horizontal axis of the chart.
`setXAxisTextStyle(textStyle)`	`ScatterChartBuilder`	Sets the horizontal axis text style.
`setXAxisTitle(title)`	`ScatterChartBuilder`	Adds a title to the horizontal axis.
`setXAxisTitleTextStyle(textStyle)`	`ScatterChartBuilder`	Sets the horizontal axis title text style.
`setYAxisLogScale()`	`ScatterChartBuilder`	Makes the vertical axis into a logarithmic scale (requires all values to be positive).
`setYAxisRange(start, end)`	`ScatterChartBuilder`	Sets the range for the vertical axis of the chart.
`setYAxisTextStyle(textStyle)`	`ScatterChartBuilder`	Sets the vertical axis text style.
`setYAxisTitle(title)`	`ScatterChartBuilder`	Adds a title to the vertical axis.
`setYAxisTitleTextStyle(textStyle)`	`ScatterChartBuilder`	Sets the vertical axis title text style.

`StringFilterBuilder`

Methods

Method	Return type	Brief description
`setCaseSensitive(caseSensitive)`	`StringFilterBuilder`	Sets whether matching should be case sensitive or not.
`setMatchType(matchType)`	`StringFilterBuilder`	Sets whether the control should match exact values only (`MatchType.EXACT`), prefixes starting from the beginning of the value (`MatchType.PREFIX`), or any substring (`MatchType.ANY`).
`setRealtimeTrigger(realtimeTrigger)`	`StringFilterBuilder`	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).

`TableChartBuilder`

Methods

Method	Return type	Brief description
`build()`	`Chart`	Builds the chart.
`enablePaging(enablePaging)`	`TableChartBuilder`	Sets whether to enable paging through the data.
`enablePaging(pageSize)`	`TableChartBuilder`	Enables paging and sets the number of rows in each page.
`enablePaging(pageSize, startPage)`	`TableChartBuilder`	Enables paging, sets the number of rows in each page and the first table page to display (page numbers are zero based).
`enableRtlTable(rtlEnabled)`	`TableChartBuilder`	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.
`enableSorting(enableSorting)`	`TableChartBuilder`	Sets whether to sort columns when the user clicks a column heading.
`setDataSourceUrl(url)`	`TableChartBuilder`	Sets the data source URL that is used to pull data in from an external source, such as Google Sheets.
`setDataTable(tableBuilder)`	`TableChartBuilder`	Sets the data table to use for the chart using a DataTableBuilder.
`setDataTable(table)`	`TableChartBuilder`	Sets the data table which contains the lines for the chart, as well as the X-axis labels.
`setDataViewDefinition(dataViewDefinition)`	`TableChartBuilder`	Sets the data view definition to use for the chart.
`setDimensions(width, height)`	`TableChartBuilder`	Sets the dimensions for the chart.
`setFirstRowNumber(number)`	`TableChartBuilder`	Sets the row number for the first row in the data table.
`setInitialSortingAscending(column)`	`TableChartBuilder`	Sets the index of the column according to which the table should be initially sorted (ascending).
`setInitialSortingDescending(column)`	`TableChartBuilder`	Sets the index of the column according to which the table should be initially sorted (descending).
`setOption(option, value)`	`TableChartBuilder`	Sets advanced options for this chart.
`showRowNumberColumn(showRowNumber)`	`TableChartBuilder`	Sets whether to show the row number as the first column of the table.
`useAlternatingRowStyle(alternate)`	`TableChartBuilder`	Sets whether alternating color style is assigned to odd and even rows of a table chart.

`TextStyle`

Methods

Method	Return type	Brief description
`getColor()`	`String`	Gets the color of the text style.
`getFontName()`	`String`	Gets the font name of the text style.
`getFontSize()`	`Number`	Gets the font size of the text style.

`TextStyleBuilder`

Methods

Method	Return type	Brief description
`build()`	`TextStyle`	Builds and returns a text style configuration object that was built using this builder.
`setColor(cssValue)`	`TextStyleBuilder`	Sets the color of the text style.
`setFontName(fontName)`	`TextStyleBuilder`	Sets the font name of the text style.
`setFontSize(fontSize)`	`TextStyleBuilder`	Sets the font size of the text style.

Charts Service Stay organized with collections Save and categorize content based on your preferences.

AI-generated Key Takeaways

Classes

Methods

Methods

Methods

Properties

Properties

Methods

Properties

Properties

Methods

Methods

Properties

Properties

Methods

Methods

Methods

Methods

Properties

Methods

Methods

Properties

Properties

Methods

Properties

Properties

Methods

Methods

Methods

Methods

Methods

Charts Service