Chart2 Direct Series Data Series Borders (Static)

Overview

The ooodev.format.chart2.direct.series.data_series.borders.LineProperties class gives the same options as the Chart Data Series Borders dialog as seen in Fig. 743.

Calls to the Chart2.style_data_series() and Chart2.style_data_point() methods are used to set the data series borders of a Chart.

Fig. 743 Chart Data Series Borders Default Dialog

Setup

import uno
from ooodev.format.chart2.direct.series.data_series.borders import LineProperties as SeriesLineProperties
from ooodev.format.chart2.direct.general.borders import LineProperties as ChartLineProperties
from ooodev.format.chart2.direct.general.area import Gradient as ChartGradient, PresetGradientKind
from ooodev.office.calc import Calc
from ooodev.office.chart2 import Chart2
from ooodev.utils.color import StandardColor
from ooodev.gui import GUI
from ooodev.loader.lo import Lo

def main() -> int:
    with Lo.Loader(connector=Lo.ConnectPipe()):
        doc = Calc.open_doc("col_chart.ods")
        GUI.set_visible(True, doc)
        Lo.delay(500)
        Calc.zoom(doc, GUI.ZoomEnum.ZOOM_100_PERCENT)

        sheet = Calc.get_active_sheet()

        Calc.goto_cell(cell_name="A1", doc=doc)
        chart_doc = Chart2.get_chart_doc(sheet=sheet, chart_name="col_chart")

        chart_bdr_line = ChartLineProperties(color=StandardColor.BLUE_LIGHT3, width=0.7)
        chart_grad = ChartGradient.from_preset(chart_doc, PresetGradientKind.TEAL_BLUE)
        Chart2.style_background(chart_doc=chart_doc, styles=[chart_grad, chart_bdr_line])

        data_series_border = SeriesLineProperties(color=StandardColor.MAGENTA_DARK1, width=0.75)
        Chart2.style_data_series(chart_doc=chart_doc, styles=[data_series_border])

        Lo.delay(1_000)
        Lo.close_doc(doc)
    return 0

if __name__ == "__main__":
    SystemExit(main())

Setting Line Properties

The LineProperties class is used to set the data series border line properties.

Before formatting the chart is seen in Fig. 829.

Style Data Series

# ... other code
data_series_border = SeriesLineProperties(color=StandardColor.MAGENTA_DARK1, width=0.75)
Chart2.style_data_series(chart_doc=chart_doc, styles=[data_series_border])

The results are seen in Fig. 744 and Fig. 745.

Fig. 744 Chart with data series border set

Style Data Point

# ... other code
Chart2.style_data_point(chart_doc=chart_doc, series_idx=0, idx=1, styles=[data_series_border])

The results are seen in Fig. 746.

Fig. 746 Chart with data point border set