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?
See another answer at Adding a cell reference to a chart text box
To convert a date in a cell to text, select the cell, choose menu
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
Export… - check Selection, and select Name: and Type:…
¹ Secondary click on the chart, choose
Edit, choose menu
Chart Area… -
Area tab -
Tested with LibreOffice 184.108.40.206 (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.