Getting a “No Data” Notice in Your Chart? Here’s how to fix that…
Thanks to those of you who brought up this question–we definitely did not post enough detail.
Google Spreadsheets won’t let you create a chart unless you have numerical data in your chart.
Let’s say that you asked the class members whether they want to go to Hawaii, and you gave them the option of selecting Yes or No. Your spreadsheet will have a column titled “Do you want to go to Hawaii?” with people’s Yes or No answers in the column. Though it seems like it would be easy just to highlight that column and create a chart with it, you can’t–you’ll get the dreaded “No Data” notice!
So, what DO you do in this case?
You have a few choices. Here they are, easiest to hardest!
- Go to the summary view
- Make note of the response counts for each response (i.e., 35 Yes, 25 No)
- Go back to your spreadsheet and create a new sheet (there is an Add Sheet link at the bottom)
- In the new sheet, create a table with your count data. (see below for an image)
- Highlight this table, and then go to Insert > Chart
Try the instructions here–it involves using formulas.
I suspect you can do something fancy with the Google Charts API or creating a Gadget–try it if you are very, very brave! Google Docs’ help section is pretty helpful if you want to go that route.