Ask Your Question

Revision history [back]

click to hide/show revision 1
initial version

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.

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.