browser icon
You are using an insecure version of your web browser. Please update your browser!
Using an outdated browser makes your computer unsafe. For a safer, faster, more enjoyable user experience, please update your browser today or try a newer browser.

How to graph data for your science fair project

Posted by on April 8, 2012

Once you have your data, you will need to present it to your teacher and science fair judges. In a science publication, you would choose between a table and a graph, but for the science fair project it is acceptable, and even encouraged, to showcase the data in both forms. If you have to pick (teacher’s rules), then a graph (picture) is better than a table (numbers), EXCEPT that most scientists really, really like numbers – so we are happy to see the table too.

Type of graphs: Your first choice is to determine which type of graph would best communicate your findings. Your basic choices are bar graph, line graph, pie chart, or scatter plot.

BAR GRAPH – This is the most common type for science fair projects. You may select a bar graph when your independent variable is qualitative (categories) or quantitative (numbers). It is generally better to group the data by TREATMENT instead of TRIAL # because it allows a better comparison of variation within the treatment. This might not be intuitive if you collected by trial, but it is the better way to showcase your results.

An example of a bar graph

Look closely and make sure your bar graph has all the highlighted parts:

Independent variable may be qualitative or quantitative

LINE GRAPH – This is the second most common, but frequently used incorrectly, so be careful here. You should only select a line graph if your independent variable is quantitative (numbers) and you hypothesized that the changes in the independent variable would result in changes in the dependent one. For example, line graphs are great for showing changes in the dependent variable over time or distance along a transect.

An example of a line graph

Again double check the axes:

Independent variable MUST be quantitative

PIE CHART – Pie charts are good for projects that have qualitative independent variables and have generated data that can be expressed as percentages of the total. For example, if your data were counts (i.e. the number of times something happened), then this might be your best choice to compare different treatments.

An example of a pie chart

SCATTER PLOT – If the purpose is to see if the variables are related (common in environmental projects), but there was not a clear choice for independent and dependent variables (for example wind speed and water temperature), then a scatter plot would be your best choice. This option typically requires much more data than the others to observe a trend.

Scatter plots are also called X-Y plots

Scientists do not label graphs with a title, but if your teacher asks for one — make sure that is there too.

