Issue 44768 - Ease editing regression lines (trendlines)
Summary: Ease editing regression lines (trendlines)
Alias: None
Product: General
Classification: Code
Component: chart (show other issues)
Version: 3.3.0 or older (OOo)
Hardware: PC All
: P3 Trivial (vote)
Target Milestone: ---
Assignee: kla
QA Contact: issues@graphics
Keywords: ms_interoperability, rfe_eval_ok, usability
: 76160 (view as issue list)
Depends on:
Reported: 2005-03-11 04:19 UTC by vhockey86
Modified: 2013-02-24 21:22 UTC (History)
4 users (show)

See Also:
Latest Confirmation in: ---
Developer Difficulty: ---

TCS for Trend-/ and Mean Value Line(s) (13.38 KB, text/html)
2008-02-15 12:42 UTC, kla
no flags Details

Note You need to log in before you can comment on or make changes to this issue.
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).
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
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
mailing list (subscribe here: 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 mailing
list archive <>
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:

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.
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

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
changed summary
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