Graphing in Excel
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
................
................
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
- using microsoft excel to plot and analyze kinetic data
- how to create graphs with a best fit line in excel
- plotting data with microsoft excel
- graphing in excel
- brief tutorial on using excel to draw an x y plot
- making a graph on excel program
- using excel to graph data instructions
- graphing a binomial probability distribution using
- using microsoft excel for graphing
- introduction to microsoft excel north allegheny
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