Set default formatting for Calc charts

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?

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

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.

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. :confused:

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. 喜びを広げる

Does endolith understand Japanese?

How many people in this forum do read Japanese?

Just some fodder for thoughts/

I noticed your interest ROSt52. Took some time on 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, you would have better said 喜びに広げる をー>に

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?

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.

An enhancement request is filed. Please add comments.

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

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

@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

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

no I have not

Hi. I suffer the same problem with charts in LibO. I have filled a bug about this issue:

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.