BIOLOGY FOR LIFE
  • ⭐IB Bio Syllabus⭐
    • Unity and Diversity (A) >
      • A1 molecules >
        • A1.1: Water
        • A1.2: Nucleic Acids
      • A2 Cells >
        • A2.1: Origins of Cells
        • A2.2: Cell Structure
        • A2.3: Viruses
      • A3 Organisms >
        • A3.1: Diversity of Organisms
        • A3.2: Classification and Cladistics
      • A4 Ecosystems >
        • A4.1: Evolution and Speciation
        • A4.2: Conservation of Biodiversity
    • Form and Function (B) >
      • B1 Molecules >
        • B1.1: Carbohydrates and Lipids
        • B1.2: Proteins
      • B2 Cells >
        • B2.1 Membranes and Membrane Transport
        • B2.2 Organelles and Compartmentalization
        • B2.3 Cell Specialization
      • B3 Organisms >
        • B3.1 Gas Exchange
        • B3.2 Transport
        • B3.3 Muscle and Motility
      • B4 Ecosystems >
        • B4.1 Adaptation to Environment
        • B4.2 Ecological Niches
    • Interaction and Interdependence (C) >
      • C1 Molecules >
        • C1.1: Enzymes and Metabolism
        • C1.2: Cell Respiration
        • C1.3: Photosynthesis
      • C2 Cells >
        • C2.1: Chemical Signaling
        • C2.2: Neural Signaling
      • C3 Organisms >
        • C3.1: Integration of Body Systems
        • C3.2: Defense Against Disease
      • C4 Ecosystems >
        • C4.1 Populations and Communities
        • C4.2 Transfers of Energy and Matter
    • Continuity and Change (D) >
      • D1 Molecules >
        • D1.1: DNA Replication
        • D1.2: Protein Synthesis
        • D1.3: Mutation and Gene Editing
      • D2 Cells >
        • D2.1: Cell and Nuclear Division
        • D2.2: Gene Expression
        • D2.3: Water Potential
      • D3 Organisms >
        • D3.1: Reproduction
        • D3.2: Inheritance
        • D3.3: Homeostasis
      • D4 Ecosystems >
        • D4.1: Natural Selection
        • D4.2: Stability and Change
        • D4.3: Climate Change
    • Legacy Syllabus (2016) >
      • Core >
        • 1: Cell Biology >
          • 1.1: Introduction to Cells
          • 1.2: Ultrastructure of Cells
          • 1.3: Membrane Structure
          • 1.4: Membrane Transport
          • 1.5: The Origin of Cells
          • 1.6: Cell Division
        • 2: Molecular Biology >
          • 2.1: Molecules to Metabolism
          • 2.2: Water
          • 2.3: Carbohydrates and Lipids
          • 2.4: Proteins
          • 2.5: Enzymes
          • 2.6: DNA and RNA
          • 2.7: DNA Replication, Transcription and Translation
          • 2.8: Cell Respiration
          • 2.9: Photosynthesis
        • 3: Genetics >
          • 3.1: Genes
          • 3.2: Chromosomes
          • 3.3: Meiosis
          • 3.4: Inheritance
          • 3.5: Genetic Modification and Biotechnology
        • 4: Ecology >
          • 4.1: Species, Communities and Ecosystems
          • 4.2: Energy Flow
          • 4.3: Carbon Cycling
          • 4.4: Climate Change
        • 5: Evolution and Biodiversity >
          • 5.1: Evidence for Evolution
          • 5.2: Natural Selection
          • 5.3: Classification and Biodiversity
          • 5.4: Cladistics
        • 6: Human Physiology >
          • 6.1: Digestion and Absorption
          • 6.2: The Blood System
          • 6.3: Defense Against Infectious Disease
          • 6.4: Gas Exchange
          • 6.5: Neurons and Synapses
          • 6.6: Hormones, Homeostasis and Reproduction
      • Higher Level >
        • 7: Nucleic Acids >
          • 7.1: DNA Structure and Replication
          • 7.2: Transcription and Gene Expression
          • 7.3: Translation
        • 8: Metabolism, Cell Respiration & Photosynthesis >
          • 8.1: Metabolism
          • 8.2: Cell Respiration
          • 8.3: Photosynthesis
        • 9: Plant Biology >
          • 9.1: Transport in the Xylem of Plants
          • 9.2: Transport in the Phloem of Plants
          • 9.3: Growth in Plants
          • 9.4: Reproduction in Plants
        • 10: Genetics and Evolution >
          • 10.1: Meiosis
          • 10.2: Inheritance
          • 10.3: Gene Pools and Speciation
        • 11: Animal Physiology >
          • 11.1: Antibody Production and Vaccination
          • 11.2: Movement
          • 11.3: Kidney and Osmoregulation
          • 11.4: Sexual Reproduction
      • Options >
        • D: Human Physiology >
          • D.1: Human Nutrition
          • D.2: Digestion
          • D.3: Functions of the Liver
          • D.4: The Heart
          • D.5: Hormones and Metabolism
          • D.6: Transport of Respiratory Gases
  • IB Requirements
    • Learner Profile
    • Collaborative Sciences Project
    • External Assessment
    • Internal Assessment >
      • Research Design
      • Analysis
      • Conclusion
      • Evaluation
    • Extended Essay
  • Exam Revision
    • Revision Tools
  • Skills for Biology
    • Tools >
      • Experimental Techniques >
        • Addressing Safety
        • Measuring Variables >
          • Lab Drawings
          • Measurement Uncertainty
        • Techniques >
          • Microscopy
      • Technology >
        • Graphing with Excel
      • Mathematics >
        • Statistics >
          • Glossary of Statistic Terms and Equations
          • Descriptive Statistics >
            • Skew and the Normal Distribution
            • Outliers
            • Measures of Central Tendancy
            • Measures of Spread
            • Pearson Correlation
          • Inferential Statistics >
            • T-Test
            • ANOVA
            • Kruskal-Wallis
            • X2 Test for Independence
            • X2 Goodness of Fit
        • Graphing >
          • Interpreting Error Bars
    • Inquiry Processes >
      • Exploring & Designing >
        • Research Questions
        • Hypotheses and Predictions
        • Varaibles
        • Sampling
      • Collecting & Processing Data >
        • Data Tables
      • Concluding & Evaluating >
        • Error Analysis
  • SHS Course Info
    • Above & Beyond >
      • Biology Club
      • Pumpkin Carving
      • Scavenger Hunt
      • Science News
      • Wood Duck Project (legacy)
      • Invasive Crayfish Project (legacy)
    • Assessment >
      • Class Grading IB Bio I
      • Class Grading IB Bio II
      • Daily Quizzes (legacy)
      • Lab Practicals (legacy)
    • Class Photos
    • Recommendations
  • Contact
  • About
    • Philosophy
    • Resume
    • Reflection
    • Favorite Quotes
    • AEF Blog
  • Expeditions
    • Bahamas (2009)
    • Trinidad (2010)
    • Trinidad (2011)
    • Ecuador (2012)
    • Trinidad (2013)
    • Peru (2014)
    • Bahamas (2015)
    • Peru (2016)
    • Costa Rica (2017)
    • Costa Rica (2018)
    • Arizona (2022)
    • Florida (2023)
    • Belize (2024)
    • Costa Rica (2025)
  • Summer Ecology Research
  • Teacher Resources

