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