Issue 8099

Summary: Chart title from a cell
Product: General Reporter: ooo
Component: chartAssignee: AOO issues mailing list <issues>
Status: CONFIRMED --- QA Contact:
Severity: Trivial    
Priority: P4 CC: issues, matthias.mueller-prove, tony.galmiche.ooo
Version: 3.3.0 or older (OOo)   
Target Milestone: ---   
Hardware: PC   
OS: Windows 98   
Issue Type: FEATURE Latest Confirmation in: ---
Developer Difficulty: ---

Description ooo 2002-10-06 22:57:38 UTC
It would be great if you could have the chart title as a 
reference to a cell so you should only change the cell to 
change the title of a chart. 
 
The reference could automatic be the cell between the x axis 
titles and the y axis title: 
 
       A1: Chart title 
       B1: X axis title 1 
       C1: X axis title 2 
       A2: Y axis tilte 1 
       B2: Value 
       C2: Value 
       A3: Y axis title 2 
       B3: Value 
       C3: Value
Comment 1 frank 2002-10-07 07:14:30 UTC
Hi Falko,

1 4 u

Frank
Comment 2 daniel.rentz 2002-10-10 12:40:30 UTC
FYI: It's already on the chart wish list, see
http://graphics.openoffice.org/chart/featurewishes.html
Comment 3 eric.savary 2003-04-16 15:39:15 UTC
Set to "NEW"
Comment 4 falko.tesch 2003-10-15 09:44:48 UTC
It would be great if you could have the chart title as a reference to
a cell so you should only change the cell to change the title of a chart. 
Comment 5 matthias.mueller-prove 2003-10-15 16:50:47 UTC
to Bettina, our central dispatcher for RFEs
Comment 6 bettina.haberer 2003-10-15 17:25:40 UTC
Very good idea referring cell content (text) to the title as a part of
 the chart. 
Hello Björn, please give approval for this evaluated OO.o 2.0 flagged
issue. 
If you confirm with the target OO.o 2.0, then please keep it on your
owner (or the owner of the concerning developer) for implementation.
In case you want this issue for 'OOo Later', then please reset the
target milestone. If you decline the issue finally, please set the
resolution to 'Wontfix' (but do not close). In case of 'OOo Later' or
'Wontfix' please reset it on Bettina's owner. Thank you.
Comment 7 bjoern.milcke 2003-11-03 08:50:40 UTC
The automatic detection of a cell that contains titles is a bit
difficult. The only intuitive thing would be to use the "upper left
empty cell" for the main title.

Title Cat1 Cat2 ...
Ser1    1    3  ...
Ser2    3    2  ...
...

However, it would be useful to offer a tab-page in the title dialog
(for any of the titles), where you can choose the cell from where the
content of the title comes from.

->Bettina: I suggest to postpone this feature to "OOo Later"
Comment 8 dfrench 2003-12-09 23:04:59 UTC
I would be happy just to be able to set the title, subtitle to the value of a 
cell. Figure out the smart selection of that cell at a later date. To me, the 
shortcoming is that these features of the chart are strings and not fully 
functional  text objects. I suggest that the charts team aim to make all the 
chart  annotations (including data labels, axis descriptions) text objects. We 
could then include data from the spreadsheet cells, or anywhere else,  using 
textfields (com.sun.star.text.TextField...).
At the user interface level, I suggest that actually having to specify the cell 
by name is a particular difficulty. I have been doing that for years in MSExcel.
If issue 22788 was resolved we could simply replace the title with a textbox 
containing data linked to the cell or whatever.
Comment 9 dfrench 2003-12-09 23:08:02 UTC
my comment should read ....NOT a particular difficulty ....
Comment 10 bettina.haberer 2004-11-29 18:01:45 UTC
Reassigned to Björn.
Comment 11 shanx 2005-12-29 19:37:10 UTC
I would like to add to this discussion the following: include the axis (x or y)
Maximum, Minimum, Major Interval, Minor Interval and "Axis at" to be referenced
to cells as well.  I have wished that Excel has had this option for a long time
now.  It seems that if other numerical values can be referenced, why can't the
axis max/min/scale.

Shanx
Comment 12 IngridvdM 2006-03-17 15:35:17 UTC
*** Issue 12460 has been marked as a duplicate of this issue. ***
Comment 13 kpelckmans 2006-03-27 08:43:22 UTC
Any idea which version will implement this feature ?
Comment 14 IngridvdM 2006-05-18 16:58:35 UTC
This issue is realted to Issue 64825.
Comment 15 IngridvdM 2007-10-19 17:57:36 UTC
*** Issue 82730 has been marked as a duplicate of this issue. ***
Comment 16 dudson 2007-10-20 17:20:45 UTC
Still not in OOo 2.3
Comment 17 IngridvdM 2008-07-03 11:39:08 UTC
change owner
Comment 18 IngridvdM 2008-09-26 15:56:06 UTC
*** Issue 93705 has been marked as a duplicate of this issue. ***