I am trying to set up a standard curve for my lab report which consists of diffe

Question

I am trying to set up a standard curve for my lab report which consists of different concentrations starting from zero and increasing. Zero is needed in the graph, but my graph seems to be ignoring the zeros in the X and Y sets. For my graph, I have the X values set as concentration and the Y values set as absorbance. I just need the graph to have a "0" concentration and "0" absorbance point, but it won't do that; also different points are in the wrong spot. Lastly, when I put a trend line in, negative values come up, I just thought that was odd, I know how to turn off the negative values, but only MS Excel has done this to me before. I have looked into every option possible to try to get the "0" values recognized, and fix the other values to no avail.

I have been using OpenOffice for the past year to do my charts and this has not happened to me before. Attached is a screen shot, if you neeed more, I can uploaad more! But below thatt is an example I did on aanother lab showing what I want it to look like!!!!

Explanation / Answer

Here are the first two things to check:

(1) Be sure to use an XY (Scatter) chart type, not a Line chart type.

(2) Be sure that the X data and Y data in worksheet cellss are both numericcal values and that none are actually text values that appear to be numericaal.

Related Questions

Navigate

• Browse (All)
• Browse I
• Subjects

Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.