Graphing with Excel 2016

Scroll down the page to get directions for creating pie charts, bar graphs, histograms, line graphs and scatter plots in Excel.

If you prefer to graph in Google Sheets, here's a tip sheet, including how to add custom error bars to your graphs!
Pie Chart
In your spreadsheet, select the data to use for your pie chart. Click Insert > Insert Pie or Doughnut Chart, and then pick the specific chart you want. Click the chart and then click the icons next to the chart to add a title and adjust labels.
Picture
Picture
Bar Graph
In your spreadsheet, select the data to use for your bar chart (typically this is the mean of a data set).  Click Insert > Insert 2-D Column.  Click the chart and then click the icons next to the chart to add axis labels and a title.
Picture
Picture
Next you need to add the standard deviations lines for each bar.  Click on the chart and then Add Chart Element.  Select Error Bars from the drop down menu and then "More Error Bars Options."  This is counter intuitive when there is an option called "standard deviation" directly above.  But, DON'T pick standard deviation here!  If you do, then Excel will calculate the standard deviation of the means collectively, not graph each means SD individually.  Big no-no. 
Picture
A side bar will open with options.  You want to select both directions, cap, custom and specify value.  A pop up box will appear.  Delete what is in the Positive Error Value box and then select the standard deviations for your means.  Select all the standard deviations together.  ​Hit OK and then repeat for the Negative Error Value.  You will be selecting the same SD values for both the positive and negative values.  You will know if you've done it correctly when you have bars on your graph that are equal distance above and below the mean value and unique for each level of the manipulated variable on your X-axis.
Picture
Picture
One item that often needs to be adjusted on graphs made by Excel is the consistency in precision of the values on the X and/or Y axis.  Like your data, the values on the X and Y axis should have a consistent and correct number of digits. Excel will not default to the correct number.  In order to change these values, right click on the axis label values and select Format Axis.  A side menu will appear.  Click by the Number heading.  Change the category for Number and indicate the number of decimal places you would like the labels to have.

