Difference between revisions of "Chart2/TrendLines"
From Apache OpenOffice Wiki
< Chart2
Tonygalmiche (Talk | contribs) |
Tonygalmiche (Talk | contribs) |
||
Line 1: | Line 1: | ||
== Allow regression lines also for bar charts == | == Allow regression lines also for bar charts == | ||
[[Image:Chart2_TrendLines99.png]] | [[Image:Chart2_TrendLines99.png]] | ||
− | |||
− | |||
Line 10: | Line 8: | ||
* Different types of regression lines are already offered: linear regression, exponential regression. But a polynomial regression curve is still missing. A macro on this site offers a workaround (french only): | * Different types of regression lines are already offered: linear regression, exponential regression. But a polynomial regression curve is still missing. A macro on this site offers a workaround (french only): | ||
* http://oooconv.free.fr/fitoo/fitoo_fr.html | * http://oooconv.free.fr/fitoo/fitoo_fr.html | ||
− | * covered in http://www.openoffice.org/issues/show_bug.cgi?id= | + | * covered in http://www.openoffice.org/issues/show_bug.cgi?id=20819 |
== Allow more than one regression line for one series == | == Allow more than one regression line for one series == | ||
[[Image:Chart2_TrendLines99.png]] | [[Image:Chart2_TrendLines99.png]] | ||
− | * covered in http://www.openoffice.org/issues/show_bug.cgi?id= | + | * covered in http://www.openoffice.org/issues/show_bug.cgi?id=64813 |
Line 22: | Line 20: | ||
* Trend lines should also allow extrapolating. If data ranges from 1 to 5 but that x axes range from -2 to 10, then the trend line should display from -2 to +10. | * Trend lines should also allow extrapolating. If data ranges from 1 to 5 but that x axes range from -2 to 10, then the trend line should display from -2 to +10. | ||
* In Excel, the setting is called forward forecast and backward forecast. | * In Excel, the setting is called forward forecast and backward forecast. | ||
− | * covered in http://www.openoffice.org/issues/show_bug.cgi?id= | + | * covered in http://www.openoffice.org/issues/show_bug.cgi?id=5085 |
Line 28: | Line 26: | ||
[[Image:Chart2_TrendLines99.png]] | [[Image:Chart2_TrendLines99.png]] | ||
* Get the mean value not only for Y but also for X. A special symbol could mark the intersection point (the center of gravity). | * Get the mean value not only for Y but also for X. A special symbol could mark the intersection point (the center of gravity). | ||
− | * covered in http://www.openoffice.org/issues/show_bug.cgi?id= | + | * covered in http://www.openoffice.org/issues/show_bug.cgi?id=64816 |
Line 34: | Line 32: | ||
[[Image:Chart2_TrendLines99.png]] | [[Image:Chart2_TrendLines99.png]] | ||
* Trend for X added to the existent Y trend line | * Trend for X added to the existent Y trend line | ||
− | * covered in http://www.openoffice.org/issues/show_bug.cgi?id= | + | * covered in http://www.openoffice.org/issues/show_bug.cgi?id=64817 |
Line 42: | Line 40: | ||
* It's not possible to automatically add the equation of the trend line and the coefficients. | * It's not possible to automatically add the equation of the trend line and the coefficients. | ||
* This point is one of the last that block several schools migrations. | * This point is one of the last that block several schools migrations. | ||
− | * covered in http://www.openoffice.org/issues/show_bug.cgi?id= | + | * covered in http://www.openoffice.org/issues/show_bug.cgi?id=7998 |
Line 49: | Line 47: | ||
[[Image:Chart2_TrendLines99.png]] | [[Image:Chart2_TrendLines99.png]] | ||
* Error bar for X added to the existent Y one | * Error bar for X added to the existent Y one | ||
− | * covered in http://www.openoffice.org/issues/show_bug.cgi?id= | + | * covered in http://www.openoffice.org/issues/show_bug.cgi?id=64818 |
Line 55: | Line 53: | ||
[[Image:Chart2_TrendLines99.png]] | [[Image:Chart2_TrendLines99.png]] | ||
* Obtain the value of the error bar from row or column in Calc | * Obtain the value of the error bar from row or column in Calc | ||
− | * covered in http://www.openoffice.org/issues/show_bug.cgi?id= | + | * covered in http://www.openoffice.org/issues/show_bug.cgi?id=366 |
Revision as of 14:39, 15 July 2007
Contents
- 1 Allow regression lines also for bar charts
- 2 Add polynomial regression type
- 3 Allow more than one regression line for one series
- 4 Extrapolating of trend lines
- 5 Mean value for X and center of gravity
- 6 Trend line for X
- 7 Trend line equation and coefficients
- 8 Error bar for X
- 9 Data source for values or the error bar
Allow regression lines also for bar charts
Add polynomial regression type
- Different types of regression lines are already offered: linear regression, exponential regression. But a polynomial regression curve is still missing. A macro on this site offers a workaround (french only):
- http://oooconv.free.fr/fitoo/fitoo_fr.html
- covered in http://www.openoffice.org/issues/show_bug.cgi?id=20819
Allow more than one regression line for one series
Extrapolating of trend lines
- Trend lines should also allow extrapolating. If data ranges from 1 to 5 but that x axes range from -2 to 10, then the trend line should display from -2 to +10.
- In Excel, the setting is called forward forecast and backward forecast.
- covered in http://www.openoffice.org/issues/show_bug.cgi?id=5085
Mean value for X and center of gravity
- Get the mean value not only for Y but also for X. A special symbol could mark the intersection point (the center of gravity).
- covered in http://www.openoffice.org/issues/show_bug.cgi?id=64816
Trend line for X
- Trend for X added to the existent Y trend line
- covered in http://www.openoffice.org/issues/show_bug.cgi?id=64817
Trend line equation and coefficients
- It's not possible to automatically add the equation of the trend line and the coefficients.
- This point is one of the last that block several schools migrations.
- covered in http://www.openoffice.org/issues/show_bug.cgi?id=7998
Error bar for X
- Error bar for X added to the existent Y one
- covered in http://www.openoffice.org/issues/show_bug.cgi?id=64818
Data source for values or the error bar
- Obtain the value of the error bar from row or column in Calc
- covered in http://www.openoffice.org/issues/show_bug.cgi?id=366