Apache OpenOffice (AOO) Bugzilla – Issue 20551
Adding custom error bars to a plot
Last modified: 2013-02-24 21:21:57 UTC
Could you please add in the following feature in Calc as it is sorely needed to make it a more functional spreadsheet program. When plotting a graph from cell data in Calc there is no option to add custom values for error bars. Only constant "blanket" values for the whole data series. The standard deviation option is not much help either as it calculates the values based on the whole data series, which isn't useful when trying to plot certain types of data. Please add in an option were custom values, either for the data series or each datum, can be added in by refering to a range of cells containg the custom values. Could you also allow the positive & negative values to be set individually? I have set this as P1 because it is a vital feature for anyone who regularly has to compile data sets graphical which involves any kind of statisitics, which alot of people do. It's one of those features that stops me from using OpenOffice.org more than occasionally and has been available in many other office suites for years.
*** Issue 20552 has been marked as a duplicate of this issue. ***
duplicate *** This issue has been marked as a duplicate of 366 ***
closed