Google Apps Script API
Preparing search index...
google-apps-script-events
GoogleAppsScript
Spreadsheet
EmbeddedColumnChartBuilder
Interface EmbeddedColumnChartBuilder
Builder for column charts. For more details, see the Gviz documentation.
interface
EmbeddedColumnChartBuilder
{
addRange
(
range
:
GoogleAppsScript
.
Spreadsheet
.
Range
,
)
:
EmbeddedChartBuilder
;
asAreaChart
()
:
EmbeddedAreaChartBuilder
;
asBarChart
()
:
EmbeddedBarChartBuilder
;
asColumnChart
()
:
EmbeddedColumnChartBuilder
;
asComboChart
()
:
EmbeddedComboChartBuilder
;
asHistogramChart
()
:
EmbeddedHistogramChartBuilder
;
asLineChart
()
:
EmbeddedLineChartBuilder
;
asPieChart
()
:
EmbeddedPieChartBuilder
;
asScatterChart
()
:
EmbeddedScatterChartBuilder
;
asTableChart
()
:
EmbeddedTableChartBuilder
;
build
()
:
GoogleAppsScript
.
Spreadsheet
.
EmbeddedChart
;
clearRanges
()
:
EmbeddedChartBuilder
;
getChartType
()
:
ChartType
;
getContainer
()
:
ContainerInfo
;
getRanges
()
:
GoogleAppsScript
.
Spreadsheet
.
Range
[]
;
removeRange
(
range
:
GoogleAppsScript
.
Spreadsheet
.
Range
,
)
:
EmbeddedChartBuilder
;
reverseCategories
()
:
EmbeddedColumnChartBuilder
;
setBackgroundColor
(
cssValue
:
string
)
:
EmbeddedColumnChartBuilder
;
setChartType
(
type
:
ChartType
)
:
EmbeddedChartBuilder
;
setColors
(
cssValues
:
string
[]
)
:
EmbeddedColumnChartBuilder
;
setHiddenDimensionStrategy
(
strategy
:
ChartHiddenDimensionStrategy
,
)
:
EmbeddedChartBuilder
;
setLegendPosition
(
position
:
GoogleAppsScript
.
Charts
.
Position
,
)
:
EmbeddedColumnChartBuilder
;
setLegendTextStyle
(
textStyle
:
GoogleAppsScript
.
Charts
.
TextStyle
,
)
:
EmbeddedColumnChartBuilder
;
setMergeStrategy
(
mergeStrategy
:
ChartMergeStrategy
)
:
EmbeddedChartBuilder
;
setNumHeaders
(
headers
:
number
)
:
EmbeddedChartBuilder
;
setOption
(
option
:
string
,
value
:
any
)
:
EmbeddedChartBuilder
;
setPosition
(
anchorRowPos
:
number
,
anchorColPos
:
number
,
offsetX
:
number
,
offsetY
:
number
,
)
:
EmbeddedChartBuilder
;
setRange
(
start
:
number
,
end
:
number
)
:
EmbeddedColumnChartBuilder
;
setStacked
()
:
EmbeddedColumnChartBuilder
;
setTitle
(
chartTitle
:
string
)
:
EmbeddedColumnChartBuilder
;
setTitleTextStyle
(
textStyle
:
GoogleAppsScript
.
Charts
.
TextStyle
,
)
:
EmbeddedColumnChartBuilder
;
setTransposeRowsAndColumns
(
transpose
:
boolean
)
:
EmbeddedChartBuilder
;
setXAxisTextStyle
(
textStyle
:
GoogleAppsScript
.
Charts
.
TextStyle
,
)
:
EmbeddedColumnChartBuilder
;
setXAxisTitle
(
title
:
string
)
:
EmbeddedColumnChartBuilder
;
setXAxisTitleTextStyle
(
textStyle
:
GoogleAppsScript
.
Charts
.
TextStyle
,
)
:
EmbeddedColumnChartBuilder
;
setYAxisTextStyle
(
textStyle
:
GoogleAppsScript
.
Charts
.
TextStyle
,
)
:
EmbeddedColumnChartBuilder
;
setYAxisTitle
(
title
:
string
)
:
EmbeddedColumnChartBuilder
;
setYAxisTitleTextStyle
(
textStyle
:
GoogleAppsScript
.
Charts
.
TextStyle
,
)
:
EmbeddedColumnChartBuilder
;
useLogScale
()
:
EmbeddedColumnChartBuilder
;
}
Index
Methods
add
Range
as
Area
Chart
as
Bar
Chart
as
Column
Chart
as
Combo
Chart
as
Histogram
Chart
as
Line
Chart
as
Pie
Chart
as
Scatter
Chart
as
Table
Chart
build
clear
Ranges
get
Chart
Type
get
Container
get
Ranges
remove
Range
reverse
Categories
set
Background
Color
set
Chart
Type
set
Colors
set
Hidden
Dimension
Strategy
set
Legend
Position
set
Legend
Text
Style
set
Merge
Strategy
set
Num
Headers
set
Option
set
Position
set
Range
set
Stacked
set
Title
set
Title
Text
Style
set
Transpose
Rows
And
Columns
set
X
Axis
Text
Style
set
X
Axis
Title
set
X
Axis
Title
Text
Style
set
Y
Axis
Text
Style
set
Y
Axis
Title
set
Y
Axis
Title
Text
Style
use
Log
Scale
Methods
add
Range
addRange
(
range
:
GoogleAppsScript
.
Spreadsheet
.
Range
)
:
EmbeddedChartBuilder
Parameters
range
:
GoogleAppsScript
.
Spreadsheet
.
Range
Returns
EmbeddedChartBuilder
as
Area
Chart
asAreaChart
()
:
EmbeddedAreaChartBuilder
Returns
EmbeddedAreaChartBuilder
as
Bar
Chart
asBarChart
()
:
EmbeddedBarChartBuilder
Returns
EmbeddedBarChartBuilder
as
Column
Chart
asColumnChart
()
:
EmbeddedColumnChartBuilder
Returns
EmbeddedColumnChartBuilder
as
Combo
Chart
asComboChart
()
:
EmbeddedComboChartBuilder
Returns
EmbeddedComboChartBuilder
as
Histogram
Chart
asHistogramChart
()
:
EmbeddedHistogramChartBuilder
Returns
EmbeddedHistogramChartBuilder
as
Line
Chart
asLineChart
()
:
EmbeddedLineChartBuilder
Returns
EmbeddedLineChartBuilder
as
Pie
Chart
asPieChart
()
:
EmbeddedPieChartBuilder
Returns
EmbeddedPieChartBuilder
as
Scatter
Chart
asScatterChart
()
:
EmbeddedScatterChartBuilder
Returns
EmbeddedScatterChartBuilder
as
Table
Chart
asTableChart
()
:
EmbeddedTableChartBuilder
Returns
EmbeddedTableChartBuilder
build
build
()
:
GoogleAppsScript
.
Spreadsheet
.
EmbeddedChart
Returns
GoogleAppsScript
.
Spreadsheet
.
EmbeddedChart
clear
Ranges
clearRanges
()
:
EmbeddedChartBuilder
Returns
EmbeddedChartBuilder
get
Chart
Type
getChartType
()
:
ChartType
Returns
ChartType
get
Container
getContainer
()
:
ContainerInfo
Returns
ContainerInfo
get
Ranges
getRanges
()
:
GoogleAppsScript
.
Spreadsheet
.
Range
[]
Returns
GoogleAppsScript
.
Spreadsheet
.
Range
[]
remove
Range
removeRange
(
range
:
GoogleAppsScript
.
Spreadsheet
.
Range
)
:
EmbeddedChartBuilder
Parameters
range
:
GoogleAppsScript
.
Spreadsheet
.
Range
Returns
EmbeddedChartBuilder
reverse
Categories
reverseCategories
()
:
EmbeddedColumnChartBuilder
Returns
EmbeddedColumnChartBuilder
set
Background
Color
setBackgroundColor
(
cssValue
:
string
)
:
EmbeddedColumnChartBuilder
Parameters
cssValue
:
string
Returns
EmbeddedColumnChartBuilder
set
Chart
Type
setChartType
(
type
:
ChartType
)
:
EmbeddedChartBuilder
Parameters
type
:
ChartType
Returns
EmbeddedChartBuilder
set
Colors
setColors
(
cssValues
:
string
[]
)
:
EmbeddedColumnChartBuilder
Parameters
cssValues
:
string
[]
Returns
EmbeddedColumnChartBuilder
set
Hidden
Dimension
Strategy
setHiddenDimensionStrategy
(
strategy
:
ChartHiddenDimensionStrategy
,
)
:
EmbeddedChartBuilder
Parameters
strategy
:
ChartHiddenDimensionStrategy
Returns
EmbeddedChartBuilder
set
Legend
Position
setLegendPosition
(
position
:
GoogleAppsScript
.
Charts
.
Position
,
)
:
EmbeddedColumnChartBuilder
Parameters
position
:
GoogleAppsScript
.
Charts
.
Position
Returns
EmbeddedColumnChartBuilder
set
Legend
Text
Style
setLegendTextStyle
(
textStyle
:
GoogleAppsScript
.
Charts
.
TextStyle
,
)
:
EmbeddedColumnChartBuilder
Parameters
textStyle
:
GoogleAppsScript
.
Charts
.
TextStyle
Returns
EmbeddedColumnChartBuilder
set
Merge
Strategy
setMergeStrategy
(
mergeStrategy
:
ChartMergeStrategy
)
:
EmbeddedChartBuilder
Parameters
mergeStrategy
:
ChartMergeStrategy
Returns
EmbeddedChartBuilder
set
Num
Headers
setNumHeaders
(
headers
:
number
)
:
EmbeddedChartBuilder
Parameters
headers
:
number
Returns
EmbeddedChartBuilder
set
Option
setOption
(
option
:
string
,
value
:
any
)
:
EmbeddedChartBuilder
Parameters
option
:
string
value
:
any
Returns
EmbeddedChartBuilder
set
Position
setPosition
(
anchorRowPos
:
number
,
anchorColPos
:
number
,
offsetX
:
number
,
offsetY
:
number
,
)
:
EmbeddedChartBuilder
Parameters
anchorRowPos
:
number
anchorColPos
:
number
offsetX
:
number
offsetY
:
number
Returns
EmbeddedChartBuilder
set
Range
setRange
(
start
:
number
,
end
:
number
)
:
EmbeddedColumnChartBuilder
Parameters
start
:
number
end
:
number
Returns
EmbeddedColumnChartBuilder
set
Stacked
setStacked
()
:
EmbeddedColumnChartBuilder
Returns
EmbeddedColumnChartBuilder
set
Title
setTitle
(
chartTitle
:
string
)
:
EmbeddedColumnChartBuilder
Parameters
chartTitle
:
string
Returns
EmbeddedColumnChartBuilder
set
Title
Text
Style
setTitleTextStyle
(
textStyle
:
GoogleAppsScript
.
Charts
.
TextStyle
,
)
:
EmbeddedColumnChartBuilder
Parameters
textStyle
:
GoogleAppsScript
.
Charts
.
TextStyle
Returns
EmbeddedColumnChartBuilder
set
Transpose
Rows
And
Columns
setTransposeRowsAndColumns
(
transpose
:
boolean
)
:
EmbeddedChartBuilder
Parameters
transpose
:
boolean
Returns
EmbeddedChartBuilder
set
X
Axis
Text
Style
setXAxisTextStyle
(
textStyle
:
GoogleAppsScript
.
Charts
.
TextStyle
,
)
:
EmbeddedColumnChartBuilder
Parameters
textStyle
:
GoogleAppsScript
.
Charts
.
TextStyle
Returns
EmbeddedColumnChartBuilder
set
X
Axis
Title
setXAxisTitle
(
title
:
string
)
:
EmbeddedColumnChartBuilder
Parameters
title
:
string
Returns
EmbeddedColumnChartBuilder
set
X
Axis
Title
Text
Style
setXAxisTitleTextStyle
(
textStyle
:
GoogleAppsScript
.
Charts
.
TextStyle
,
)
:
EmbeddedColumnChartBuilder
Parameters
textStyle
:
GoogleAppsScript
.
Charts
.
TextStyle
Returns
EmbeddedColumnChartBuilder
set
Y
Axis
Text
Style
setYAxisTextStyle
(
textStyle
:
GoogleAppsScript
.
Charts
.
TextStyle
,
)
:
EmbeddedColumnChartBuilder
Parameters
textStyle
:
GoogleAppsScript
.
Charts
.
TextStyle
Returns
EmbeddedColumnChartBuilder
set
Y
Axis
Title
setYAxisTitle
(
title
:
string
)
:
EmbeddedColumnChartBuilder
Parameters
title
:
string
Returns
EmbeddedColumnChartBuilder
set
Y
Axis
Title
Text
Style
setYAxisTitleTextStyle
(
textStyle
:
GoogleAppsScript
.
Charts
.
TextStyle
,
)
:
EmbeddedColumnChartBuilder
Parameters
textStyle
:
GoogleAppsScript
.
Charts
.
TextStyle
Returns
EmbeddedColumnChartBuilder
use
Log
Scale
useLogScale
()
:
EmbeddedColumnChartBuilder
Returns
EmbeddedColumnChartBuilder
Settings
Member Visibility
Protected
Inherited
External
Theme
OS
Light
Dark
On This Page
Methods
add
Range
as
Area
Chart
as
Bar
Chart
as
Column
Chart
as
Combo
Chart
as
Histogram
Chart
as
Line
Chart
as
Pie
Chart
as
Scatter
Chart
as
Table
Chart
build
clear
Ranges
get
Chart
Type
get
Container
get
Ranges
remove
Range
reverse
Categories
set
Background
Color
set
Chart
Type
set
Colors
set
Hidden
Dimension
Strategy
set
Legend
Position
set
Legend
Text
Style
set
Merge
Strategy
set
Num
Headers
set
Option
set
Position
set
Range
set
Stacked
set
Title
set
Title
Text
Style
set
Transpose
Rows
And
Columns
set
X
Axis
Text
Style
set
X
Axis
Title
set
X
Axis
Title
Text
Style
set
Y
Axis
Text
Style
set
Y
Axis
Title
set
Y
Axis
Title
Text
Style
use
Log
Scale
Google Apps Script API
Loading...
Builder for column charts. For more details, see the Gviz documentation.