Download to read offline
More Related Content
Similar to Creating graphs in excel
Creating graphs in excel
- 1. In this video,you will learn to • Gather data from surveymonkey.com • Create a graph in Microsoft Excel • Paste your graph into Microsoft Word Feel free to pause, rewind, or rewatch this video.
- 2. I’ve created mysurvey and am still on the “Design Survey” tab.
- 3. In order toallow people to take my survey, I click on the button “Collect Response.” Then, I choose “Web Link” and copy the link that pops up. This is the link I will share with my peers on the discussion board.
- 4. Once I’ve collectedresponses from my audience (my peers), I can look at the results by clicking on the “Analyze Results” tab. Then, I get a really cool graph, but unfortunately, I can’t copy and paste it. So I’ll have to make my own.
- 5. When I scroll downthe page, I get the number of responses for each choice. Even though I am offered a percentile, I am going to use the actual number of responses instead.
- 6. Now, I opena new document in Excel and enter my data. Do NOT include blank cells in your data because it will mess up your graph when you make it. Just cram everything together like I have. It doesn’t have to look pretty.
- 7. Highlight your data.Do not highlight any empty cells. Then, click on the “Charts” tab. Finally, choose the kind of graph you want to make.
- 8. I have chosena column chart, more specifically the “Clustered Column” chart.
- 9. Now I havea nice little graph! But it needs improvements. Warning: You have to click on your chart in order to modify it. If you click outside the chart, you will lose the option to modify it. Just click back on it again.
- 10. First I wantto get rid of the legend on the side since it is not conveying any useful information. So I just click on it and press either “Delete” or “Backspace” on my keyboard.
- 11. I also wantto modify my title since it has the word “Number” in it for some reason. I just click on the title and make changes.
- 12. I also wantto give more information about what my data means, so I want to add a title to the horizontal axis and the vertical axis. I click on the “Chart Layout” tab and then on the “Axis Titles” tab.
- 13. Now I cangive my graph a horizontal title… …and a vertical title.
- 14. This is whatmy graph looks like now. But I’m not quite finished.
- 15. I want toplace the value above each line of the bar chart, so I’m going to go back to the “Chart Layout” tab, click on “Data Labels,” and choose “Value” (not shown).
- 16. Now I havea gorgeous chart to put in my paper!
- 17. Adding my chartto my paper is very easy. I just click on the chart and then copy it.
- 18. Then, I opena new Word document and paste it in.
- 19. Underneath, be sureto give your graph a title.
- 20. To make yourgraph easier to move around, click on the graph itself. Then, choose the “Format” tab that pops up, “Wrap Text,” and “Top and Bottom” (not shown).
- 21. That’s the endof this tutorial. I hope you found it helpful.