Hi, Am 30.01.2014 22:12, schrieb Laurent BP:
> https://bugs.freedesktop.org/show_bug.cgi?id=74163 > Lets take an example which corresponds to a common error of beginner: > 1. Enter Data such as X=1, 10, 100 and Y=11, 12, 13 > 2. Create a *XY* (scatter) chart > 3. Insert trendline and show equation > => f(x) = 0.0165165165x + 11.3888888889 > With same data: > 4. Create a *Line* chart with "First column as label" selected on 2nd step > 5. Insert linear trendline and show equation > => f(x) = 1x + 10 > Do you know some case, where the user would require the equation of the > trendline for other type of diagram different from XY scatter chart? Yes, I do. Example: 1. Enter Data A1=11, A2=13, A3=12, A4=14, A5=16, A6=15 2. Select A1:A6 3. 4. Create a Line chart 4. Insert linear trendline and show equation --> Equation does make sense. ;-) As long as you do *not* specify X-values or categories, the equation is usefull even for "Column", "Bar", "Area", "Line" and "Column and Line" charts. Cheers, Stefan -- LibreOffice - Die Freiheit nehm' ich mir! _______________________________________________ List Name: Libreoffice-qa mailing list Mail address: [email protected] Change settings: http://lists.freedesktop.org/mailman/listinfo/libreoffice-qa Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://lists.freedesktop.org/archives/libreoffice-qa/
