How to use EXCEL

1. How to use EXCEL By: Ms. Lieu

2. Type in your data points

3. 2. Highlight the two columns.

4. 3. Move arrow to the top. Click on the tab “INSERT”. Then click on “SCATTER.” Pick the first box below.

5. YOU should SEE

6. 6. Click on the first button for chart layout. This is to add the title and legend.

7. If you can on any of the numbers you can change the range of numbers used. Or you can get rid of the lines on the graph too. 7. Fix by typing in the correct axis titles. You can change the title too.

8. 8. Adding a trendline (y=mx +b). Right click on any one point. A window should appear and click on “Add trendline.”

9. 9. A window will appear. Click the graph that fits “best”. USUALLY LINEAR. Near the bottom click display equation and more.

10. Congratulations!!! You have learned the basics how to use Excel to graph. Now try on your own a more complicated graph. HAVE FUN!!!

11. Outline • Making Bar Graphs • Making Scatter Plots – 1 series • Making Scatter Plots – Multiple Series

12. Making Bar Graphs

13. Type in your data

14. Select Insert Graph (Scatter Plot) • Select “Insert” tab • Select Scatter -You may choose to have points connected by curved or straight lines

15. Insert Graph Once you select your type of graph, you will get a box that will likely be empty but may have a graph depending on what you had selected prior to inserting the graph

16. Select Your Data • Select the graph area • Click on the design tab under chart tools • Click on select data Graph area

17. Select Your Data 1. Click on Add series* * If any data was previously selected, select that series and click remove

18. Type in Series Name

19. Select x-axis data for series 1 Do not select the title, just your data points

20. Select y-axis data for series 1

21. 1. Once series 1 is added, you will return to the previous box, click “Add” to add another series

22. Add Series 2 – Type series name

23. Select x-axis data for series 2 Note how the x-axis is the same for this and all series of this graph

24. Select y-axis data for series 2

25. 1. Once series 2 is added, you will return to the previous box, click “Add” to add another series

26. Add series 3 – Type series name

27. Select x-axis data for series 3

28. Select y-axis data for series 3

29. 1. Once series 3 is added, you will return to the previous box, click “Add” to add another series

30. Add series 4 – Type series name

31. Select x-axis data for series 4

32. Select y-axis data for series 4

33. Once you have added all series click “ok” and the “Select Data Source” box will close.

34. Add a title to your graph Under the “Layout” tab in Chart tools, select “Chart Title” and then “Above Chart”

35. Add a title to your graph A title box, like the one shown here, will appear above your graph

36. Type in your title

37. Label the x-axis Under the “Layout” tab in “Chart tools”, select “Axis Titles”, then “Primary Horizontal Axis Title” and “Title Below Axis”

38. Label the x-axis A title box, like the one shown here, will appear below the x-axis

39. Label the x-axis Type in your x-axis title

40. Label the y-axis Under the “Layout” tab in “Chart tools”, select “Axis Titles”, then “Primary Vertical Axis Title” and “Rotated Title”

41. Label the y-axis A title box, like the one shown here, will appear next to the y-axis

42. Label the y-axis Type in your y-axis title

43. And you are done!!! • To copy your graph into a word document, right click on the graph and select “Copy.” In your word document, right click on the blank page and select “Paste” • PRINT OUT YOU GRAPH AND TURN IN.