[CHM 112] Excel Questions

[Andrew J. Pounds]

I have had a couple of questions on how to use Excel to make the graphs 
for the freezing point depression plots. It's actually gotten easier to 
do this -- but it still will take a little work.

 1. For one of your cooling curves enter the X (time) and Y (temp) data
    in two columns.
 2. Highlight the cells that represent the "approach to freezing" where
    the slope is greatest.  These data will be used to draw the first line.
 3. Once you have hightlighted them, click the insert button at the top
    of the Excel window and look for the scatter plot (the one with just
    data points and no lines). Click this and you should see the first
    part of your plot.
 4. In the plot itself click the right mouse button.  You should see an
    option to select data.  Click on this and then click "Add".   This
    is going to allow you to add another data series.  You may have to
    mess with this some to get it to work, but I was able to highlight
    the remaining X data and then the Y data and add the new series to
    my plot.
 5. Once you have both data series on the plot you  should be able to
    click on the individual data series on the plot and add a trend line
    for each of them.  Like I mentioned in a prior e-mail, adjust the
    "forward" and "reverse" forecast period so the two lines intersect.
 6. Don'f forget to adjust your axes so your plot fills the plot
    region.  Also, I prefer full page graphs to be turned in with the
    lab report -- not tiny graphs that are the result of a "screen print".

Hope that helps.

-- 
Andrew J. Pounds, Ph.D.  (pounds_aj at mercer.edu)
Professor of Chemistry and Computer Science
Mercer University,  Macon, GA 31207   (478) 301-5627
http://faculty.mercer.edu/pounds_aj

-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://theochem.mercer.edu/pipermail/chm112/attachments/20130628/c55305d1/attachment.html>