Entry point for creating Charts in scripts.
This example creates a basic data table, populates an area chart with the data, and adds it into a web page as an image:
function doGet () { const 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 (); const chart = Charts . newAreaChart () . setDataTable ( data ) . setStacked () . setRange ( 0 , 40 ) . setTitle ( 'Sales per Month' ) . build (); const htmlOutput = HtmlService . createHtmlOutput (). setTitle ( 'My Chart' ); const imageData = Utilities . base64Encode ( chart . getAs ( 'image/png' ). getBytes ()); const imageUrl = `data:image/png;base64, ${ encodeURI ( imageData ) } ` ; htmlOutput . append ( 'Render chart server side: <br/>' ); htmlOutput . append ( `<img border="1" src=" ${ imageUrl } ">` ); return htmlOutput ; }
Properties
Property | Type | Description |
---|---|---|
Chart
|
Chart
|
An enumeration of how hidden dimensions in a source are expressed in a chart. |
Chart
|
Chart
|
An enumeration of how multiple ranges in the source are expressed in a chart. |
Chart
|
Chart
|
An enumeration of chart types supported by the Charts service. |
Column
|
Column
|
An enumeration of the valid data types for columns in a Data
. |
Curve
|
Curve
|
An enumeration of the styles for curves in a chart. |
Point
|
Point
|
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 |
---|---|---|
Area
|
Starts building an area chart, as described in the Google Chart Tools documentation. | |
Bar
|
Starts building a bar chart, as described in the Google Chart Tools documentation. | |
Column
|
Starts building a column chart, as described in the Google Chart Tools documentation. | |
Data
|
Creates an empty data table, which can have its values set manually. | |
Data
|
Creates a new data view definition. | |
Line
|
Starts building a line chart, as described in the Google Chart Tools documentation. | |
Pie
|
Starts building a pie chart, as described in the Google Chart Tools documentation. | |
Scatter
|
Starts building a scatter chart, as described in the Google Chart Tools documentation. | |
Table
|
Starts building a table chart, as described in the Google Chart Tools documentation. | |
Text
|
Creates a new text style builder. |
Detailed documentation
new
Area
Chart()
Starts building an area chart, as described in the Google Chart Tools documentation.
Return
Area
— An AreaChartBuilder, which can be used to build an area chart.
new
Bar
Chart()
Starts building a bar chart, as described in the Google Chart Tools documentation.
Return
Bar
— A BarChartBuilder, which can be used to build a bar chart.
new
Column
Chart()
Starts building a column chart, as described in the Google Chart Tools documentation.
Return
Column
— A ColumnChartBuilder, which can be used to build a column chart.
new
Data
Table()
Creates an empty data table, which can have its values set manually.
Data tables hold the data for all chart types.
Return
Data
— A DataTableBuilder, which can hold data for charts.
new
Data
View
Definition()
Creates a new data view definition.
Use setters to define the different properties of the data view.
Return
Data
— A DataViewDefinitionBuilder, which can be used to build a data view definition.
new
Line
Chart()
Starts building a line chart, as described in the Google Chart Tools documentation.
Return
Line
— A LineChartBuilder, which can be used to build a line chart.
new
Pie
Chart()
Starts building a pie chart, as described in the Google Chart Tools documentation.
Return
Pie
— A PieChartBuilder, which can be used to build a pie chart.
new
Scatter
Chart()
Starts building a scatter chart, as described in the Google Chart Tools documentation.
Return
Scatter
— A ScatterChartBuilder, which can be used to build a scatter chart.
new
Table
Chart()
Starts building a table chart, as described in the Google Chart Tools documentation.
Return
Table
— A TableChartBuilder, which can be used to build a table chart.
new
Text
Style()
Creates a new text style builder.
To change the default values, use the setter functions.
Return
Text
— A TextStyleBuilder, which can be used to build a text style configuration object.