Issue 3380 - Enhance "Insert -> Statistics" command for spreadsheet charts so that it can handle error data provided in range of cells
Summary: Enhance "Insert -> Statistics" command for spreadsheet charts so that it can ...
Status: CLOSED DUPLICATE of issue 366
Alias: None
Product: Calc
Classification: Application
Component: editing (show other issues)
Version: 641
Hardware: All All
: P3 Trivial with 8 votes (vote)
Target Milestone: ---
Assignee: requirements
QA Contact: issues@sc
URL:
Keywords: ms_interoperability, rfe_eval_ok, usability
Depends on:
Blocks:
 
Reported: 2002-03-07 04:28 UTC by Unknown
Modified: 2013-08-07 15:12 UTC (History)
4 users (show)

See Also:
Issue Type: ENHANCEMENT
Latest Confirmation in: ---
Developer Difficulty: ---

Attachments
Add an attachment (proposed patch, testcase, etc.)

Note You need to log in before you can comment on or make changes to this issue.
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