Histogram
​Select your data and click insert > Insert Statistic Chart > Histogram.  
Picture
To adjust the spacing of the histogram bins (the amount of data grouped along the X-axis), right click on the horizontal axis on the chart, click Format Axis and then Axis Options.
Picture
On the side bar, you can adjust the x-axis groupings by changing either the "bin width" or the "number of bins."
Picture
As above in the directions for a Bar Graph, finalize formatting of the histogram (i.e. adding a title and labeling axis) by selecting Add Chart Element from the Design tab.  Also, if needed, adjust the values on the X and Y axis to ensure consistency and correctness in the number of digits being displayed.  
Line Graph
Be sure you have your data in columns, with the X-axis variable to the left of the Y-axis variable data.   Select your data and click insert > Insert Scatter > Scatter with Straight Lines and Markers.  
Picture
Click the graph, and on the design tab select Add Chart Element to include a graph title and axis labels.  Often you'll need to adjust the values on the axis so they include the a correct and consistent number of digits.  Right click on the axis values, and from the side menu select number.  In the box, indicate you want a number and then how many digits you want to include after the decimal place.
Picture
As with a bar graph, you often need to add the SD error bars to a line graph.  Click on the chart and then Add Chart Element.  Select Error Bars from the drop down menu and then "More Error Bars Options."  This is counter intuitive when there is an option called "standard deviation" directly above.  But, DON'T pick standard deviation here!  If you do, then Excel will calculate the standard deviation of the means collectively, not graph each means SD individually.  Big no-no. ​

​A side bar will open with options.  You want to select both directions, cap, custom and specify value.  A pop up box will appear.  Delete what is in the Positive Error Value box and then select the standard deviations for the data points.  Select all the standard deviations together.  Hit OK and then repeat for the Negative Error Value.  You will be selecting the same SD values for both the positive and negative values.  You will know if you've done it correctly when you have bars on your graph that are equal distance above and below the mean value and unique for each level of the manipulated variable on your X-axis.
Scatter Plot
Be sure you have your data in columns, with the X-axis variable to the left of the Y-axis variable data.   Select your data and click insert > Insert Scatter > Scatter.  
Picture
Click the graph, and on the design tab select Add Chart Element to include a graph title and axis labels.  Often you'll need to adjust the values on the axis so the data is not clumped together on the graph.  Right click on the axis and you want to adjust and select Format Axis.  On the side menu, adjust the "bounds" so that the data points are spread throughout the graph.  You might need to do this for both the X and Y axis values.
Picture
As with the examples above, you can adjust the axis values to ensure the data has the correct and consistent number of digits. ​Right click on the axis values, and from the side menu select number.  In the box, indicate you want a number and then how many digits you want to include after the decimal place.
Picture
To add a trend line, right click on any data point in your graph and select Add Trend Line.  From the side menu, select the type of trend line you want to add.
Picture
If appropriate for your data set, you can color code the data points so that data collected in different times, places or ways can be differentiated.  Right click a data point and chose Select Data.  From there you can edit and add different data sources.  Each data source will be show as a different color dot.
Picture
I give many of my IB Biology resources away, for the benefit of students and teachers around the world. 
If you've found the materials helpful, please consider making a contribution of any amount
to this Earthwatch Expedition Fund or donating a puzzle to our classroom from our wish list.


