Google Sheets and Forms Create Graphs

 DIRECTION 

 Open Google Chrome then Log in to your Google account Click Apps then Drive

Find the sheet labeled with (responses) and open it

If you didn't do a survey form you can type in your data instead

 The responses sheet has all the data from every survey that was submitted. However you only need some of the information for each graph and the information is not always in a graph able format. So we must change the format of the data using formulas.

 We will start by graphing the favorite question in my case it is favorite color

We will move to the right of all the data it doesn't  matter where just make sure it is to the right of the responses

We need to type headers in this case I type:

You may need to move this to a different column if you had lots of different results in your survey

 Type in all the color choices below "Favorite Color" in column M 

the colors must be typed exactly as they are in your form or it won't work. In other-words if you capitalized it in your form you must us caps in this as well. 

The best way to do this is to copy paste to avoid errors

 Now we will use a formula called =countif which will count the responses of each color choice

Click on cell N4 and type in =countif(

next highlight all the cells from b2 to b150

b2 being the beginning color choice b150 being the last possible number for the responses. So if you gave out 200 surveys you would need this number to be b200

hint if you are unsure how many responses you will get use b:b this will use any data that is in the B column

Now type a comma then "Blue" make sure you place quotes around your choice name

Notice that the responses are now added for the "Blue" choice

 Use fill handle to copy the formula to the other choices

Hoover your mouse over the bottom right corner of cell N4 then click and drag to the last answer choice in column N

 Edit formulas to count the correct color

Now we edit each formula by changing the color in the quotes to match the favorite column 

For example the formula for Red located at N5 

 Make chart from Data

Now that our data is in a usable format we can create a chart or graph in the case of favorite colors we will make a Pie graph

Highlight all the data including the headers and answer choices

 Click on the insert Chart icon 

• "Number of Pets" in column M 

• "Responses" in column N

For the responses you must use words rather than numbers or the chart will not work correctly 

You may need to move this to a different column if you had lots of different results in your survey

Type in your number range in column M as well

 Now we will us the same COUNTIF formula to count if the number of pets is equal to the number

The formula for 0 pets should be =COUNTIF(C:C,"0")

 Use the Fill Handle and copy the formulas to the other responses then change the response to match the number

So for 1 pet the formula would be

=COUNTIF(C:C,"1")

And so on for the rest

 Now highlight the formatted data Click on the insert Chart icon 

Then Click on Column Chart

 Click Customize 

Change chart title to match your question in my case How many Pets do you Have

Changes the Horizontal Axis to Pets you Have

 Click Insert when you are done you now have a chart on your responses sheet

Move chart to own sheet click on the option button in the top right corner and select Move to own Sheet Your chart will now be on its own sheet

You can switch back to responses by clicking on the response tab in button left corner

 The rating chart is next we have to manipulate the data into a usable form so we can create a graph

We need to type headers in this case I type:

 Calculate Average Rating this is done by taking the average of all those who were surveyed

This is done by clicking on the Average Rating Math Cell and typing in =AVERAGE(D:D)

Remember you can type the formula in the formula bar of in the cell they both work

  Use the Fill Handle and copy the formulas to the other responses then change the row to match the responses

For example row E contains the rating for Science class so that formula would be  =AVERAGE(E:E)

Unfortunately Google sheets does not have an auto-fill formula so you have to manually change the column reference

 Now highlight the formatted data Click on the insert Chart icon 

Then Click on Bar Chart

 Click Customize 

Change chart title to match your question in my case "Favorite Class"

Changes the Horizontal Axis to "Average Rating"

 Click Insert when you are done you now have a chart on your responses sheet

Move chart to own sheet click on the option button in the top right corner and select Move to own Sheet Your chart will now be on its own sheet

You can switch back to responses by clicking on the response tab in button left corner

 Change Tab names to the chart names

double click on the tab at the bottom of the sheet and rename all your charts

 Publish Charts 

Now you can publish your charts to lots of different places.

Click the Publish chart button in the top right corner

 Publish Options

You can publish your chart as an image or interactive

Interactive means the chart will change as new responses are entered

 Once you make your selection press the blue Publish button

You can share the link to Facebook, twitter google+ or gmail as a link

or you can embed the code a website

 Share 

You can also share the chart with anyone

by emailing them a link 

If you Click Advanced you can make the chart view-able on the Internet