I have a Calc spreadsheet of data with domestic energy meter readings (gas and electricity) and bills received against the date of the reading or bill. I have charted the data but would like the title of the chart to reflect the date range of the charted data. It’s easy to generate a cell with the necessary start and end dates formatted as desired (eg 'Energy usage from to '), but how to select this as the title of the chart? Is this possible - or even the right approach?
LibreOffice Calc Version: 18.104.22.168 Build ID: 420m0(Build:2) on Ubuntu 14.04 64bit (Trusty Tahr)
Any help will be much appreciated.