We will be migrating from Ask to Discourse on the first week of August, read the details here

Ask Your Question

Set default formatting for Calc charts [closed]

asked 2012-11-28 19:50:39 +0200

endolith gravatar image

updated 2020-07-29 00:17:25 +0200

Alex Kemp gravatar image

Is there any way to set a default format for Calc charts?

Currently, every time I make a chart, I have to tediously adjust all these things manually:

  • change each data range of scatter plots to circular icon, one at a time
  • reduce the icon size to 0.15 cm
  • add minor and major grid lines in both dimensions
  • change minor gridlines to 10% gray
  • set minor interval count to 5 or 10 instead of the default 2
  • set positioning of both axes to "Start"
  • set minimum scale to a power of 10 on log scales
  • set minimum and maximum scale to fit the data without huge whitespace (especially since it always tries to include 0 even when my data doesn't include 0)

I do these settings over and over again every time I make a graph, multiple times per week. I'd like to make this the default format for all future graphs. Is there any way to do this? Even hacking around in the source code or something?

edit retag flag offensive reopen merge delete

Closed for the following reason the question is answered, right answer was accepted by Alex Kemp
close date 2020-07-29 00:17:42.745039



I am too very interested in this answer. I suffer from the same waste of time.

ROSt52 gravatar imageROSt52 ( 2012-11-29 03:38:44 +0200 )edit

6 Answers

Sort by » oldest newest most voted

answered 2012-12-14 06:14:35 +0200

ROSt52 gravatar image

When I consider the quite large amount of work needed to customize a chart, I would like to propose an enhancement request to have styles for charts. By having them any number of styles could be stored and applied by selecting a chart and double click the chart style.

endoltih as you brought the topic up, please feel free to make and enhancement request. It needs to be made as a bug report.


May I ask to publish the bug number later here to enable all to add comments?

edit flag offensive delete link more

answered 2012-11-29 00:21:10 +0200

w_whalley gravatar image

I don't know how to do that, but this might be almost as good. Tweak your chart to your satisfaction and save it in a spreadsheet. When you want the same graph type in a new spreadsheet copy it from the original and paste it in the new spreadsheet. Then you just need to edit the data ranges, labels, etc.

edit flag offensive delete link more


So I either have to manually edit the format, or I have to manually edit the data ranges. Sounds like the same amount of work. :/

endolith gravatar imageendolith ( 2012-11-29 15:53:11 +0200 )edit

I use the same approach as WW. It works. Changing data ranges takes minimal effort compared to modifying the chart parameters mentioned, especially if you frequently chart the same number of plots (lines). If dataset is the same size and configuration, labels will load automatically. 喜びを広げる

vbas96 gravatar imagevbas96 ( 2012-12-14 05:59:18 +0200 )edit

Does endolith understand Japanese?

How many people in this forum do read Japanese?

Just some fodder for thoughts/

ROSt52 gravatar imageROSt52 ( 2012-12-14 06:04:44 +0200 )edit

I noticed your interest ROSt52. Took some time on translate.google to try to figure which of the four forms of "Spread the" to use. Then I discovered the verb and object are inverted from my usual...and the imperative sentence form is rare in Japanese. Hope I got it right. Spread the joy!

vbas96 gravatar imagevbas96 ( 2012-12-14 06:31:13 +0200 )edit

vbas96, you would have better said 喜びに広げる をー>に

ROSt52 gravatar imageROSt52 ( 2012-12-14 16:04:05 +0200 )edit

answered 2013-03-30 06:47:59 +0200

ROSt52 gravatar image

updated 2020-05-01 23:58:50 +0200

endolith gravatar image

An enhancement request is filed. Please add comments.


edit flag offensive delete link more


Triggered by the answer of @Phorious I look at my above enhancement request and saw the bug number is wrong. Above bug concerns log scales.

The enhancement request for chart styles in the style window is fdo#62925

ROSt52 gravatar imageROSt52 ( 2013-05-23 06:11:43 +0200 )edit

Yes... I made a mistake, hehe. Neither I checked the number.

Phorious gravatar imagePhorious ( 2013-05-23 06:23:03 +0200 )edit

@Phorious - Then we both might have made a mistake I provided the link to 62924 in my 30Mar-2013 answer instead of the 62295. Sometimes new answers and/or comments help to improve

ROSt52 gravatar imageROSt52 ( 2013-05-23 10:32:58 +0200 )edit

answered 2013-02-23 22:32:00 +0200

fractal618 gravatar image

updated 2013-02-23 22:36:45 +0200

SUPER BUMP! The icon size should be 0.10cm by default. 0.25cm looks bad most of the time.

Also, the legend should be OFF by default, most of the time people don't need a legend for simple graphs.

This has been a frequent suggestion/request on many forums.

edit flag offensive delete link more

answered 2013-05-23 05:26:35 +0200

Phorious gravatar image

Hi. I suffer the same problem with charts in LibO. I have filled a bug about this issue: https://bugs.freedesktop.org/show_bug.cgi?id=64886

Please, add your opinions there, because the person that revised it, marked it as "nonsense".

Also, I have already filled some chart related bugs: 39052, 58038, 58260, 62540 (related to 62924 reported by ROSt52), 64884. If you know related bug reports that could be dups, please, mark them.

edit flag offensive delete link more

answered 2013-03-08 15:04:19 +0200

ROSt52 gravatar image

@endolith - did you actually posted an enhancement request for this topic?

edit flag offensive delete link more


no I have not

endolith gravatar imageendolith ( 2013-03-30 04:17:05 +0200 )edit

Question Tools



Asked: 2012-11-28 19:50:39 +0200

Seen: 6,573 times

Last updated: May 01 '20