​Did I forget something?  Know of a mistake? Have a suggestion?  Let me know by emailing me here.

Before using any of the files available on this site,
​please familiarize yourself with the 
Creative Commons Attribution License. 
​​​It prohibits the use of any material on this site for commercial  purposes of any kind.  ​
​
Picture
  • ⭐IB Bio Syllabus⭐
    • Unity and Diversity (A) >
      • A1 molecules >
        • A1.1: Water
        • A1.2: Nucleic Acids
      • A2 Cells >
        • A2.1: Origins of Cells
        • A2.2: Cell Structure
        • A2.3: Viruses
      • A3 Organisms >
        • A3.1: Diversity of Organisms
        • A3.2: Classification and Cladistics
      • A4 Ecosystems >
        • A4.1: Evolution and Speciation
        • A4.2: Conservation of Biodiversity
    • Form and Function (B) >
      • B1 Molecules >
        • B1.1: Carbohydrates and Lipids
        • B1.2: Proteins
      • B2 Cells >
        • B2.1 Membranes and Membrane Transport
        • B2.2 Organelles and Compartmentalization
        • B2.3 Cell Specialization
      • B3 Organisms >
        • B3.1 Gas Exchange
        • B3.2 Transport
        • B3.3 Muscle and Motility
      • B4 Ecosystems >
        • B4.1 Adaptation to Environment
        • B4.2 Ecological Niches
    • Interaction and Interdependence (C) >
      • C1 Molecules >
        • C1.1: Enzymes and Metabolism
        • C1.2: Cell Respiration
        • C1.3: Photosynthesis
      • C2 Cells >
        • C2.1: Chemical Signaling
        • C2.2: Neural Signaling
      • C3 Organisms >
        • C3.1: Integration of Body Systems
        • C3.2: Defense Against Disease
      • C4 Ecosystems >
        • C4.1 Populations and Communities
        • C4.2 Transfers of Energy and Matter
    • Continuity and Change (D) >
      • D1 Molecules >
        • D1.1: DNA Replication
        • D1.2: Protein Synthesis
        • D1.3: Mutation and Gene Editing
      • D2 Cells >
        • D2.1: Cell and Nuclear Division
        • D2.2: Gene Expression
        • D2.3: Water Potential
      • D3 Organisms >
        • D3.1: Reproduction
        • D3.2: Inheritance
        • D3.3: Homeostasis
      • D4 Ecosystems >
        • D4.1: Natural Selection
        • D4.2: Stability and Change
        • D4.3: Climate Change
    • Legacy Syllabus (2016) >
      • Core >
        • 1: Cell Biology >
          • 1.1: Introduction to Cells
          • 1.2: Ultrastructure of Cells
          • 1.3: Membrane Structure
          • 1.4: Membrane Transport
          • 1.5: The Origin of Cells
          • 1.6: Cell Division
        • 2: Molecular Biology >
          • 2.1: Molecules to Metabolism
          • 2.2: Water
          • 2.3: Carbohydrates and Lipids
          • 2.4: Proteins
          • 2.5: Enzymes
          • 2.6: DNA and RNA
          • 2.7: DNA Replication, Transcription and Translation
          • 2.8: Cell Respiration
          • 2.9: Photosynthesis
        • 3: Genetics >
          • 3.1: Genes
          • 3.2: Chromosomes
          • 3.3: Meiosis
          • 3.4: Inheritance
          • 3.5: Genetic Modification and Biotechnology
        • 4: Ecology >
          • 4.1: Species, Communities and Ecosystems
          • 4.2: Energy Flow
          • 4.3: Carbon Cycling
          • 4.4: Climate Change
        • 5: Evolution and Biodiversity >
          • 5.1: Evidence for Evolution
          • 5.2: Natural Selection
          • 5.3: Classification and Biodiversity
          • 5.4: Cladistics
        • 6: Human Physiology >
          • 6.1: Digestion and Absorption
          • 6.2: The Blood System
          • 6.3: Defense Against Infectious Disease
          • 6.4: Gas Exchange
          • 6.5: Neurons and Synapses
          • 6.6: Hormones, Homeostasis and Reproduction
      • Higher Level >
        • 7: Nucleic Acids >
          • 7.1: DNA Structure and Replication
          • 7.2: Transcription and Gene Expression
          • 7.3: Translation
        • 8: Metabolism, Cell Respiration & Photosynthesis >
          • 8.1: Metabolism
          • 8.2: Cell Respiration
          • 8.3: Photosynthesis
        • 9: Plant Biology >
          • 9.1: Transport in the Xylem of Plants
          • 9.2: Transport in the Phloem of Plants
          • 9.3: Growth in Plants
          • 9.4: Reproduction in Plants
        • 10: Genetics and Evolution >
          • 10.1: Meiosis
          • 10.2: Inheritance
          • 10.3: Gene Pools and Speciation
        • 11: Animal Physiology >
          • 11.1: Antibody Production and Vaccination
          • 11.2: Movement
          • 11.3: Kidney and Osmoregulation
          • 11.4: Sexual Reproduction
      • Options >
        • D: Human Physiology >
          • D.1: Human Nutrition
          • D.2: Digestion
          • D.3: Functions of the Liver
          • D.4: The Heart
          • D.5: Hormones and Metabolism
          • D.6: Transport of Respiratory Gases
  • IB Requirements
    • Learner Profile
    • Collaborative Sciences Project
    • External Assessment
    • Internal Assessment >
      • Research Design
      • Analysis
      • Conclusion
      • Evaluation
    • Extended Essay
  • Exam Revision
    • Revision Tools
  • Skills for Biology
    • Tools >
      • Experimental Techniques >
        • Addressing Safety
        • Measuring Variables >
          • Lab Drawings
          • Measurement Uncertainty
        • Techniques >
          • Microscopy
      • Technology >
        • Graphing with Excel
      • Mathematics >
        • Statistics >
          • Glossary of Statistic Terms and Equations
          • Descriptive Statistics >
            • Skew and the Normal Distribution
            • Outliers
            • Measures of Central Tendancy
            • Measures of Spread
            • Pearson Correlation
          • Inferential Statistics >
            • T-Test
            • ANOVA
            • Kruskal-Wallis
            • X2 Test for Independence
            • X2 Goodness of Fit
        • Graphing >
          • Interpreting Error Bars
    • Inquiry Processes >
      • Exploring & Designing >
        • Research Questions
        • Hypotheses and Predictions
        • Varaibles
        • Sampling
      • Collecting & Processing Data >
        • Data Tables
      • Concluding & Evaluating >
        • Error Analysis
  • SHS Course Info
    • Above & Beyond >
      • Biology Club
      • Pumpkin Carving
      • Scavenger Hunt
      • Science News
      • Wood Duck Project (legacy)
      • Invasive Crayfish Project (legacy)
    • Assessment >
      • Class Grading IB Bio I
      • Class Grading IB Bio II
      • Daily Quizzes (legacy)
      • Lab Practicals (legacy)
    • Class Photos
    • Recommendations
  • Contact
  • About
    • Philosophy
    • Resume
    • Reflection
    • Favorite Quotes
    • AEF Blog
  • Expeditions
    • Bahamas (2009)
    • Trinidad (2010)
    • Trinidad (2011)
    • Ecuador (2012)
    • Trinidad (2013)
    • Peru (2014)
    • Bahamas (2015)
    • Peru (2016)
    • Costa Rica (2017)
    • Costa Rica (2018)
    • Arizona (2022)
    • Florida (2023)
    • Belize (2024)
    • Costa Rica (2025)
  • Summer Ecology Research
  • Teacher Resources