can I somehow save the specification of a chart as kind of template

[Anton1]

I have a LO Calc spreadsheet with 12 sheets, each sheet is one month. In column A I have entries of Category “Date” and in column B I have entries of Category “Time”. I then make a Chart which shows the dates on the x-axis and the corresponding times on the y-axis. I make many further adjustments in the chart to specify the format of the axis labels, how the lines look, the size of the chart etc.

My problem is, when I want to make charts for the other 11 months, I have to repeat the entire process again. This is very tedious and error prone.

Is there any way how I can somehow save the specification of a chart as kind of template, and just apply this template to new sheets, so that I do not have to specify the chart over and over again?

==

I use LO 4.4.6.3 under OS X El Capitan 10.11.1

[PYS]

Hi

If the data is organized in the same way on each monthly sheet you should be able to copy and paste your graph.
Then Double-click the chart to update then Right Click▸Data Ranges▸Data Range tab to just update the sheet name.

Regards