Source code

Download source archive ↓

src/openpyxl/chart/series_factory.py

1# Copyright (c) 2010-2024 openpyxl
2
3from .data_source import NumDataSource, NumRef, AxDataSource
4from .reference import Reference
5from .series import Series, XYSeries, SeriesLabel, StrRef
6from  openpyxl.utils import rows_from_range, quote_sheetname
7
8
9def SeriesFactory(values, xvalues=None, zvalues=None, title=None, title_from_data=False):
10    """
11    Convenience Factory for creating chart data series.
12    """
13
14    if not isinstance(values, Reference):
15        values = Reference(range_string=values)
16
17    if title_from_data:
18        cell = values.pop()
19        title = u"{0}!{1}".format(values.sheetname, cell)
20        title = SeriesLabel(strRef=StrRef(title))
21    elif title is not None:
22        title = SeriesLabel(v=title)
23
24    source = NumDataSource(numRef=NumRef(f=values))
25    if xvalues is not None:
26        if not isinstance(xvalues, Reference):
27            xvalues = Reference(range_string=xvalues)
28        series = XYSeries()
29        series.yVal = source
30        series.xVal = AxDataSource(numRef=NumRef(f=xvalues))
31        if zvalues is not None:
32            if not isinstance(zvalues, Reference):
33                zvalues = Reference(range_string=zvalues)
34            series.zVal = NumDataSource(NumRef(f=zvalues))
35    else:
36        series = Series()
37        series.val = source
38
39    if title is not None:
40        series.title = title
41    return series