Chart2 Direct Series Data Labels Borders (Static)

Overview

The ooodev.format.chart2.direct.series.data_labels.borders.LineProperties class gives the same options as the Chart Data Labels Border dialog as seen in Fig. 765.

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

Fig. 765 Chart Data Labels Borders Default Dialog

Setup

import uno
from ooodev.format.chart2.direct.series.data_labels.borders import LineProperties as LblLineProperties
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_lbl_border = LblLineProperties(color=StandardColor.MAGENTA_DARK1, width=0.75)
        Chart2.style_data_series(chart_doc=chart_doc, styles=[data_lbl_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 labels border line properties.

Before formatting the chart is seen in Fig. 829.

Style Data Series

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

The results are seen in Fig. 766 and Fig. 767

Fig. 766 Chart with series data labels border set

Style Data Point

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

The results are seen in Fig. 768.

Fig. 768 Chart with point data labels border set