1 / 51

Basic Graphing Using Excel

Basic Graphing Using Excel. Sweet Tea Sugar Detection. Create Your Data Table in Excel. Note: Column I is the Sum of Columns D, E, F, and G. How to Make a Pie Chart. Taste Rankings at a Single Sugar Concentration (200mM). Using the Insert Tab, Choose Pie Chart.

dawn
Download Presentation

Basic Graphing Using 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. Basic Graphing Using Excel Sweet Tea Sugar Detection

  2. Create Your Data Table in Excel

  3. Note: Column I is the Sum of Columns D, E, F, and G

  4. How to Make a Pie Chart Taste Rankings at a Single Sugar Concentration (200mM)

  5. Using the Insert Tab, Choose Pie Chart

  6. On the Chart Tools Design Tab, Choose “Select Data”

  7. Click the icon to the right of “Chart Data Range”

  8. Highlight the Data Range, then reclick the icon to the right

  9. Under “Horizontal (Category) Axis Labels, Click on “Edit”

  10. Select labels for data, then click “OK”

  11. Under Chart Tools Layout Tab, Select “Chart Title > Above Chart”

  12. Give the Chart a Title

  13. Choose Different Chart Designs Using the Chart Tools Design Tab (some will convert values to % of total)

  14. A Beautiful Graph of Your Data!

  15. How to Make a Line Graph The Dependence of Sugar Detection (Dependent Variable) on the Sugar Concentration (Independent Variable)

  16. Using the Insert Tab, Choose 2-D Line Graph

  17. On the Chart Tools Design Tab, Choose “Select Data”

  18. Click the icon to the right of “Chart Data Range”

  19. Highlight the Data Range, then reclick the icon to the right

  20. Under “Horizontal (Category) Axis Labels, Click on “Edit”

  21. Select labels for data, then click “OK”

  22. Under Chart Tools Layout Tab, Select “Chart Title > Above Chart”

  23. Give the Chart a Title

  24. Label the Axes Using the Chart Tools Layout Tab

  25. A Beautiful Graph of Your Data!

  26. How to Make a Bar Graph Taste Rankings at a Single Sugar Concentration (200mM)

  27. Using the Insert Tab, Choose 2-D Column Graph

  28. On the Chart Tools Design Tab, Choose “Select Data”

  29. Click the icon to the right of “Chart Data Range”

  30. Highlight the Data Range, then reclick the icon to the right

  31. Under “Horizontal (Category) Axis Labels, Click on “Edit”

  32. Select labels for data, then click “OK”

  33. Under Chart Tools Layout Tab, Select “Chart Title > Above Chart”

  34. Give the Chart a Title

  35. Label the Axes Using the Chart Tools Layout Tab

  36. A Beautiful Graph of Your Data!

  37. How to Make a Stacked Bar Graph Taste Rankings at a Single Sugar Concentration (200mM)

  38. Using the Insert Tab, Choose 2-D Stacked Column Graph

  39. On the Chart Tools Design Tab, Choose “Select Data”

  40. Click the icon to the right of “Chart Data Range”

  41. Highlight the Data Range, then reclick the icon to the right

  42. Under “Horizontal (Category) Axis Labels, Click on “Edit”

  43. Select labels for data, then click “OK”

  44. Change Each Legend Entries (Series) by Highlighting “Series 1” and then Clicking “Edit”

  45. Choose Corresponding Label, then Click “OK”

  46. Repeat with Each Series Label

  47. Under Chart Tools Layout Tab, Select “Chart Title > Above Chart”

  48. Give the Chart a Title

  49. Label the Axes Using the Chart Tools Layout Tab

  50. A Beautiful Graph of Your Data!

More Related