Ask Your Question

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

asked 2015-11-29 11:17:54 +0100

Anton gravatar image

updated 2020-08-27 18:56:26 +0100

Alex Kemp gravatar image

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 under OS X El Capitan 10.11.1

edit retag flag offensive reopen merge delete

Closed for the following reason question is not relevant or outdated by Alex Kemp
close date 2020-07-21 19:13:46.873128

1 Answer

Sort by » oldest newest most voted

answered 2015-12-02 11:35:58 +0100

pierre-yves samyn gravatar image


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 ClickData RangesData Range tab to just update the sheet name.


edit flag offensive delete link more

Question Tools

1 follower


Asked: 2015-11-29 11:15:40 +0100

Seen: 177 times

Last updated: Dec 02 '15