

Study with the several resources on Docsity
Earn points by helping other students or get them with a premium plan
Prepare for your exams
Study with the several resources on Docsity
Earn points to download
Earn points by helping other students or get them with a premium plan
Community
Ask the community for help and clear up your study doubts
Discover the best universities in your country according to Docsity users
Free resources
Download our free guides on studying techniques, anxiety management strategies, and thesis advice from Docsity tutors
Material Type: Notes; Class: General Chemistry I; Subject: Chemistry; University: Colgate University; Term: Fall 2009;
Typology: Study notes
1 / 2
This page cannot be seen from the preview
Don't miss anything!
For our example we wish to graph the absorbance measurements of different acetylsalicylic acid concentrations (remember aspirin determination?). In Figure 1, found on the next page, there is an example of an Excel spreadsheet that was used to generate a standard curve using acetylsalicylic acid concentrations and measured absorbances.
The acetylsalicylic acid (ASA) concentrations (x-values for our graph) were entered in cells A2 through A6. The measured absorbances (at 526 nm) were entered in cells B through B6.
To generate a graph of the data you can either click on the Chart Wizard (see Figure1) or highlight Chart under Insert on the tool bar.
The chart should then appear on your spreadsheet. To insert a trendline and show an equation:
A trendline with an equation should appear on your graph. You can move your chart by clicking on the chart area, holding down the left mouse button and dragging. You can make the chart larger or smaller by clicking on your chart area and dragging the corner of the chart while holding down the left mouse button. You can print the chart by clicking on the chart area and choosing Print under File on the menu bar. This simple example should give all the information you need to produce great graphs in Excel. Good Luck.
Using Excel for Generating Graphs
Figure 1: Example Excel Spreadsheet and Graph