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

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!
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top