A Calc chart can read its data from spreadsheet cells, and the chart is dynamic: if the data changes. However, the title and labels of the chart can only be entered as fixed values - they cannot be read from a spreadsheet cell. My request is that (Calc) charts should be enhanced to similarly allow dynamic titles and labels. This will give the user much more flexibility in making charts that can be used as a template where data AND titles/label can be changed without "manual" editing of the diagram. I often miss this feature when analyzing data in Calc. Often I set up a series of charts to present a sample data set in the way I wish. Afterwards, I use the final spreadsheet with charts to analyse other data sets. While diagrams can dynamically change to reflect the new data, I have to manually change titles and labels, even though the titles and labels are given in my data. (M$ Excel already works in this way: If the chart is created from data including headlines, the headlines become dynamic labels connected to the headline cells. As argued above, I consider this a very useful feature.) Any chance of this becoming possible in charts created in Calc (and possibly charts created otherwise)? Best regards, Lars J
Valid request. FYI: Enhancements are handled by volunteers. I'm only confirming that this is a valid request, not that it will *ever* be implemented. It might be implemented soon, it might never be implemented, all up to who finds it interesting.
The ODF file format allows a cell range for title, subtitle, x-axis title and for y-axis title. Only LibreOffice has not implemented it.
*** Bug 116729 has been marked as a duplicate of this bug. ***
For me too, this would be an invaluable feature.
Please implement this enhancement!
I need that too. I work with many graphs 20+. As set them as templates and it is very annoying to change titles / subtitles etc. each time Thank community for such great projects.
*** Bug 146858 has been marked as a duplicate of this bug. ***
*** Bug 154936 has been marked as a duplicate of this bug. ***
Perhaps this could be implemented before the request reaches its 10th anniversary? I sometimes think the developers only work with simple workbooks and don't realize how such simple things as this to implement - as already existing in OO code - impacts power users who use spreadsheets for somewhat more than lists.
(In reply to Ian Eales from comment #10) > Perhaps this could be implemented before the request reaches its 10th > anniversary? > > I sometimes think the developers only work with simple workbooks and don't > realize how such simple things as this to implement - as already existing in > OO code - impacts power users who use spreadsheets for somewhat more than > lists. As the proposer of this enhancement, I hope so, too. However, I am also aware that LibreOffice is a project driven by volunteers (as was stated already in comment #1), which is why LO can be distrubuted as free software - free of charge and free of adds. Volunteers tend to focus on the features they use themselves. Take me - I volunteer on keeping the Danish dictionary and the Danish LO translation up-to-date. Those are features that are important to me, and I hope they are of help to quite a few other users, but 99+ % of worldwide LO users will have little interest in the Danish translation. The developers are also volunteers. Surely they will focus on important issues. Unfortunately, it appears that the group of developers that have insight into programming the LO code for charts, does not coincide with the group of users who miss this feature. At least they have not missed it enough to solve it (whicah may be easy or hard, I do not know which). I am sorry that the feature has not (yet) been implemented, but I do not think it will help to use negative words about good-working volunteers. We all have the option of trying to learn programming the code and dig into this subject and solve the problem ourselves. As for me, I'm not there yet. Any volunteers for the job? Best regards, Lars Jødal