1 / 31

Graphing in Excel Part II – Bar Graphs

Oooh , that sounds like fun!. Graphing in Excel Part II – Bar Graphs. More fun than a barrel of monkeys!. Well, maybe not that fun…. Yeah. Nothing could be that fun!. Let’s begin. First you need some data to graph.

xenon
Download Presentation

Graphing in Excel Part II – Bar Graphs

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. Oooh, that sounds like fun! Graphing in ExcelPart II – Bar Graphs More fun than a barrel of monkeys!

  2. Well, maybe not that fun… Yeah. Nothing could be that fun!

  3. Let’s begin. First you need some data to graph. I’m going to use the data from last year’s owl pellet project. You can use it to practice. Then, when you make the bar graphs for your owl pellet lab report, you are going to use your real data from this year. Here to present the data is my friend, Barnaby.

  4. What’s in your pellet? Hi! I’m Barnaby the Barn Owl! Here is some data for you to graph.

  5. The best way to illustrate data that shows the amounts of different types of something is a bar graph. Nifty. Do they also call that a histogram? Why, yes they do!

  6. Open up the Excel Program. It will look like this:

  7. Enter the data into the spread sheet. • Data should be entered vertically. 2. Put the types of prey in the first column. 3. Put the number of each in the second column.

  8. Okay, let’s do it! • In the top left box, ‘1A,’ type the word vole. 2. Then keep typing the different kinds of prey down the column. pocket gopher mouse shrew rat bird mole DONE!

  9. 2. In the box directly to the right of each type of prey animal, type the number of each: Like this! 57 Good job! 6 giraffes 0 1

  10. When you’re done, it should look like this! It is okay if pocket gopher looks like it is cut off.. Fun, right?

  11. Now we’re going to make the graph. Move your mouse over the columns of data starting at the upper left until you have highlighted all the data. Not you again! Did someone say Mouse?!

  12. Highlighted data: Wait! A mouse! Where? I’m hungry! UhUh-oh… Uh-oh..!

  13. On the tabs on top, click on “Insert.” After you click, you will see a colorful collection of charts.

  14. To make a bar graph, click on the one called “Column.”

  15. Tada! It makes a graph for you: But we’re not done yet!

  16. You know that you must always give your graph a title and label both axes : This is the ‘’y” axis. This is the ‘’x” axis.

  17. Towards the top you will see something called “Chart Tools.” Choose “layout” to add axes labels (they call them axes titles) and a title for the graph. (They call it a chart title.)

  18. After it adds them, just click on them to change them to what you want them to say:

  19. Your graph should now look like this: You can even change the color if you want. To do that, choose “design” in Chart Tools.

  20. Here it is in green!

  21. Number of Prey Animal per Pellet Great! Now let’s make the second graph. This one is about the number of prey animals in the pellets. Here’s more data from last year.

  22. It’s just same process, but with different data. Spell out the numbers or it gets confused! I think I’m confused!

  23. No, it’s easy! Just like we did with the first graph!

  24. So now we highlight again? That’s right!

  25. And once again, insert “Column”

  26. Ta da!

  27. And once again, go to Chart Tools and choose Layout to add labels, etc.

  28. You try it on your own, then compare it to ours, okay? Don’t worry – we don’t mind waiting!

  29. How did you do?

  30. Now it’s time to make your graphs with your REAL data! Good luck! Have fun! See you next time!

  31. The End! It’s gonna be the end of ME if that owl finds me!

More Related