openpyxl.chart.trendline.
Trendline
(
name=None
,
spPr=None
,
trendlineType='linear'
,
order=None
,
period=None
,
forward=None
,
backward=None
,
intercept=None
,
dispRSqr=None
,
dispEq=None
,
trendlineLbl=None
,
extLst=None
)
[source]
¶
backward
¶
Values must be of type <class ‘float’>
dispEq
¶
Values must be of type <class ‘bool’>
dispRSqr
¶
Values must be of type <class ‘bool’>
extLst
¶
Values must be of type <class ‘openpyxl.descriptors.excel.ExtensionList’>
forward
¶
Values must be of type <class ‘float’>
graphicalProperties
¶
Aliases can be used when either the desired attribute name is not allowed or confusing in Python (eg. “type”) or a more descriptve name is desired (eg. “underline” for “u”)
intercept
¶
Values must be of type <class ‘float’>
name
¶
Values must be of type <class ‘str’>
order
¶
Values must be of type <class ‘int’>
period
¶
Values must be of type <class ‘int’>
spPr
¶
Values must be of type <class ‘openpyxl.chart.shapes.GraphicalProperties’>
tagname
= 'trendline'
¶
trendlineLbl
¶
Values must be of type <class ‘openpyxl.chart.trendline.TrendlineLabel’>
trendlineType
¶
Value must be one of {‘movingAvg’, ‘poly’, ‘log’, ‘linear’, ‘exp’, ‘power’}
openpyxl.chart.trendline.
TrendlineLabel
(
layout=None
,
tx=None
,
numFmt=None
,
spPr=None
,
txPr=None
,
extLst=None
)
[source]
¶
extLst
¶
Values must be of type <class ‘openpyxl.descriptors.excel.ExtensionList’>
graphicalProperties
¶
Aliases can be used when either the desired attribute name is not allowed or confusing in Python (eg. “type”) or a more descriptve name is desired (eg. “underline” for “u”)
layout
¶
Values must be of type <class ‘openpyxl.chart.layout.Layout’>
numFmt
¶
Values must be of type <class ‘openpyxl.chart.data_source.NumFmt’>
spPr
¶
Values must be of type <class ‘openpyxl.chart.shapes.GraphicalProperties’>
tagname
= 'trendlineLbl'
¶
textProperties
¶
Aliases can be used when either the desired attribute name is not allowed or confusing in Python (eg. “type”) or a more descriptve name is desired (eg. “underline” for “u”)
tx
¶
Values must be of type <class ‘openpyxl.chart.text.Text’>
txPr
¶
Values must be of type <class ‘openpyxl.chart.text.RichText’>