Issue 4826 - Feature Request - Allow error bars in charts to be + or - a cell value (as in excel) rather than just a constant value or standard deviation
Summary: Feature Request - Allow error bars in charts to be + or - a cell value (as in...
Status: CLOSED DUPLICATE of issue 366
Alias: None
Product: General
Classification: Code
Component: chart (show other issues)
Version: 3.3.0 or older (OOo)
Hardware: All All
: P4 Trivial with 5 votes (vote)
Target Milestone: ---
Assignee: bjoern.milcke
QA Contact: issues@graphics
: 3179 (view as issue list)
Depends on:
Reported: 2002-05-14 05:29 UTC by Unknown
Modified: 2013-02-24 21:18 UTC (History)
3 users (show)

See Also:
Latest Confirmation in: ---
Developer Difficulty: ---


Note You need to log in before you can comment on or make changes to this issue.
Description Unknown 2002-05-14 05:29:27 UTC
Excel allows error bars for chart datapoints to be + or - a fixed value, a fixed
percentage or to take their values from cells. The lack of this last feature in
calc is the only area i've found were excel stil has an edge over openoffice.
Unfortunately i really need this feature for the work i do where error bar
values are derived from fairly complex calculations rather than just being
simple percentages.
Comment 1 frank 2002-05-14 07:07:11 UTC
Hi Falko,

1 4 u

Comment 2 harlan879 2002-12-16 00:10:51 UTC
Another note on this is that in Impress, where the data comes from the
very simple data editor, error bars need to be functional too, so the
solution to this problem should not be a reference to cells in a
spreadsheet. Instead, similar to the Stock Charts, you should be able
to put the error value as a third column in an XY chart.

Incidentally, you can fake error bars by use of the Stock Chart
option, adding and subtracting the error bars from the mean, then
making the lines that connect them invisible. It's still not perfect
-- the bars don't have horizontal lines at the top and bottom, and the
stock chart annoyingly has Y-axis labels on both the right and the
left, but it leads me to think that a solution to this problem (which
seems to be a longstanding deficiency) would not be seriously
difficult to implement. 

Comment 3 Unknown 2003-01-21 11:09:06 UTC
Isn't this issue somewhat related to 366 ?
I guess they could be merged together...
Comment 4 harlan879 2003-01-21 16:44:03 UTC
Yes, I think this is essentially the same issue as bug 366. I would
want to reiterate the comment from 366 that this is a serious
limitation on OO Impress' usability for scientific audiences. Wish I
had time to contribute code!

Comment 5 falko.tesch 2003-09-11 14:28:48 UTC
I find this issue reasonable to have but AFAIK it is not on our
roadmap to 2.0.
Nevertheless I think Bettina should raise this issue with the Chart Team.
Comment 6 bettina.haberer 2003-10-16 14:48:26 UTC
Hello Björn, I set it to OO.o Later. 
Comment 7 bjoern.milcke 2003-10-31 09:37:07 UTC
*** Issue 3179 has been marked as a duplicate of this issue. ***
Comment 8 bjoern.milcke 2003-10-31 14:23:33 UTC
We will bear this feature in mind.
Comment 9 ndeschildre 2004-12-05 12:28:48 UTC
Is this feature planned for OO.o 2.0 ? 
It is definitely _the_ missing feature for scientists. If it is implemented, i 
will finally be able to fully switch to OO.o. 
Thanks guys for your great work! 
Comment 10 IngridvdM 2005-04-08 13:15:08 UTC
Sorry, this is duplicate to issue 366.

*** This issue has been marked as a duplicate of 366 ***
Comment 11 IngridvdM 2005-04-08 13:25:02 UTC
closed as duplicate