At the URL http://documentation.openoffice.org/manuals/oooauthors2/index.html is a file called 0304CG-CreatingChartsAndGraphs.pdf which is downloadable. On page 25 of this document are instructions for creating an X-Y graph with error bars. I am not sure how much help this will be to you however, as there is a comment at the bottom that states: "Note that these error bars are calculated on the entire data series; that is, the error bars are equal at each point of the chart."

There is no explanation as to how the error bars are calculated. It would be helpful if the error bars represented one standard deviation (better yet, have the standard deviation variable by choice, maybe that you would want to see a S.D of 5, or 2.5, or some other value).

Sorry that I can not be of more help.


Stephen Webb wrote:

To whom it may concern,

I have been happily using OpenOffice for several years now, but recently I have advised the students I teach (a physics lab class) to use your software
if they do not have access to Microsoft Office or whatever else they may
have. Of course, part of this lab is error analysis, but unfortunately I
cannot figure out how to add error bars to data, nor do I know how the
Spreadsheet software tabulates the error bars.

Could you perhaps enlighten me on this subject? The Help Menu entry for
"error bars in spreadsheet" does not say anything about error bars, only how
to add a graph.

Regards,

Attachment: smime.p7s
Description: S/MIME Cryptographic Signature

Reply via email to