When a new chart needs to be created it always starts up with the default and hast to tune to the personal or company format needs. This takes always a lot of time, thus a loss on productivity.
Add "Chart-Styles" to Calc, which allow creating and saving formats for several chart styles. In one chart-style all possible features of a chart should be customizable.
I can be contacted for discussions and tests
Operating System: Windows XP
Version: 18.104.22.168 release
I agree, this would be a very good idea. More standard chart types would also be very good like bar of pie chart, etc.
@A - Thanks for looking into this matter. Feel free to add also more standard charts. This makes customization already a bit easier. However, with the styles, LibO would beat MSO with a great functionality. I just keep fingers crossed for dev manpower.
Bug 62540 describes something very similar. IMHO it is not exactly an exact duplicate, but it might make sense to join the two bug entries.
I put Francisco of that bug entry to this one here in CC.
There is another bug which is quite similar to this one, but also has a slight different twist: Bug 39097
(In reply to comment #3)
> Bug 62540 describes something very similar. IMHO it is not exactly an exact
> duplicate, but it might make sense to join the two bug entries.
> I put Francisco of that bug entry to this one here in CC.
> There is another bug which is quite similar to this one, but also has a
> slight different twist: Bug 39097
Hi Gerry, thanks for let me join this talk.
Well, in some way, it _is_ a duplicate of what I wanted to report in first place: it is a really slow task to edit format charts in Calc. What could we do?
· Add chart styles
· Add other customization options for the defaults presets of charts (not only colors)
Then I realized that the problem was a pretty bigger, since not even textboxes drawn inside charts are editable through styles. Then I stated that charts need some improvement in general, though the implementation of styles is a real step fordward in this goal.
I was vivisecting an ODS file, trying to see how does LibO handle styles for charts, since it's supposed that using ODF, you're using styles even if don't want.
Charts content, as for any object are stored inside dirs "Object #", where there are 3 files: meta.xml, content.xml and styles.xml.
Interestingly, the file styles.xml doesn't store any style, but all styles defined for charts are stored in content.xml around "<office:automatic-styles>"
It seems to be that this feature request will be more difficult to solve
@Francisco - Thanks for looking into this matter and for your comments. Now I - and I assume that there are many others waiting for this enhancement - can only wait to see if there is a great volunteer who will tackle the topic.
This feature would - to the best of my knowledge - put Impress on the same and maybe even a bit better level than PowerPoint. I remember that there are User styles but this was not very satisfactory; at least for me.
Created attachment 83915 [details]
proposed new chart style : StairsToTotal
As there are also new chart styles considered I would like to propose the style "Stairs to Total". A style I am using very often instead of stacked column style to emphasis the gain for each step separately.
This is also very often to be seen in chart created by consulting companies.
Current creation requires additional data preparation and a lot of formating work; thus very time consuming.
Additional to comment 7
I feel that this is a great feature above MS Excel.
In Excel 2003 this style was not available; I missed it a lot. Could a newer Excel version please be checked by someone who also has access to MS Excel >=2007?
I add my support for this request. I blog and do technical work using a lot of charts. For blogging, I create the charts and then embed them in my website as a fixed number of pixels. On a high-resolution screen, the image is often barely readable using the defaults for titles, axes-labels, legends and data-labels, so I have to adjust fonts repeatedly. It takes more time to manually format the chart than it does to gather the data for the spreadsheet and upload the image to the server. It is a major hit and I have to remember the font-sizes for several categories of items and font-faces, or articles with multiple charts look amateurish. It could be just one click to avoid a lot of work and errors.
The newly added ability to export as SVG helps in quality but I still have to work with font-size on one end and pixels on the other...
This is also an accessibility issue in that old eyes like mine need the larger fonts. It's not only about convenience/productivity.
The whole idea of using XML in the file-format is to be able to separate style from content. Not using that philosophy for charts and hard-coding these in the software is something that should be fixed. Now that SVG is well supported, this would make LibreOffice nearly perfect for what I do. If we cannot do this with styling, please let us save and insert from templates. Saving the chart styling in a whole-document template doesn't work because the data-ranges then have to be edited and there might be a dozen of them.
Could it be a good idea if anybody creates an entry in "Vote vor enhancement" page?
If I understand clearly, this report is the same / duplicate to Bug 62540 (which is reported earlier). Shouldn't we merge these to only 1 report?
*** Bug 62540 has been marked as a duplicate of this bug. ***
As Francisco suggested, I added this bug to the Vote for Enhancement page on the wiki: https://wiki.documentfoundation.org/Vote_for_Enhancement#Bug_62925_-_FORMATTING:_enhancement:_please_add_.22chart_styles.22_to_the_styles_of_Calc
Feel free to add your vote.
(In reply to comment #0)
> When a new chart needs to be created it always starts up with the default
> and hast to tune to the personal or company format needs.
You can copyk&paste an existing one often and then drag a new data-range to it.
Nevertheless: a very useful enhancement request!
(In reply to comment #14)
> (In reply to comment #0)
> > When a new chart needs to be created it always starts up with the default
> > and hast to tune to the personal or company format needs.
> You can copyk&paste an existing one often and then drag a new data-range to
> Nevertheless: a very useful enhancement request!
That's not so easy: you must have already in the same spreadsheet a chart formatted in the way you want. You cannot copy a formatted chart from another file (though maybe you can insert that one sheet).
But yes, that's is what we do now ;-)
As I needed create a larger number of charts in a company format, I looked here to see how things are developing.
Thanks to all who worked and work on this enhancement. I can offer testing if needed.
*** Bug 74408 has been marked as a duplicate of this bug. ***
I would like to vote for this and other enhancement request I found here
However, also reading the explanation "Please add a short comment (1 line) starting with # at the end of the list you want to support and sign with -- ~~~~ . Good arguments have more influence than numerous votes." I cannot figure what I need to do.
Can I please have some voting-for-dummies advice?
(In reply to comment #18)
> I would like to vote for this and other enhancement request I found here
> However, also reading the explanation "Please add a short comment (1 line)
> starting with # at the end of the list you want to support and sign with --
> ~~~~ . Good arguments have more influence than numerous votes." I cannot
> figure what I need to do.
> Can I please have some voting-for-dummies advice?
# Be sincere
# Be concise but clear, not everyone could be experiencing your situation, nor have the time to read a testament
# Don't be selfish, remember, you may need a feature, while other people would prefer another.
# Don't use adjectives to exaggerate your request
I created a page for this bug "Chart Styles" on the Documentfoundation wiki in order to collect ideas and updates with regards to this bug:
Furthermore, there is some important movement: German and Swiss cities and institutions fund dvelopment on this feature and they just opened a tender:
http://www.osb-alliance.de/working-groups/projekte/wichtige-funktionalitaeten-bei-loaoo/ (in German language)
There is also a pdf in English that details the enhancements: http://www.osb-alliance.de/fileadmin/Working_Groups/OfficeInteroperability/Project2/SpecificationMajorFeatureImprovements_final.pdf
This is excellent news!
I hope we get this feature soon.
I willl keep fingers crossed that budget will be provided.
*** Bug 46173 has been marked as a duplicate of this bug. ***
*** Bug 90936 has been marked as a duplicate of this bug. ***
My request was referenced to be fitting to the discussion here. I also very much like the request for pre-defined chart styles. I would ask you to consider a pre-defined pattern style that can be applied to an entire chart so that colourblind people have it easier to read the chart.
Example of a pattern I am referring to: http://support.sas.com/kb/45/addl/fusion_45663_1_fillpatterns1.png
*** Bug 40813 has been marked as a duplicate of this bug. ***