How to set styles for charts

[ryanmk54]

I created a spreadsheet with charts. I opened it with excel and messed with the styles to see if I could get it to look good. I gave up but now the chart styles are screwed up. The data ranges and everything is still fine. Is there any way to set the appearance of the charts to a defaults that they were when they were first created?

[mariosv]

Please take a look to this thread.

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 mini…