Graphing in Excel
[Pages:10]Graphing Using Excel This exercise shows you how to handle Beer's Law and kinetics data using Excel.
Beer's Law Type in [K2CrO4] in the A1 cell (x-axis) and Absorbance in the B1 cell (y-axis). Enter the data for concentration and absorbance.
Highlight the concentration and absorbance columns and click on Insert on the top menu and click on Chart on the drop down menu.
1
Click on the xy scatter option and click Finish. 2
Right click in the graph area and click on Chart Options. You can remove the Legend, add gridlines, Graph Title, and labels for the x and y axes. Then click OK.
3
By clicking in the graph area and using the cursor you can enlarge the graph. 4
Click on Chart in the top menu and click on the Add Trendline option. This will put in the linear regression line or best fit straight line through the data points.
5
6
Click on Automatic, Display equation on chart, and Display R=squared value on chart (how well the values correlate to a straight line) then click OK.
7
8
................
................
In order to avoid copyright disputes, this page is only a partial summary.
To fulfill the demand for quickly locating and searching documents.
It is intelligent file search solution for home and business.
Related download
- lesson graphing the standard curve
- creating a lorenz curve from excel
- the basics of creating graphs with sas graph
- how to make an apa style graph
- creating graphs in spss open university
- 1 creating multiple baseline mb single subject
- graphing in excel
- how to create graphs with a best fit line in excel
- creating charts and graphs libreoffice
- creating charts and graphs
Related searches
- loan calculator in excel format
- alt enter in excel formula
- amortization calculator in excel formula
- how to calculate percentage in excel formula
- formula in excel for compounding interest
- formula in excel to calculate 10 discount
- how to calculate hours in excel timesheet
- percent discount in excel formula
- change formula in excel sheet
- how to calculate dates in excel spreadsheet
- age in excel between two dates
- sum by color in excel 2010