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

Regression curves

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


Joined: 18 Jan 2007
Posts: 189

PostPosted: Tue Nov 27, 2007 9:26 am    Post subject: Regression curves Reply with quote

How do I add a trend line/regression curve to an existing chart? I've searched for it and cannot find an answer that actually works.

Keith
Back to top
View user's profile Send private message
jrkrideau
Super User
Super User


Joined: 08 Aug 2005
Posts: 6732
Location: Kingston ON Canada

PostPosted: Tue Nov 27, 2007 9:31 am    Post subject: Re: Regression curves Reply with quote

keithclark1966 wrote:
How do I add a trend line/regression curve to an existing chart? I've searched for it and cannot find an answer that actually works.

Keith


Select graph and right click on it. Select Edit and then go to the main icon bar and select Insert > Statistics > select desired curve.
_________________
jrkrideau
Kingston ON Canada
Currently using Windows 7 & OOo 3.4.0 and Ubuntu 12.04 & LibreOffice 3.5.2.2
Back to top
View user's profile Send private message
keithclark1966
OOo Enthusiast
OOo Enthusiast


Joined: 18 Jan 2007
Posts: 189

PostPosted: Tue Nov 27, 2007 9:36 am    Post subject: Re: Regression curves Reply with quote

jrkrideau wrote:
keithclark1966 wrote:
How do I add a trend line/regression curve to an existing chart? I've searched for it and cannot find an answer that actually works.

Keith


Select graph and right click on it. Select Edit and then go to the main icon bar and select Insert > Statistics > select desired curve.


Nope, regression curves is grayed out.

Keith
Back to top
View user's profile Send private message
jrkrideau
Super User
Super User


Joined: 08 Aug 2005
Posts: 6732
Location: Kingston ON Canada

PostPosted: Wed Nov 28, 2007 7:52 am    Post subject: Re: Regression curves Reply with quote

keithclark1966 wrote:
jrkrideau wrote:
keithclark1966 wrote:
How do I add a trend line/regression curve to an existing chart? I've searched for it and cannot find an answer that actually works.

Keith


Select graph and right click on it. Select Edit and then go to the main icon bar and select Insert > Statistics > select desired curve.


Nope, regression curves is grayed out.

Keith


Beats me then. It works fine for me.

What OS and version of OOo are you using?
_________________
jrkrideau
Kingston ON Canada
Currently using Windows 7 & OOo 3.4.0 and Ubuntu 12.04 & LibreOffice 3.5.2.2
Back to top
View user's profile Send private message
keithclark1966
OOo Enthusiast
OOo Enthusiast


Joined: 18 Jan 2007
Posts: 189

PostPosted: Wed Nov 28, 2007 8:27 am    Post subject: Re: Regression curves Reply with quote

Nope, regression curves is grayed out.

Keith[/quote]

Beats me then. It works fine for me.

What OS and version of OOo are you using?[/quote]

PCLinuxOS 2007, Open Office 2.2.3
_________________
Open Office 3.0 under Ubuntu 9.04, XP and Vista
Back to top
View user's profile Send private message
acknak
Moderator
Moderator


Joined: 13 Aug 2004
Posts: 4295
Location: ~ 40°N,75°W

PostPosted: Wed Nov 28, 2007 9:11 am    Post subject: Reply with quote

Quote:
Open Office 2.2.3

Wasn't that prior to integration of the new Chart module?

I think you'll need to upgrade to get full Chart features.
Back to top
View user's profile Send private message
jrkrideau
Super User
Super User


Joined: 08 Aug 2005
Posts: 6732
Location: Kingston ON Canada

PostPosted: Thu Nov 29, 2007 6:50 am    Post subject: Reply with quote

acknak wrote:
Quote:
Open Office 2.2.3

Wasn't that prior to integration of the new Chart module?

I think you'll need to upgrade to get full Chart features.


Yes, it was but if I recall correctly that version would produce a linear regression line. Still an update might cure the problem.
_________________
jrkrideau
Kingston ON Canada
Currently using Windows 7 & OOo 3.4.0 and Ubuntu 12.04 & LibreOffice 3.5.2.2
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