I have a sheet that contains date cells and would like to use the date contained in that cell as text in the title of a chart. Is there a way to do this? If so what is the procedure/method?
To convert a date in a cell to text, select the cell, choose menu Data - Text to Columns…, select the column heading, and choose Text as Column Type:.
But you couldn’t use this cell content in a formula for the title of the chart. But…
A workaround: If Chart Area is set to none,¹ the background cells could be seen. So, if in a cell behind the chart is a date, it will be seen: format it as a title. Also could set a (white) background color to the cells behind the chart.
See sample file.
To export the chart, select the cells behind the chart, choose menu File - Export… - check Selection, and select Name: and Type:…
¹ Secondary click on the chart, choose Edit, choose menu Format - Chart Area… - Area tab - None button.
Tested with LibreOffice 6.4.7.2 (x86); OS: Windows 6.1.
Add Answer is reserved for solutions.
Press edit below your question if you want to add more information; also can comment an answer.
Check the mark (
) to the left of the answer that solves your question.
Thanks for your solution it’s a bit of work but it worked great.
You’re welcome!