openpyxl.chart.trendline module
- class 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]
Bases:
Serialisable
- 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
Values must be of type <class ‘openpyxl.chart.shapes.GraphicalProperties’>
- 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 {‘linear’, ‘exp’, ‘power’, ‘poly’, ‘movingAvg’, ‘log’}
- class openpyxl.chart.trendline.TrendlineLabel(layout=None, tx=None, numFmt=None, spPr=None, txPr=None, extLst=None)[source]
Bases:
Serialisable
- extLst
Values must be of type <class ‘openpyxl.descriptors.excel.ExtensionList’>
- graphicalProperties
Values must be of type <class ‘openpyxl.chart.shapes.GraphicalProperties’>
- 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
Values must be of type <class ‘openpyxl.chart.text.RichText’>
- tx
Values must be of type <class ‘openpyxl.chart.text.Text’>
- txPr
Values must be of type <class ‘openpyxl.chart.text.RichText’>