Google Apps Script API
Preparing search index...
google-apps-script-events
GoogleAppsScript
Spreadsheet
EmbeddedLineChartBuilder
Interface EmbeddedLineChartBuilder
Builder for line charts. For more details, see the Gviz documentation.
interface
EmbeddedLineChartBuilder
{
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
()
:
EmbeddedLineChartBuilder
;
setBackgroundColor
(
cssValue
:
string
)
:
EmbeddedLineChartBuilder
;
setChartType
(
type
:
ChartType
)
:
EmbeddedChartBuilder
;
setColors
(
cssValues
:
string
[]
)
:
EmbeddedLineChartBuilder
;
setCurveStyle
(
style
:
CurveStyle
)
:
EmbeddedLineChartBuilder
;
setHiddenDimensionStrategy
(
strategy
:
ChartHiddenDimensionStrategy
,
)
:
EmbeddedChartBuilder
;
setLegendPosition
(
position
:
GoogleAppsScript
.
Charts
.
Position
,
)
:
EmbeddedLineChartBuilder
;
setLegendTextStyle
(
textStyle
:
GoogleAppsScript
.
Charts
.
TextStyle
,
)
:
EmbeddedLineChartBuilder
;
setMergeStrategy
(
mergeStrategy
:
ChartMergeStrategy
)
:
EmbeddedChartBuilder
;
setNumHeaders
(
headers
:
number
)
:
EmbeddedChartBuilder
;
setOption
(
option
:
string
,
value
:
any
)
:
EmbeddedChartBuilder
;
setPointStyle
(
style
:
PointStyle
)
:
EmbeddedLineChartBuilder
;
setPosition
(
anchorRowPos
:
number
,
anchorColPos
:
number
,
offsetX
:
number
,
offsetY
:
number
,
)
:
EmbeddedChartBuilder
;
setRange
(
start
:
number
,
end
:
number
)
:
EmbeddedLineChartBuilder
;
setTitle
(
chartTitle
:
string
)
:
EmbeddedLineChartBuilder
;
setTitleTextStyle
(
textStyle
:
GoogleAppsScript
.
Charts
.
TextStyle
,
)
:
EmbeddedLineChartBuilder
;
setTransposeRowsAndColumns
(
transpose
:
boolean
)
:
EmbeddedChartBuilder
;
setXAxisTextStyle
(
textStyle
:
GoogleAppsScript
.
Charts
.
TextStyle
,
)
:
EmbeddedLineChartBuilder
;
setXAxisTitle
(
title
:
string
)
:
EmbeddedLineChartBuilder
;
setXAxisTitleTextStyle
(
textStyle
:
GoogleAppsScript
.
Charts
.
TextStyle
,
)
:
EmbeddedLineChartBuilder
;
setYAxisTextStyle
(
textStyle
:
GoogleAppsScript
.
Charts
.
TextStyle
,
)
:
EmbeddedLineChartBuilder
;
setYAxisTitle
(
title
:
string
)
:
EmbeddedLineChartBuilder
;
setYAxisTitleTextStyle
(
textStyle
:
GoogleAppsScript
.
Charts
.
TextStyle
,
)
:
EmbeddedLineChartBuilder
;
useLogScale
()
:
EmbeddedLineChartBuilder
;
}
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
Curve
Style
set
Hidden
Dimension
Strategy
set
Legend
Position
set
Legend
Text
Style
set
Merge
Strategy
set
Num
Headers
set
Option
set
Point
Style
set
Position
set
Range
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
()
:
EmbeddedLineChartBuilder
Returns
EmbeddedLineChartBuilder
set
Background
Color
setBackgroundColor
(
cssValue
:
string
)
:
EmbeddedLineChartBuilder
Parameters
cssValue
:
string
Returns
EmbeddedLineChartBuilder
set
Chart
Type
setChartType
(
type
:
ChartType
)
:
EmbeddedChartBuilder
Parameters
type
:
ChartType
Returns
EmbeddedChartBuilder
set
Colors
setColors
(
cssValues
:
string
[]
)
:
EmbeddedLineChartBuilder
Parameters
cssValues
:
string
[]
Returns
EmbeddedLineChartBuilder
set
Curve
Style
setCurveStyle
(
style
:
CurveStyle
)
:
EmbeddedLineChartBuilder
Parameters
style
:
CurveStyle
Returns
EmbeddedLineChartBuilder
set
Hidden
Dimension
Strategy
setHiddenDimensionStrategy
(
strategy
:
ChartHiddenDimensionStrategy
,
)
:
EmbeddedChartBuilder
Parameters
strategy
:
ChartHiddenDimensionStrategy
Returns
EmbeddedChartBuilder
set
Legend
Position
setLegendPosition
(
position
:
GoogleAppsScript
.
Charts
.
Position
,
)
:
EmbeddedLineChartBuilder
Parameters
position
:
GoogleAppsScript
.
Charts
.
Position
Returns
EmbeddedLineChartBuilder
set
Legend
Text
Style
setLegendTextStyle
(
textStyle
:
GoogleAppsScript
.
Charts
.
TextStyle
,
)
:
EmbeddedLineChartBuilder
Parameters
textStyle
:
GoogleAppsScript
.
Charts
.
TextStyle
Returns
EmbeddedLineChartBuilder
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
Point
Style
setPointStyle
(
style
:
PointStyle
)
:
EmbeddedLineChartBuilder
Parameters
style
:
PointStyle
Returns
EmbeddedLineChartBuilder
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
)
:
EmbeddedLineChartBuilder
Parameters
start
:
number
end
:
number
Returns
EmbeddedLineChartBuilder
set
Title
setTitle
(
chartTitle
:
string
)
:
EmbeddedLineChartBuilder
Parameters
chartTitle
:
string
Returns
EmbeddedLineChartBuilder
set
Title
Text
Style
setTitleTextStyle
(
textStyle
:
GoogleAppsScript
.
Charts
.
TextStyle
,
)
:
EmbeddedLineChartBuilder
Parameters
textStyle
:
GoogleAppsScript
.
Charts
.
TextStyle
Returns
EmbeddedLineChartBuilder
set
Transpose
Rows
And
Columns
setTransposeRowsAndColumns
(
transpose
:
boolean
)
:
EmbeddedChartBuilder
Parameters
transpose
:
boolean
Returns
EmbeddedChartBuilder
set
X
Axis
Text
Style
setXAxisTextStyle
(
textStyle
:
GoogleAppsScript
.
Charts
.
TextStyle
,
)
:
EmbeddedLineChartBuilder
Parameters
textStyle
:
GoogleAppsScript
.
Charts
.
TextStyle
Returns
EmbeddedLineChartBuilder
set
X
Axis
Title
setXAxisTitle
(
title
:
string
)
:
EmbeddedLineChartBuilder
Parameters
title
:
string
Returns
EmbeddedLineChartBuilder
set
X
Axis
Title
Text
Style
setXAxisTitleTextStyle
(
textStyle
:
GoogleAppsScript
.
Charts
.
TextStyle
,
)
:
EmbeddedLineChartBuilder
Parameters
textStyle
:
GoogleAppsScript
.
Charts
.
TextStyle
Returns
EmbeddedLineChartBuilder
set
Y
Axis
Text
Style
setYAxisTextStyle
(
textStyle
:
GoogleAppsScript
.
Charts
.
TextStyle
,
)
:
EmbeddedLineChartBuilder
Parameters
textStyle
:
GoogleAppsScript
.
Charts
.
TextStyle
Returns
EmbeddedLineChartBuilder
set
Y
Axis
Title
setYAxisTitle
(
title
:
string
)
:
EmbeddedLineChartBuilder
Parameters
title
:
string
Returns
EmbeddedLineChartBuilder
set
Y
Axis
Title
Text
Style
setYAxisTitleTextStyle
(
textStyle
:
GoogleAppsScript
.
Charts
.
TextStyle
,
)
:
EmbeddedLineChartBuilder
Parameters
textStyle
:
GoogleAppsScript
.
Charts
.
TextStyle
Returns
EmbeddedLineChartBuilder
use
Log
Scale
useLogScale
()
:
EmbeddedLineChartBuilder
Returns
EmbeddedLineChartBuilder
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
Curve
Style
set
Hidden
Dimension
Strategy
set
Legend
Position
set
Legend
Text
Style
set
Merge
Strategy
set
Num
Headers
set
Option
set
Point
Style
set
Position
set
Range
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 line charts. For more details, see the Gviz documentation.