To comment on the following update, log in, then open the issue:
http://www.openoffice.org/issues/show_bug.cgi?id=64604





------- Additional comments from [email protected] Tue Aug 25 
08:07:33 +0000 2009 -------
"OOo should handle it that way, that the name of the named range is stored with
the chart, so if you alter the addresses which are referenced by the name in
Insert - Names - Define, the chart will use the new data without any change on
the chart settings."

+ 1

With this possibility, I can create dynamic range with OFFSET function.

For example :

Insert > Names > Define 
 - Name : MyRange
 - Assigned to : =OFFSET($A$1;0;0;COUNTA($B$1:$b$10);2)

Insert > Chart > DataRange : MyRange

---------------------------------------------------------------------
Please do not reply to this automatically generated notification from
Issue Tracker. Please log onto the website and enter your comments.
http://qa.openoffice.org/issue_handling/project_issues.html#notification

---------------------------------------------------------------------
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]


---------------------------------------------------------------------
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]

Reply via email to