Ask Your Question

How to use cell content as a chart title or subtitle? [closed]

asked 2014-08-06 13:26:28 +0100

Griffin gravatar image

updated 2016-03-01 21:18:12 +0100

Alex Kemp gravatar image

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: Build ID: 420m0(Build:2) on Ubuntu 14.04 64bit (Trusty Tahr)

Any help will be much appreciated.

edit retag flag offensive reopen merge delete

Closed for the following reason the question is answered, right answer was accepted by Alex Kemp
close date 2016-03-01 21:18:24.685868

2 Answers

Sort by » oldest newest most voted

answered 2014-08-06 20:38:21 +0100

m.a.riosv gravatar image

Reading on the help not possible:

Help Chart Titles

But with charts there is a couple of simples solutions, not exactly the same, if you are not to move the chart alone, but moving it with their underlaying cells. It's possible e.g. have several charts to simulate one with different types.

1- Making transparent the Chart area, lets you put what you like in the underlaying cells. Chart elements are over the cells.

Chart Area Transparency

2- Sending the chart to background, with chart not selected right-click on it - Arrange - To background, but in this case is needed to use the navigator [F5] to select the Chart. Cells are over the Chart.

image description

Attached is an example mixing chart and cells: Chart with horizontal stacked bars.

edit flag offensive delete link more

answered 2014-08-06 13:54:28 +0100

ROSt52 gravatar image

I made a test and was not successful as well. As your idea looks to me like an interesting feature, I recommend to file an enhancement request here:

It would be nice if you post the bug number here to enable others to add comments.

edit flag offensive delete link more

Question Tools

1 follower


Asked: 2014-08-06 13:26:28 +0100

Seen: 1,019 times

Last updated: Aug 06 '14