Small NGO in Nepal needs help creating chartsfrom this spreadsheet!

H

herojig

Version: 2008
Operating System: Mac OS X 10.5 (Leopard)
Processor: Intel

Hi all, a small animal NGO in Nepal has collected data from a survey and placed in this spreadsheet:
<http://www.extreme-nepal.com/forumboards/StrayDogs.xls>
I don't have a clue on how to make some meaningful charts and graphs from this. Can someone point me in the right direction? For example, column c contains city names, three different ones. How do I for example create a pie chart showing the distribution of those 3 cities? I think I just need one example and I can get going on the rest. I am only used to working with excel when there are numbers and not this type of raw data. Thanks so much!!!
jigs
 
C

Carl Witthoft

Version: 2008
Operating System: Mac OS X 10.5 (Leopard)
Processor: Intel

Hi all, a small animal NGO in Nepal has collected data from a survey and
placed in this spreadsheet:
<http://www.extreme-nepal.com/forumboards/StrayDogs.xls>
I don't have a clue on how to make some meaningful charts and graphs from
this. Can someone point me in the right direction? For example, column c
contains city names, three different ones. How do I for example create a pie
chart showing the distribution of those 3 cities? I think I just need one
example and I can get going on the rest. I am only used to working with excel
when there are numbers and not this type of raw data. Thanks so much!!!
jigs
Click to expand...

Create 3 cells w/ formulas like
=COUNTIF(C:C="Chicago")
=COUNTIF(C:C="Toronto")

etc. and make a pie chart of those values.

In general, it sounds like you need to identify what your chart
"categories" are going to be (cities, types of dogs, whatever) and then
organize your data accordingly.
 
H

herojig

Yes, thanks for that! I did figure this all out yesterday, but just turning everything into numbers, counting up things like yes/no's and other non-numeric data. then it was a cinch to create the graphs. thx again!
 
Top