Ask Your Question

Griffin's profile - activity

2016-03-01 21:17:40 +0100 received badge  Notable Question (source)
2016-03-01 21:17:40 +0100 received badge  Famous Question (source)
2014-08-07 00:26:34 +0100 received badge  Popular Question (source)
2014-08-06 13:26:28 +0100 asked a question How to use cell content as a chart title or subtitle?

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 <date1> to <date2>'), but how to select this as the title of the chart? Is this possible - or even the right approach?

LibreOffice Calc Version: 4.2.4.2 Build ID: 420m0(Build:2) on Ubuntu 14.04 64bit (Trusty Tahr)

Any help will be much appreciated.