Bug 146858

Description:
One very handy feature in Excel is linking content in cell to chart title, labels or even text boxes - alone or inserted into a chart.

This function would be very useful in Calc. Let me use the example from my field.

In one of our experiments we measuring friction force to assess coefficient of friction (CoF) between different materials.

And now: if linking text to chart from cell would be possible we would be able to describing conditions of test (eg. type of materials) automatically, by simply copy and paste results from CSV obtained from tribotester (machine for wear materials by means of friction).

Nowadays we must write it manually and it makes possibility to make mistakes or forgot to change chart title.

I believe that a large group of users would benefit from that feature and I think that many of them desire it and look forward to this feature.

REVERENCES TO EXCEL:
1) Excel Tip: Populate a Chart Title from a Cell
https://www.youtube.com/watch?v=7x6BIJbZB5A

2) Link a chart title, label, or text box to a worksheet cell
https://support.microsoft.com/en-us/office/link-a-chart-title-label-or-text-box-to-a-worksheet-cell-efc8173a-2a8a-423b-b4e2-b10c62fca6f5

REFERENCE TO CALC:
1) Chart Wizard - Chart Elements 
https://help.libreoffice.org/7.2/en-US/text/schart/01/wiz_chart_elements.html
"It is not possible to link the title text to a cell. You must enter the text directly."

Steps to Reproduce:
FEATURE REQUEST

Actual Results:
FEATURE REQUEST

Expected Results:
FEATURE REQUEST


Reproducible: Always


User Profile Reset: No



Additional Info:
FEATURE REQUEST