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:
openpyxl.descriptors.serialisable.Serialisable
Generic 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 {‘coneToMax’, ‘cone’, ‘pyramid’, ‘pyramidToMax’, ‘cylinder’, ‘box’}
-
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:
openpyxl.descriptors.serialisable.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:
openpyxl.chart.series.Series
Dedicated 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’>
-