Issue 3380

Summary:	Enhance "Insert -> Statistics" command for spreadsheet charts so that it can handle error data provided in range of cells
Product:	Calc	Reporter:	Unknown <non-migrated>
Component:	editing	Assignee:	requirements <requirements>
Status:	CLOSED DUPLICATE	QA Contact:	issues@sc <issues>
Severity:	Trivial
Priority:	P3	CC:	issues, matthias.mueller-prove, oo, piotr
Version:	641	Keywords:	ms_interoperability, rfe_eval_ok, usability
Target Milestone:	---
Hardware:	All
OS:	All
Issue Type:	ENHANCEMENT	Latest Confirmation in:	---
Developer Difficulty:	---

Description Unknown 2002-03-07 04:28:35 UTC

Consider a simple dataset with asymmetric confidence intervals:
Percent	Lower CI	Upper 
CI
12	11.5	13
15	10.6	18.3
10	8.6	11.2
20	18.5	22.3
After creating a bar chart of 
Percent, one can select the chart and click Insert > Statistics. The resulting dialog offers 
many options for creating error bars. Unfortunately, a very useful and critical option has been 
so-far overlooked. Excel allows for the error term to be specified as a cell range. This is 
extremely useful for those of us who have multi-sheet documents and many graphs linked to data 
that gets changed on a fairly regular basis. I am currently running Build641 on Windows98 but I 
assume that this implementation is common across OS/platforms. Thanks for this. I am very keen 
to migrate fully over to OpenOffice.

Comment 1 frank 2002-03-07 08:29:24 UTC

Hi Falko,

sounds good to me. As this is an feature request it's up to you.

Frank

Comment 2 falko.tesch 2003-09-30 14:36:14 UTC

Consider a simple dataset with asymmetric confidence intervals:
Percent	Lower CI	Upper 
CI
12	11.5	13
15	10.6	18.3
10	8.6	11.2
20	18.5	22.3
After creating a bar chart of Percent, one can select the chart and
click Insert > Statistics. The resulting dialog offers many options
for creating error bars. Unfortunately, a very useful and critical
option has been so-far overlooked. Other applications allow for the
error term to be specified as a cell range. This is extremely useful
for those of us who have multi-sheet documents and many graphs linked
to data that gets changed on a fairly regular basis. I am currently
running Build641 on Windows98 but I assume that this implementation is
common across OS/platforms.

Comment 3 falko.tesch 2003-09-30 14:36:40 UTC

started

Comment 4 erwin.tenhumberg 2004-09-30 14:46:50 UTC

enhanced summary, set keywords and reassigned issue according to RFE process

Comment 5 dridgway 2005-10-24 18:24:53 UTC

Note that this seems to be a duplicate of or depending on issue 366.

Comment 6 IngridvdM 2006-05-16 18:19:55 UTC

Yes this is in fact a duplicate to issue 366

*** This issue has been marked as a duplicate of 366 ***

Comment 7 IngridvdM 2006-05-16 18:20:41 UTC

closed as duplicate