Graphing On Excel

1. Graphing On Excel Rasienna Willars http://www.qweas.com/reviews/xlsx_viewer_xlsx_reader.htm

2. Why? • A large part of math, science and STEM carrers includes the use of graphs. http://www.lavc.edu/stem/

3. Why? • In order for students to write research papers they will need data and organization of the data. • Excel will get students to use technology to understand the concepts of graphing and prepare them for the future. http://thenextweb.com/apps/2010/04/13/internet-predictions-morgan-stanley-forget-desktop-mobile-japan-showing/

4. Add Content First Type in your titles and data into the table. Make sure that your X-values are in the right hand column and the Y-values are in the left-hand column.

5. Select Data Points You want to highlight the data points only not the titles. In order to highlight the data points, click and hold in the A1 box and “drag” the mouse over to the B7 box. After this clisk on the “Insert” tab at the top of the screen

6. Select The Right Graph Style Under the “Insert” tab go to Scatter and select the “Scatter With Only Markers” graph and click on it.

7. This Is What You Should See

8. Add a Title to the Graph Click on the “Layout” tab. Click on “Chart Title”. You will notice a few options. I will click on “Above Chart”.

9. This is What You Will See After You Name It

10. Add Axis Labels To add labels to the axis stay in the “Layout” tab. Go to “Axis Title” then either horizontal or verticle depending on which axis you want to add a label to. There are a few options for this and it is your choice depending on the style you want.

11. Add Axis Labels

12. What You Should See

13. Add A “Best-Fit” Line Now we will work on the graph itself. We will not use the tabs. Right click on one of the data point on the graph. Highlight “Add Trendline” and click.

14. Add A “Best-Fit” Line Click the button for the “Linear” Trend Type. And check the box for “Display Equation on Chart”. Then click close.

15. Final Product