openpyxl.chart.series module
- class openpyxl.chart.series.Series(idx=0, order=0, tx=None, spPr=None, pictureOptions=None, dPt=(), dLbls=None, trendline=None, errBars=None, cat=None, val=None, invertIfNegative=None, shape=None, xVal=None, yVal=None, bubbleSize=None, bubble3D=None, marker=None, smooth=None, explosion=None, extLst=None)[source]
Bases:
SerialisableGeneric series object. Should not be instantiated directly. User the chart.Series factory instead.
- bubble3D
Values must be of type <class ‘bool’>
- bubbleSize
Values must be of type <class ‘openpyxl.chart.data_source.NumDataSource’>
- cat
Values must be of type <class ‘openpyxl.chart.data_source.AxDataSource’>
- dLbls
Values must be of type <class ‘openpyxl.chart.label.DataLabelList’>
- dPt
A sequence (list or tuple) that may only contain objects of the declared type
- data_points
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”)
- errBars
Values must be of type <class ‘openpyxl.chart.error_bar.ErrorBars’>
- explosion
Values must be of type <class ‘int’>
- 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”)
- identifiers
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”)
- idx
Values must be of type <class ‘int’>
- invertIfNegative
Values must be of type <class ‘bool’>
- labels
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”)
- marker
Values must be of type <class ‘openpyxl.chart.marker.Marker’>
- order
Values must be of type <class ‘int’>
- pictureOptions
Values must be of type <class ‘openpyxl.chart.picture.PictureOptions’>
- shape
Value must be one of {‘pyramidToMax’, ‘box’, ‘pyramid’, ‘cone’, ‘coneToMax’, ‘cylinder’}
- smooth
Values must be of type <class ‘bool’>
- spPr
Values must be of type <class ‘openpyxl.chart.shapes.GraphicalProperties’>
- tagname = 'ser'
- title
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”)
- trendline
Values must be of type <class ‘openpyxl.chart.trendline.Trendline’>
- tx
Values must be of type <class ‘openpyxl.chart.series.SeriesLabel’>
- val
Values must be of type <class ‘openpyxl.chart.data_source.NumDataSource’>
- xVal
Values must be of type <class ‘openpyxl.chart.data_source.AxDataSource’>
- yVal
Values must be of type <class ‘openpyxl.chart.data_source.NumDataSource’>
- zVal
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”)
- class openpyxl.chart.series.SeriesLabel(strRef=None, v=None)[source]
Bases:
Serialisable- strRef
Values must be of type <class ‘openpyxl.chart.data_source.StrRef’>
- tagname = 'tx'
- v
Values must be of type <class ‘str’>
- value
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”)
- class openpyxl.chart.series.XYSeries(idx=0, order=0, tx=None, spPr=None, pictureOptions=None, dPt=(), dLbls=None, trendline=None, errBars=None, cat=None, val=None, invertIfNegative=None, shape=None, xVal=None, yVal=None, bubbleSize=None, bubble3D=None, marker=None, smooth=None, explosion=None, extLst=None)[source]
Bases:
SeriesDedicated series for charts that have x and y series
- bubble3D
Values must be of type <class ‘bool’>
- bubbleSize
Values must be of type <class ‘openpyxl.chart.data_source.NumDataSource’>
- dLbls
Values must be of type <class ‘openpyxl.chart.label.DataLabelList’>
- dPt
A sequence (list or tuple) that may only contain objects of the declared type
- errBars
Values must be of type <class ‘openpyxl.chart.error_bar.ErrorBars’>
- idx
Values must be of type <class ‘int’>
- invertIfNegative
Values must be of type <class ‘bool’>
- marker
Values must be of type <class ‘openpyxl.chart.marker.Marker’>
- order
Values must be of type <class ‘int’>
- smooth
Values must be of type <class ‘bool’>
- spPr
Values must be of type <class ‘openpyxl.chart.shapes.GraphicalProperties’>
- trendline
Values must be of type <class ‘openpyxl.chart.trendline.Trendline’>
- tx
Values must be of type <class ‘openpyxl.chart.series.SeriesLabel’>
- xVal
Values must be of type <class ‘openpyxl.chart.data_source.AxDataSource’>
- yVal
Values must be of type <class ‘openpyxl.chart.data_source.NumDataSource’>
