Ask Your Question

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

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

Anton gravatar image

updated 2015-12-02 18:48:03 +0200

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 close merge delete

1 Answer

Sort by » oldest newest most voted

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

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
Login/Signup to Answer

Question Tools

1 follower


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

Seen: 122 times

Last updated: Dec 02 '15