# How in the world do I graph this on Excel?

Asked by ScottyMcGeester (1715) September 28th, 2012

I’m usually good at making graphs, but for some reason the data I have here is making me confused at how to even order it in a graph.

I had a solution set at different dilution factors (1:2, 1:4, and 1:10) For each dilution, I took four trials of data. We were measuring absorbances.

So for example, for solution one, 1:2 had 2.34, etc, etc. Then 1:4 had .59, etc, etc. Get it?

The goal of making this graph is trying to figure out what missing dilution we need to get 1.5.

My boss wants me to make a graph that has all four data points of each dilution and a linear. . .line thing, to figure out the slope of everything.

So x axis is going to be mg/ml and y axis is going to be the absorbance, so the highest is 2.8 and the lowest would be 0.
But then. . the fact that they’re different dilutions. . .how. . I don’t even know how to explain it.

It’s just coming out weird. I just want a linear slope thing with all the data points I have scattered around it. I hope someone can make sense of how to order it.

Observing members: 0 Composing members: 0

Nevermind. . . my boss realized this too is complicated and said screw it – we just drew it by hand. Still, feel free to share a solution.

Never mind, then.

CWOTUS (26067)

@CWOTUS It’s alright. We’re trying to plot mg/ml against absorbance. (x and y respectively)

However, now that we found the dilution factors we need, now I need to figure out what that equals to in microliters. That’s a whole ‘nother problem. Good Lord, at least it’s Friday. _

or