Google Apps Script API
Preparing search index...
google-apps-script-events
GoogleAppsScript
Spreadsheet
EmbeddedHistogramChartBuilder
Interface EmbeddedHistogramChartBuilder
Builder for histogram charts. For more details, see the Gviz documentation.
interface
EmbeddedHistogramChartBuilder
{
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
()
:
EmbeddedHistogramChartBuilder
;
setBackgroundColor
(
cssValue
:
string
)
:
EmbeddedHistogramChartBuilder
;
setChartType
(
type
:
ChartType
)
:
EmbeddedChartBuilder
;
setColors
(
cssValues
:
string
[]
)
:
EmbeddedHistogramChartBuilder
;
setHiddenDimensionStrategy
(
strategy
:
ChartHiddenDimensionStrategy
,
)
:
EmbeddedChartBuilder
;
setLegendPosition
(
position
:
GoogleAppsScript
.
Charts
.
Position
,
)
:
EmbeddedHistogramChartBuilder
;
setLegendTextStyle
(
textStyle
:
GoogleAppsScript
.
Charts
.
TextStyle
,
)
:
EmbeddedHistogramChartBuilder
;
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
)
:
EmbeddedHistogramChartBuilder
;
setStacked
()
:
EmbeddedHistogramChartBuilder
;
setTitle
(
chartTitle
:
string
)
:
EmbeddedHistogramChartBuilder
;
setTitleTextStyle
(
textStyle
:
GoogleAppsScript
.
Charts
.
TextStyle
,
)
:
EmbeddedHistogramChartBuilder
;
setTransposeRowsAndColumns
(
transpose
:
boolean
)
:
EmbeddedChartBuilder
;
setXAxisTextStyle
(
textStyle
:
GoogleAppsScript
.
Charts
.
TextStyle
,
)
:
EmbeddedHistogramChartBuilder
;
setXAxisTitle
(
title
:
string
)
:
EmbeddedHistogramChartBuilder
;
setXAxisTitleTextStyle
(
textStyle
:
GoogleAppsScript
.
Charts
.
TextStyle
,
)
:
EmbeddedHistogramChartBuilder
;
setYAxisTextStyle
(
textStyle
:
GoogleAppsScript
.
Charts
.
TextStyle
,
)
:
EmbeddedHistogramChartBuilder
;
setYAxisTitle
(
title
:
string
)
:
EmbeddedHistogramChartBuilder
;
setYAxisTitleTextStyle
(
textStyle
:
GoogleAppsScript
.
Charts
.
TextStyle
,
)
:
EmbeddedHistogramChartBuilder
;
useLogScale
()
:
EmbeddedHistogramChartBuilder
;
}
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
()
:
EmbeddedHistogramChartBuilder
Returns
EmbeddedHistogramChartBuilder
set
Background
Color
setBackgroundColor
(
cssValue
:
string
)
:
EmbeddedHistogramChartBuilder
Parameters
cssValue
:
string
Returns
EmbeddedHistogramChartBuilder
set
Chart
Type
setChartType
(
type
:
ChartType
)
:
EmbeddedChartBuilder
Parameters
type
:
ChartType
Returns
EmbeddedChartBuilder
set
Colors
setColors
(
cssValues
:
string
[]
)
:
EmbeddedHistogramChartBuilder
Parameters
cssValues
:
string
[]
Returns
EmbeddedHistogramChartBuilder
set
Hidden
Dimension
Strategy
setHiddenDimensionStrategy
(
strategy
:
ChartHiddenDimensionStrategy
,
)
:
EmbeddedChartBuilder
Parameters
strategy
:
ChartHiddenDimensionStrategy
Returns
EmbeddedChartBuilder
set
Legend
Position
setLegendPosition
(
position
:
GoogleAppsScript
.
Charts
.
Position
,
)
:
EmbeddedHistogramChartBuilder
Parameters
position
:
GoogleAppsScript
.
Charts
.
Position
Returns
EmbeddedHistogramChartBuilder
set
Legend
Text
Style
setLegendTextStyle
(
textStyle
:
GoogleAppsScript
.
Charts
.
TextStyle
,
)
:
EmbeddedHistogramChartBuilder
Parameters
textStyle
:
GoogleAppsScript
.
Charts
.
TextStyle
Returns
EmbeddedHistogramChartBuilder
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
)
:
EmbeddedHistogramChartBuilder
Parameters
start
:
number
end
:
number
Returns
EmbeddedHistogramChartBuilder
set
Stacked
setStacked
()
:
EmbeddedHistogramChartBuilder
Returns
EmbeddedHistogramChartBuilder
set
Title
setTitle
(
chartTitle
:
string
)
:
EmbeddedHistogramChartBuilder
Parameters
chartTitle
:
string
Returns
EmbeddedHistogramChartBuilder
set
Title
Text
Style
setTitleTextStyle
(
textStyle
:
GoogleAppsScript
.
Charts
.
TextStyle
,
)
:
EmbeddedHistogramChartBuilder
Parameters
textStyle
:
GoogleAppsScript
.
Charts
.
TextStyle
Returns
EmbeddedHistogramChartBuilder
set
Transpose
Rows
And
Columns
setTransposeRowsAndColumns
(
transpose
:
boolean
)
:
EmbeddedChartBuilder
Parameters
transpose
:
boolean
Returns
EmbeddedChartBuilder
set
X
Axis
Text
Style
setXAxisTextStyle
(
textStyle
:
GoogleAppsScript
.
Charts
.
TextStyle
,
)
:
EmbeddedHistogramChartBuilder
Parameters
textStyle
:
GoogleAppsScript
.
Charts
.
TextStyle
Returns
EmbeddedHistogramChartBuilder
set
X
Axis
Title
setXAxisTitle
(
title
:
string
)
:
EmbeddedHistogramChartBuilder
Parameters
title
:
string
Returns
EmbeddedHistogramChartBuilder
set
X
Axis
Title
Text
Style
setXAxisTitleTextStyle
(
textStyle
:
GoogleAppsScript
.
Charts
.
TextStyle
,
)
:
EmbeddedHistogramChartBuilder
Parameters
textStyle
:
GoogleAppsScript
.
Charts
.
TextStyle
Returns
EmbeddedHistogramChartBuilder
set
Y
Axis
Text
Style
setYAxisTextStyle
(
textStyle
:
GoogleAppsScript
.
Charts
.
TextStyle
,
)
:
EmbeddedHistogramChartBuilder
Parameters
textStyle
:
GoogleAppsScript
.
Charts
.
TextStyle
Returns
EmbeddedHistogramChartBuilder
set
Y
Axis
Title
setYAxisTitle
(
title
:
string
)
:
EmbeddedHistogramChartBuilder
Parameters
title
:
string
Returns
EmbeddedHistogramChartBuilder
set
Y
Axis
Title
Text
Style
setYAxisTitleTextStyle
(
textStyle
:
GoogleAppsScript
.
Charts
.
TextStyle
,
)
:
EmbeddedHistogramChartBuilder
Parameters
textStyle
:
GoogleAppsScript
.
Charts
.
TextStyle
Returns
EmbeddedHistogramChartBuilder
use
Log
Scale
useLogScale
()
:
EmbeddedHistogramChartBuilder
Returns
EmbeddedHistogramChartBuilder
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 histogram charts. For more details, see the Gviz documentation.