I don't know if you can insert a chart with a trend line that is forced
through zero. The dialogue probably needs another tick box "Force
In this case you can add an extra column to calculate the straight line.
You can use the function LINEST to calculate the straight line that fits
data y1 and passes through the origin. You can then insert a chart, xy,
lines and points and have the series y1 and the straight line fitted to
y1 and the series y2.
I can also derive another meaning to your question which may not be as
you intend, but is something we do to show errors. We plot y1 against x
with y1 on the left axis. We calculate the straight line fit for y1. We
then calculate the error that y2 is from the straight line and plot that
error (deviation from the straight line) using an expanded scale on the
right y axis.
On 2013-04-01 15:55, Gulzar Singh wrote:
Yes. Concentration values are same for both.
Standard readings will create a straight line from origin with two or
On that line values of sample are to be plotted. Now that point will
be used to determine concentration of sample.
On Apr 1, 2013 8:19 AM, "Steve Edmonds" <email@example.com
On 2013-04-01 14:13, Gulzar Singh wrote:
I have two group of readings. First called as "Standard".
"Sample". Each group has 6 readings. I need to create a graph.
'concentration'. Y-axis with 'OD'. PROBLEM: Standard readings
plotted first and a straight line from origin with any two or
should be made. Now on that line values of sample are to be
How to do it ? Need it for project .Urgent.
Is the x value for concentration the same for both sets of readings.
x y1 y2
0 0.05 0.06
0.1 3.0 2.9
0.19 5.9 6.1
0.29 9.1 9.2
0.41 12.2 12.3
0.5 15.02 15.4
For unsubscribe instructions e-mail to: firstname.lastname@example.org
Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
List archive: http://listarchives.libreoffice.org/global/users/
All messages sent to this list will be publicly archived and cannot be deleted
Impressum (Legal Info)
: Unless otherwise specified, all text and images
on this website are licensed under the
Creative Commons Attribution-Share Alike 3.0 License
This does not include the source code of LibreOffice, which is
licensed under the Mozilla Public License (MPLv2
"LibreOffice" and "The Document Foundation" are
registered trademarks of their corresponding registered owners or are
in actual use as trademarks in one or more countries. Their respective
logos and icons are also subject to international copyright laws. Use
thereof is explained in our trademark policy