Charts Service

The Charts service facilitates server-side chart creation using Google Charts Tools, whereas client-side rendering utilizes the Google Charts API.
An example is provided illustrating the process of creating a data table, populating an area chart, and displaying it as an image.
The documentation details various classes and methods for building different chart types such as Area, Bar, Column, Line, Pie, and Scatter charts, as well as data table and text style objects.
Supported chart types are listed, including Timeline, Area, Bar, Bubble, Candlestick, Column, Combo, Gauge, Geo, Histogram, Radar, Line, Org, Pie, Scatter, Sparkline, Stepped Area, Table, Treemap, and Waterfall charts.
Enums are defined for handling hidden data, merging data ranges, specifying column types, setting curve and point styles, defining legend positions, handling string matching in filters, setting orientation, and specifying picker values layout.

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

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

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.

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

`DataTableSource`

Methods

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

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

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

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

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

Except as otherwise noted, the content of this page is licensed under the Creative Commons Attribution 4.0 License, and code samples are licensed under the Apache 2.0 License. For details, see the Google Developers Site Policies. Java is a registered trademark of Oracle and/or its affiliates.

Last updated 2025-12-11 UTC.