1 / 43

How to use EXCEL

How to use EXCEL. By: Ms. Lieu. Type in your data points. 2. Highlight the two columns. 3. Move arrow to the top. Click on the tab “INSERT”. Then click on “SCATTER.” Pick the first box below. YOU should SEE . 6. Click on the first button for chart layout. .

melba
Download Presentation

How to use EXCEL

An Image/Link below is provided (as is) to download presentation Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author. Content is provided to you AS IS for your information and personal use only. Download presentation by click this link. While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server. During download, if you can't get a presentation, the file might be deleted by the publisher.

E N D

Presentation Transcript


  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.

More Related