42 Responses to How to graph data for your science fair project

  1. jeffery

    this is a nice thing you are doing

  2. Sharee

    Excellent information, great page theme, continue the great work

  3. carolina

    i really need help on my data

    • Dr. Maille Lyons

      What do you need, that you didn’t find here?

      First, think about which variable did you change? – that will be your INDEPENDENT variable and it will go on the x-axis (horizontal one). Now determine your DEPENDENT variable – it is the thing that you actually measured or counted. These data will go on the y-axis (vertical one).

      If your independent variable is quantitative (numbers) then you could do a LINE graph or a BAR graph, but if your independent variable is qualitative (categories like colors, or male vs. female, or high-med-low) then you should be making a bar graph.

      Hope that helps, if not – ask a more specific question – what help do you need?

  4. isabella

    I am confused. I am in 6th grade and I did my project on my question can I grow stalactites in a manipulated environment. I did two experiments. One in the house with a set temp of 76 degrees, and the other in the garage at random temps. How would I do a graph? They both grew but differently. I am not sure what kind of graph to do, thank you

    • Dr. Maille Lyons

      OK – let’s take a look at what you did:

      1 experiment with 2 conditions: a. constant temperature condition and b. variable temperature condition

      How did you measure growth?
      If you only measured growth one time at the end, then you could do a bar graph showing the total growth attained. One bar for each condition – bigger bar wins!

      If you measured growth several times over the course of the time you let them grow, then you could do a line graph showing growth (y-axis) over time (x-axis). One line for each condition.

      You may want to re-phrase your question: What is the effect of temperature variation on stalactite growth?

      Hope that helps!

  5. Sydney

    I don’t know how to graph my data. I did which product affects the decaying of apple slices the most. I used Epsom salt, salt, and baking soda. The salt slowed down the decaying the most, and the baking soda sped it up the most. How do I put this into a graph????

    • Dr. Maille Lyons

      OK – what did you actually measure? In other words, how did you get to the conclusion that the salt slowed down the decaying the most?

      Was it time (how long it took each one to decay?)
      Was it weight loss? or Percent weight loss?
      Was it percent color change?

      You will most likely be doing a BAR GRAPH- with each treatment: Epsom salt, salt, and baking soda on the x-axis and whatever you measured on the y-axis

      If you did a control (no treatment) – you can calculate the percent change from the control value

  6. Becky McKenzie

    I did an experiment melting M&M’s, trying to see if certain colors melt faster than others. I am trying to find a graph to show my results. I have not made a graph on the computer before. Please advise me as to website that would be best. Thanks.

  7. Martha

    I am doing the experiment how sodas affect tooth decay. Choose 4 sodas placed teeth in each measuring 600ml watching changes to each tooth over a 5 day period to observe which soda caused the quickest decay. How do i place the information on a graph?
    Thank you.

    • Dr. Maille Lyons

      How are you measuring “decay” – visually or will you weigh them… or ?

      If you have a quantitative dependent (time, weight, size, etc.) then that will go on your y-axis with type of soda on your x-axis.

  8. Sydney Juranty

    Thanks so much!

  9. Christopher Gallagher

    I am doing my science fair project on Wind using a homemade anemometer. I will be testing the wind every morning for 7 days and then compare the wind activity for the same seven days last year. How do set up a graph in excel? I am so confused and dont know how to set the formulas up-please help!

    • Dr. Maille Lyons

      First, what was your question?

      Based on what you have provided, it sounds like you want to compare this year’s 7 days to last year’s 7 days. I would recommend a line graph with day (1-7) on the x-axis and wind speed on the y-axis. Put one set of data (e.g. this year) in one color and the other set (e.g. last year) in another color. You will be able to see which line was “higher” (i.e. more windy) and which line was “more variable” and hopefully that will answer whatever question you selected.

      You can use excel to make a graph, but it will be hard for me to explain how if you aren’t familiar with excel. I generally recommend this website:

      http://nces.ed.gov/nceskids/createagraph/

      (cut and paste into your browser; or Google “Create a Graph”)

  10. sheila scott

    Hello, I am doing my 6th grade Science Fair Project on Whether Pop Cans will sink or float. I used Coke, Diet Coke, Coke Zero, Caffeine Free Diet Coke, and Caffeine Free Coke Zero. They all floated except for the Coke. How would I do a Graph or Chart for this.

    Thank you for you help
    Sheila Scott

    • Dr. Maille Lyons

      How many cans per type of soda did you do? Were the results all the same? You should probably just do a table with Type of Soda across the top and sink and float down the side: then fill it in with yes or no.

      • Kamden

        I’m doing this same type of project also. I wanted to note the sugar weight and how that effected floating and sinking of regular sodas versus diet sodas (containing small amounts of aspertame). I also weighed the cans on a gram scale (they were all a little different) Is there any way to make an actual graph to display on my science fair board? Thanks!

        • Dr. Maille Lyons

          If the only thing that you “measured” was yes or no regarding the floating … then no, not really. If you measured the time it took to for the can to sink or float then you could put that on the y-axis (bar graph)

  11. Darlene Couch

    My daughter is doing a science fair project on which soda stains teeth the most. She is using visual comparisons. How can she graph and chart this

    • Dr. Maille Lyons

      Generally, you can’t graph qualitative variables like which one stains the most unless you can come up with some sort of a rating scale. For example if she sets up a sequence from “no staining = 0″ to “light staining = 1″ to “moderate staining = 2″ etc. up to heavy staining with whatever number you are on… then she could make a bar graph with soda on the x-axis and staining on the y-axis. You may need to establish the rating scale using something like time (so “light staining = 1″ would be the equivalent to soaking for 1 (hour or day or week depending on the scale you are making)). You might need a rating scale for each soda, for example, you shouldn’t use a staining scale made with a cola to evaluate an orange soda.

      Alternatively she might be able to re-phrase the question looking at how long (time is a quantitative variable) does it take to get to a certain level of staining and then compare “time” as a proxy for “stains the most”.

  12. Luly Fundies

    Please help me, i think i should use a bar graph and have different colors for each trial, because i am finding the speed of waves through three trial. (by waves i mean waves from the eleectromagnetic spectrum)

    • Dr. Maille Lyons

      I need a bit more information… Sounds like you could use a bar graph for that type of data. You would have speed on the y-axis and what ever was different in each trial on the x-axis

  13. Jessie

    My daughter is in 3rd grade and has to show a graph or table but I have no idea how to help her with this… Her project was sucking an egg through a bottle and all three times the egg went in… How would you graph it or make a table with that information?????

    • Dr. Maille Lyons

      If she measured the time it took for the egg to go in, she could do a bar graph of treatment (x-axis; i.e. different conditions under which she tested the egg drop) vs. time (y-axis). If she didn’t measure the time but noted which conditions made the egg go in faster, she could make a table and rank them slow, medium, fast.

  14. Erli

    Hello , my daughter is doing a science project : color changing carnation , but we do not know how to make a graph , we use a food coloring in blue , 4 tubes , with 4 carnation , de first tube no colorant so no change , the second tube 10 drops , the third 20 drops and the fourth 39 drops of blue , the flowers in tube 2,3,4 changed blue , the fourth was the darker , how we can do ? Please and thanks so much !!!!! We do not know what to put in x axis and in y axis

    • Dr. Maille Lyons

      The x-axis (horizontal) would be the number of drops, the y-axis would be something you measured. For example the time it took to first see color, or some measure of “how blue” each flower was. If you only have a yes/no as to color, then you can not make a graph. I would suggest making a table and including photographs to show the differences between the color in each flower as a function of how much food coloring was in the tube.

  15. Erli

    Thanks so much !!!!! We measured the time , for example ; we checked every two hours , and we saw changes in color , until 10 hours that was the darkest point . In the x axis can we put tube a ,tube b , tube c and tube d and in parenthesis 0 drops , 10 drops , 20 drops and 30 drops ?. The problem is the y axis , we do not know how to arrange it …. We can use the hours , for example 0,2,4,6,8 and 10 , but what we create the bars ? Thanks !!!!!

    • Dr. Maille Lyons

      You could make a TABLE with each Column being the Tube and each Row being the Time in two hour increments; the boxes would then be filled with words describing the color changes in each tube – so marking when the first signs of color appeared and then which ones got darker and when.

      For a BAR GRAPH, you would set up the x-axis as you described above and then use the TIME TO FIRST SIGN OF COLOR CHANGE (should be a single time point) or you could use TIME TO DARKEST COLOR CHANGE (if they didn’t all become the same color by 10 hours)

  16. Marguerite

    We need to graph 20 trials in which there was only one response per trial: Yes or No. Can we do a line graph for this and how would it be done?

    Thanks!
    Marguerite

    • Dr. Maille Lyons

      No – sorry, you can’t do a line graph with that type of data. At best you can do a bar graph to show what % of the 20 trials were yes, but if you don’t have a control group, then you would only have 1 bar. Try a pie chart with the % of yes vs. no

  17. Kery

    My daughter did a project on Which Stemmed Flower Lasts The Longest In water after picked. We did a rose, carnation and an amaryllis. We did two experiments, one set of flowers in one cup of water and one set with 1/2 cup of water for two weeks. How would you recommend that we graph this and which graph would be good to use?

    • Dr. Maille Lyons

      I will assume you measured “time” for your dependent variable? Then you would make a bar graph with flower type on the x-axis and time on the y-axis. I am not clear why you did one cup of water vs. 1/2 cup of water. Were there differences? If yes, make two graphs (one for each) but if not, average the results (or present two bars per flower type) on the bar graph.

  18. James

    Hello, my name is James and I am in 3rd grade. I am doing which method makes most tender beef. I used soy sauce, baking soda, meat tenderizer hammer and a control that did not have anything done to it. My dad cooked the meat. We gave a piece of each one to 5 of his friends. They decided which one was most tender down to the least tender. The baking soda was most tender. The control was least tender. They had different ranks for least to most tender. What is the best graph to use for this data? Thank you.

    James
    3rd grade

    • Dr. Maille Lyons

      Great project! You could do a bar graph with “treatment” on the x-axis (control, soy sauce, meat tend., and hammer) and then the “average” rank on the y-axis. You would need to convert the “ranks” into numbers, just set a scale from least (1) to most (5?) and then average the numbers. I would also include a data table showing the each of the 5 friends ranks for each of the 5 treatments (set up a 5 by 5 table).

  19. Echo

    I am doing a science fair project to see if lemons or potatoes will keep a lightbulb lit the longest. I put ‘Time the lightbulb stayed lit(min)’ as my dependent variable and lemons and potatoes as my independent variables. (I.e. in the bar graph you made, coffee and water would be substituted for lemons and potatoes.) Is this correct? The main problem I’m having with this is that I’m not sure what I should put as their title, for example, where you put treatment. Can you please help me? Thanks!

    • Dr. Maille Lyons

      “Treatment” still works for you, it is just a generic term for “things that varied in my experiment”; Alternatively you could use “Battery” or “Organic Battery”. Make sure the “Batteries” are on the x-axis and time (min) is on the y-axis.

  20. Alexis

    If I have 10 trials, and in each trial I mark yes or no that my bug tried to climb the wall of the maze, and I want to show change over time, how could I show that on a line graph?

    More info on my assignment:
    First three trials were baseline.
    The next eight tracked whether or not wall climbing happened while my intervention was in placed.

    So, I need to show the Yeses go down over the course of ten trials and the No’s go up over the course of the same ten trials. I want to show it on the same line graph for comparison, but I can’t figure out how to show it .

    • Dr. Maille Lyons

      OK – so there is no line graph in your future… sorry, you don’t have the correct type of data.

      And I can’t see 10 trials based on the info you have provided. You have 3 trials for a control and 8 trials for an experiment (I am assuming your “intervention” was the same for each of the 8 trials).

      You can do a bar graph showing what percentage of times “wall climbing” occurred by calculating the number of “yes” for the control (0 out of 3; or 3 out of 3; or # out of 3) and compare that to the percentage of times for the intervention (# out of 8).

      If you are trying to show “learning” – that perhaps the bug learned to climb (or not climb) the wall, then make a table of the 8 trials in the order that they were done, perhaps it would show a pattern if, for example you had data like: yes, yes, yes, yes, yes, no, no, no – would suggest the bug “learned” not to climb as compared to if your data looks like: yes, yes, yes, no, yes, no, no, yes – Do you see the difference?

      Did you always you the same bug?

Leave a Reply

Your email address will not be published. Required fields are marked *

You may use these HTML tags and attributes: <a href="" title=""> <abbr title=""> <acronym title=""> <b> <blockquote cite=""> <cite> <code> <del datetime=""> <em> <i> <q cite=""> <strike> <strong>