Formating Multiple Data Series in Calc XY Charts

users
#1

I have an application that requires a large number of data series to be plotted as an XY chart on the same axes.
By default, each data series is plotted using a different symbol and colour but I need them to all use the same symbol and colour (specifically a small black dot).
Of course, it's easy to edit every data series individually but this would be a very laborious process.
I'd be interested if anyone knows of a simpler way of achieving this, even if it involves writing a macro.
Thanks in anticipation of your response.

#2

Make charts XY is little complicate but possible... look attach example gif.

This chart I generate with this code:

import easymacro as app

def chart_xy():
    doc = app.get_document()
    sheet = doc['Sheet1']
    data = sheet['A1'].current_region
    cell = sheet['A13']
    name = 'MyChartXY'
    if not sheet.exists_chart(name):
        with cell.create_chart('XY') as c:
            c.name = name
            c.data = data
            c.width = 10000
            c.height = 8000
            c.title.String = 'Test'
            c.legend.CharColor = app.get_color('black')

easymacro is my library for easy develop macros in LibreOffice... you can more information in:
https://gitlab.com/mauriciobaeza/zaz/wikis/easymacro.py

If you not have problem with Python, I can add custom function for setting each serie like you need.

Best regards.

#3

I make this example in:

https://gitlab.com/snippets/1913430