Apache OpenOffice (AOO) Bugzilla – Full Text Issue Listing
|Summary:||Ease editing regression lines (trendlines)|
|Status:||CLOSED FIXED||QA Contact:||issues@graphics <issues>|
|Priority:||P3||CC:||IngridvdM, issues, robert.pollak, tony.galmiche.ooo|
|Version:||3.3.0 or older (OOo)||Keywords:||ms_interoperability, rfe_eval_ok, usability|
|Issue Type:||ENHANCEMENT||Latest Confirmation in:||---|
Description vhockey86 2005-03-11 04:19:32 UTC
1) Created a simple XY-scatter plot chart with the wizard. - Make 2 columns of data, one with some numbers, and a 2nd with their squares - Highlighted this data and hit the chart button - Selected the XY-scatter "symbols only" chart style and finished out the wizard 2) Clicked on the chart (cant remember how many times), but eventually manged to select the series of data points (although it seemed rather glitchy on where you could click to select certain things). 3) Right clicked on the data series and selected "object properties" 4) Clicked the "power regression" item under the statistics tab. and hit "ok" 5) Now if I click on the regression line and goto object properties, all I can edit is the line style, no way to change the regression. I was also unable to either delete or "cut" the regression to remove it from the graph. I assume this is a defect, but possibly just an enhancement request (not overly familiar with the software). http://www.andrewpangborn.com/images/oo3.jpg http://www.andrewpangborn.com/files/squares.ods
Comment 1 kla 2005-03-11 09:26:45 UTC
Hm, i think enhancement matched better. But, if i choose the Object Properties of an Line i only espect this Properties only.
Comment 2 vhockey86 2005-03-11 16:05:29 UTC
I suppose, but this really isn't a line, its a regression, an object by itself. In excel you can easily just select the trendline and reformat it. In the least, there should be a way to remove it from the graph, such that you can apply a new regression from scratch. Trying to delete/cut, as I said previously gives an error "This function cannot be completed with the selected objects". This forces me to make an entirely new graph, just to try out different types of regressions for the supplied data... If I am simply missing how to do this (I searched around in the application for about an hour, and through the supplied help and found nothing), please let me know. firstname.lastname@example.org
Comment 3 trevdiggy 2005-03-31 16:19:04 UTC
The key is to select the data series on the chart and not the regression line. Depending on the the overlap between regression line and data series, this can be nearly impossible. If you can't get at the data series with the mouse, select the regression line and then hit the Tab key once - now the data series should be selected. Right-click and choose "Object properties" and you should get the dialog box with the Statistics tab you're looking for.
Comment 4 vhockey86 2005-03-31 16:36:15 UTC
Thank you trevdiggy. That seems to work alright. On a side note, is there any way to get an equation for the regression of the line?
Comment 5 trevdiggy 2005-04-01 02:59:06 UTC
I don't know of any easy way to display the equation of the regression curve, although I think this same topic was batted about on the email@example.com mailing list (subscribe here: http://www.openoffice.org/mail_list.html) and the answer was that there is no built-in way to do this. Which is a big drawback, IMO. However, a search for 'regression equation' in the firstname.lastname@example.org mailing list archive <http://www.openoffice.org/servlets/SummarizeList?listName=users> revealed a site with all kinds of macros for adding cool functions to OOo. It's a great list to search/subscribe to for getting answers to OOo problems. Here's an URL that will take you directly to the OOo Statistics package: http://ooomacros.org/user.php#106652 It adds a lot of the same functionality as the Analysis Toolpak in MS Office. It won't add the equation to your graph, but you may be able to use it to find the equation and then just insert an equation on top of your graph manually. Good luck.
Comment 6 IngridvdM 2006-01-13 18:06:47 UTC
Hi vhockey86, you pointed to valid useability problems. I will take care of this issue. Thanks. Ingrid
Comment 7 IngridvdM 2006-01-13 18:08:05 UTC
Comment 8 IngridvdM 2007-05-14 14:29:03 UTC
changed prio and target
Comment 9 IngridvdM 2007-05-14 14:31:28 UTC
*** Issue 76160 has been marked as a duplicate of this issue. ***
Comment 10 IngridvdM 2007-09-12 09:59:36 UTC
->bm, please take over as you are near that area in the next time.
Comment 11 bjoern.milcke 2007-09-12 11:26:16 UTC
correcting summary ;-)
Comment 12 bjoern.milcke 2007-10-25 15:20:21 UTC
Changing target to 3.0, as a thorough fix for this takes too much time at the moment. In CWS chart17 there are two improvements: 1. You can add a trendline with a context menu item of the data series, which is a linear regression. Changing its type still works via the object properties of the data series, which is indeed sub-optimal. Problem here is that the current controls contain the different types as well as "none", which would not make much sense for the properties of the curve itself. 2. You can delete a regression curve with the delete key.
Comment 13 IngridvdM 2007-11-30 17:10:33 UTC
Comment 14 bjoern.milcke 2008-01-15 12:16:23 UTC
Please check this new feature against the spec given in "URL".
Comment 15 bjoern.milcke 2008-01-15 12:16:55 UTC
fixed in CWS chart19
Comment 16 kla 2008-02-15 12:42:45 UTC
Created attachment 51528 [details] TCS for Trend-/ and Mean Value Line(s)
Comment 17 kla 2008-02-15 12:43:47 UTC
verified in CWS chart19
Comment 18 kla 2008-04-23 10:12:59 UTC