# 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)

  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

    Aliases can be used when either the desired attribute name is not allowed or confusing in Python (eg. “type”) or a more descriptive 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 [‘exp’, ‘linear’, ‘log’, ‘movingAvg’, ‘poly’, ‘power’]

class openpyxl.chart.trendline.TrendlineLabel(layout=None, tx=None, numFmt=None, spPr=None, txPr=None, extLst=None)

  Bases: `Serialisable`

  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 descriptive 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 descriptive 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’>