Make a simple Pie Chart and Bar Graph in Excel 2013

Description: This article describes how to create a simple pie chart in Excel 2013. (Same can be done for a Bar Graph, etc. just by clicking Bar Chart).

  1. To create a simple pie chart in Excel 2013, there first must be some data available to chart. In the example below, there is weekly data for sales.

  1. Highlight the data that you want in the chart. Then select Insert from the Ribbon and select the Recommended Charts button. This will bring up the recommended charts for your data. In this case we are selecting the third icon for Pie Charts and select OK.
  2. The Design tab will now be listed above. You can use these tools to change the look and feel of your Chart.
  3. Add Chart Element allows you to change the chart title, legend or data labels.
  4. Quick Layouts are different preset charts.
  5. Change Colors allows you to change the colors in your chart.

(Source:

  1. The shortcut to adding or changing information to your chart is clicking the ‘Plus Sign”


  1. Once you are finished with designing your graph, you want to place it into a Word document. SimplyRight Click on the graph, and select Copy. Then go to your Word document and Right Click where you want to place it and select Paste.
  1. Now, if your Word document moves around and goes crazy, that is ok. We just need to fix the picture.Left click the picture. Then select Format from the Ribbon, select the Wrap Test button and pick Top and Bottom. (You can pick any of them but they do different things. Play around with the different types and see what is best for you.)


Instructions for Submitting Electronic Assignments

Assignments should be typed in a Word document (or anything my computer allows me to open) and emailed to my school emailaddress, which can be found on the school website or . Students must follow the guidelinesin order for the assignment to be graded, so double check before submitting. =)

  1. Inside your document, at the top left corner, it should include your name, assignment and date.
  2. Example: For this assignment, I would type the following:

T. Craig Smith

Classroom Pets

1/17/14

  1. When you go to Save your document, the file name must include the following: <LastNameFirstName<Assignment>
  2. Example: For this assignment I would Save it as SmithCraigClassroomPets.doc
  1. When you go to submit an email, please put your name and the assignment as the Subject of the email. This lets me know who emailed me, not #.
  2. Example: For this assignment I would type T. Craig Smith – Classroom Pets
  1. Last and most important, in the body of the email be professional. Don’t leave your email blank or type “Here is my assignment.” or “What b the next assignment 2morrow Prof?” Always start by saying “Hi Mr. Smith,” or “Hello Mr. Smith,” and NEVER use “Text Messaging” talk. Just looks better and your professors will happy. ;)

The following assignment is to be typed in a Word document (or anything my computer allows me to open) and emailed to my school email address, which can be found on the school website or . I will not accept any hardcopies.Review instructions above or on my website before submitting the assignment.

Assignment 1: Classroom Pets (Due: 1/29/14)

In grade school, did your teacher have a pet in the classroom? Many teachers do so in order to promote humane education. The Journal of Moral Education (Mar. 2010) published a study designed to examine elementary school teachers’ experiences with humane education and animals in the classroom. Based on a survey of 75 elementary school teachers, the following results were reported:

Survey Question / Response / Number of Teachers
Q1: Do you keep classroom pets? / Yes / 61
No / 14
Q2: Do you allow visits by pets? / Yes / 35
No / 40
Q3: What formal humane education program does your school employ? / Character Counts / 21
Roots of empathy / 9
Teacher Designed / 3
Other / 14
None / 28
  1. Explain why the data collected is qualitative.
  2. For each survey question, summarize the results with a graph. (There should be 3 graphs. I want at least one pie chart and one bar graph.)
  3. For this sample of 75 teacher, write two or three sentences describing their experience with humane education and classroom pets.