error bars in OOcalc

Asked by Arantza

I work with OOcalc very often and I need to plot charts that contain serial data, eg. growth over time. Each value that appears in the graph is a mean of several replicates. When I want to add an error bar to each mean value, I click in the chart, right click-object properties and the program gives me the following option: Statistics-error category. However, the options I am offered don't suit my needs because the error bars I need to plot aren't a constant number or percentage but a standard deviation calculated from the series of values. Microsoft's Excel gives you an extra tool where you can drag the calculated errors from the series of values, which are represented in the chart as error bars.

I'd like to know if the problem has already been reported and if there's someone working on it for possible futures releases of open office

Question information

English Edit question
Ubuntu openoffice.org2 Edit question
No assignee Edit question
Last query:
Last reply:
Revision history for this message
Bajtalan Hunor (cerebellum) said :


I guess you should write a letter to the open office developers or user community because that problem relates to open office not to Linux generally in my point of view.
Write to <email address hidden> ( users)
             <email address hidden>

I hope this will help to you

Revision history for this message
J (wern0122) said :

Yeah, I agree this is HUGE short-coming of OOcalc. Not really Ubuntu's fault, though. Don't know if the OOo people plan on adding such a feature anytime soon, but in the meantime there is a fabulous graphing package in the Ubuntu repositories called "grace." A little more work, since you have to export the data to a text file in the correct format, and then open it in grace, but it really makes terrific, versitile plots, and has a lot of great data-fitting and statistical features too. Or, if you have a lot of time on your hands, there's always gnuplot. :)

Can you help with this problem?

Provide an answer of your own, or ask Arantza for more information if necessary.

To post a message you must log in.