Adding a cell reference to a chart text box
I know it is possible to add plain text to a chart in Calc (by inserting a text box or a rectangle containing text), but is it possible to add a rectangle containing a reference to a spreadsheet cell? For example, instead of drawing a rectangle in a chart area and then adding plain text to that rectangle, what I would like to do is draw a rectangle in the chart area and then add a reference to a spreadsheet cell in that rectangle (e.g. =$Sheet1.A6). Then, every time that referenced cell changes its value, the chart will show that new value. I have a number of spreadsheet files that use the same chart layout but with different data, so this feature would save me having to type in a different absolute value into every separate spreadsheet chart. I can do this quite easily in Excel charts, but can't find a way to do it in Calc. (Maybe LibreOffice doesn't support that feature?). Many thanks for any advice on this one. Geoff_B