Bug 146858 - FEATURE REQUEST: Link a chart title, label, or text box to a worksheet cell
Summary: FEATURE REQUEST: Link a chart title, label, or text box to a worksheet cell
Status: RESOLVED DUPLICATE of bug 103863
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Calc (show other bugs)
Version:
(earliest affected)
7.3.0.2 rc
Hardware: All All
: medium enhancement
Assignee: Not Assigned
URL:
Whiteboard:
Keywords:
Depends on:
Blocks: Chart-Labels
  Show dependency treegraph
 
Reported: 2022-01-19 14:29 UTC by Piotr Osada
Modified: 2024-03-07 11:56 UTC (History)
1 user (show)

See Also:
Crash report or crash signature:


Attachments
LibreOffice spreadsheet example (23.82 KB, application/vnd.oasis.opendocument.spreadsheet)
2022-01-19 14:31 UTC, Piotr Osada
Details
Working example in Excel (20.10 KB, application/x-zip-compressed)
2022-01-19 14:33 UTC, Piotr Osada
Details

Note You need to log in before you can comment on or make changes to this bug.
Description Piotr Osada 2022-01-19 14:29:05 UTC
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
Comment 1 Piotr Osada 2022-01-19 14:31:30 UTC
Created attachment 177648 [details]
LibreOffice spreadsheet example
Comment 2 Piotr Osada 2022-01-19 14:33:31 UTC
Created attachment 177649 [details]
Working example in Excel
Comment 3 m_a_riosv 2022-01-21 21:41:28 UTC

*** This bug has been marked as a duplicate of bug 103863 ***