OpenOffice.org Forum at OOoForum.orgThe OpenOffice.org Forum
 
 [Home]   [FAQ]   [Search]   [Memberlist]   [Usergroups]   [Register
 [Profile]   [Log in to check your private messages]   [Log in

Error indicator for x axis in a chart.

 
Post new topic   Reply to topic    OOoForum.org Forum Index -> OpenOffice.org Calc
View previous topic :: View next topic  
Author Message
ndriutti
Newbie
Newbie


Joined: 24 May 2005
Posts: 1

PostPosted: Tue May 24, 2005 5:08 am    Post subject: Error indicator for x axis in a chart. Reply with quote

Hi,

in my humble opinion OO calc us a very good spreadsheet and his most advantage that's freeware but it has some limitations compared to the others.
Sometimes i need to insert in a xy char the values with related error magnitude but i found out to do this only for y axis (data series -> statistics -> error indicator).
Is there any way to have this feature (ms excel can do that)?
In regression line menu can I obtain the slope and intercept value or polynomial regression coefficients and formula printed in the graph?

Thank you very much and good work!
Back to top
View user's profile Send private message
ftack
Moderator
Moderator


Joined: 27 Jan 2003
Posts: 3102
Location: Belgium

PostPosted: Tue May 24, 2005 11:59 pm    Post subject: Reply with quote

The charting feature of OOo Calc is currently not up to standards. Developpers are well aware of that. The situation seems to be such that the charting functionality is being redesigned and reprogrammed from scratch. It was originally planned to implement the new charting implementation in version 2, but the developpers could not make that happen. Thus, iunfortunately, we will have to continue a while with the current charting options, which are indeed too limited for many scientific needs. There are some great open source alternatives for creating high publication quality scientific graphs, but they require mastering a command language and thus have a steep earning curve. I am thinking of GNUPlot and R (search for R Cran).
Back to top
View user's profile Send private message
joerg04
OOo Advocate
OOo Advocate


Joined: 14 May 2004
Posts: 326
Location: Germany

PostPosted: Wed May 25, 2005 12:44 am    Post subject: Reply with quote

Try the options mentioned by ftack and gnumeric
Links can be found here.
http://www.oooforum.org/forum/viewtopic.phtml?t=16798&start=0&postdays=0&postorder=asc&highlight=
http://www.oooforum.org/forum/viewtopic.phtml?t=10915&start=0&postdays=0&postorder=asc&highlight=
_________________
joerg04

RKWard: http://rkward.sourceforge.net/
sidux: http://sidux.com/index.html
Musix: http://musix.org.ar/en/index.html
Back to top
View user's profile Send private message Visit poster's website
David
Super User
Super User


Joined: 24 Oct 2003
Posts: 5668
Location: Canada

PostPosted: Wed May 25, 2005 7:06 am    Post subject: Re: Error indicator for x axis in a chart. Reply with quote

ndriutti wrote:
Hi,

in my humble opinion OO calc us a very good spreadsheet and his most advantage that's freeware but it has some limitations compared to the others.


Respectfully, no spreadsheet is all things to all people, no matter how useful or advanced it is in functionality. You might also find that others also have their limitations. If doing mathematics, why not use some dedicated mathematics software? More specific to the task at hand, they are often to your advantage, and there are some powerful programs out there. Some have been already mentioned in past similar discussions. They vary between freeware and highly professional and so fairly expensive. That depends upon individual needs, but definitely worth a good look around.

Sorry, but I'm thinking in terms of available Windows programs, and am not aware of the available possibilities for Linux. There is also excellent math software available for the Mac.

David.
Back to top
View user's profile Send private message
Display posts from previous:   
Post new topic   Reply to topic    OOoForum.org Forum Index -> OpenOffice.org Calc All times are GMT - 8 Hours
Page 1 of 1

 
Jump to:  
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum


Powered by phpBB © 2001, 2005 phpBB Group