PDA

View Full Version : Maths students or anyone else that has a clue

~Unity~
31-12-07, 09:12 PM
I need to make a pie chart on the computer. But one problem, I don't know how. I don't even know where to find it on the computer :smack:

Help!

JazakAllahu Khair
Joha
31-12-07, 09:19 PM
I need to make a pie chart on the computer. But one problem, I don't know how. I don't even know where to find it on the computer :smack:

Help!

JazakAllahu Khair

Do you have Excel? Get your data - go to Tools - Add Chart or something like that...you'll get an option to make a pie chart somewhere in there.

Hope that helps until somebody can give you exact directions...
~Unity~
31-12-07, 09:40 PM
Do you have Excel?

Thats a good question.....lemme see.....
~Unity~
31-12-07, 09:43 PM
Yep have it :D But "Add Chart" isn't under Tools and I can't seem to find it anywhere :o
Hayaa'
31-12-07, 09:44 PM
Thats a good question.....lemme see.....

Lol^^ I was going to say try excel aswell. It's the same as doing a graph but jus select pie chart!:up:
~Unity~
31-12-07, 09:52 PM
:salams:

Okay I found the Charts Section :hidban:

But how on earth do I convert my data into pie chart form? Where do I write my data :o I know its basic, but I don't understand computers!
Joha
31-12-07, 09:52 PM
Yep have it :D But "Add Chart" isn't under Tools and I can't seem to find it anywhere :o

hmm, just hit help and type in pie chart - it'll give you all the details.

I'd help a little more but I removed Excel (and the rest of Office) from my computer...trying to kick the habit :rolleyes:
Joha
31-12-07, 09:53 PM
:salams:

Okay I found the Charts Section :hidban:

But how on earth do I convert my data into pie chart form? Where do I write my data :o I know its basic, but I don't understand computers!

the data goes in the spreadsheet - in the cells that you see when you open a new worksheet in Excel.
~Unity~
31-12-07, 10:02 PM
Okay I did a survey asking people many questions. When I do an example pie chart to test it out, not all the questions appear in the chart :scratch:...Only a pie chart for the first question!
~Unity~
31-12-07, 10:14 PM
Anyone.......:( (I'll give you some cookies)
Saudi Prince
31-12-07, 10:24 PM
Anyone.......:( (I'll give you some cookies)

what's the data? :)
Hayaa'
31-12-07, 10:25 PM
Sorry sis i havn't used that in time.I just remember where it was :o

inshaAllah someone should be able to help....
~Unity~
31-12-07, 10:34 PM
Sorry sis i havn't used that in time.I just remember where it was :o

inshaAllah someone should be able to help....

No problemo sis :)

what's the data? :)

My data consists of loads of questions and answers. But I just figured it out, I'm gonna need a pie chart per question right? :smack:
Saudi Prince
31-12-07, 10:38 PM
My data consists of loads of questions and answers. But I just figured it out, I'm gonna need a pie chart per question right? :smack:


How is it useful to have a pie chart for questions and answers?! If they are yes or no questions then you can draw a chart for the 'questions' and the 'answers' which is yes or no!
~Unity~
31-12-07, 10:47 PM
How is it useful to have a pie chart for questions and answers?! If they are yes or no questions then you can draw a chart for the 'questions' and the 'answers' which is yes or no!

They are not 'yes' or 'no' questions. They are a series of questions to do with native languages and all the possible options for answers more or less differ to the previous one. It is an eyesore to look at all these results in words. Furthermore, it is also an eyesore to look at many pie charts or bar graphs. But I'm thinking logically now :rolleyes: its kinda impossible to merge them together right? Someone please say wrong!

All I really need to know is that is it possible: pie chart, bar graph or any other way, to have loads of questions in it - if the answer options are the same, represented in one chart/graph? Does that make any sense? Cos I'm writing the questions out on excel, but they are not present in the chart...pppphhhhooooo
Saudi Prince
31-12-07, 11:08 PM
They are not 'yes' or 'no' questions. They are a series of questions to do with native languages and all the possible options for answers more or less differ to the previous one. It is an eyesore to look at all these results in words. Furthermore, it is also an eyesore to look at many pie charts or bar graphs. But I'm thinking logically now :rolleyes: its kinda impossible to merge them together right? Someone please say wrong!

All I really need to know is that is it possible: pie chart, bar graph or any other way, to have loads of questions in it - if the answer options are the same, represented in one chart/graph? Does that make any sense? Cos I'm writing the questions out on excel, but they are not present in the chart...pppphhhhooooo

Can you give examples of 2 questions and their answerS.
~Unity~
31-12-07, 11:11 PM
How far would you agree that English is the language of the oppressor?

Strongly agree, Fairly agree, Neither agree nor disagree, Fairly disagree, Strongly disagree

How far would you agree that the English language is able to unite Kenyans despite tribal differences?

Strongly agree, Fairly agree, Neither agree nor disagree, Fairly disagree, Strongly disagree, Don’t know

Those are the options to the answers. So I've got the answer in a percentage form.
Mace
31-12-07, 11:37 PM
How far would you agree that English is the language of the oppressor?

Strongly agree, Fairly agree, Neither agree nor disagree, Fairly disagree, Strongly disagree

How far would you agree that the English language is able to unite Kenyans despite tribal differences?

Strongly agree, Fairly agree, Neither agree nor disagree, Fairly disagree, Strongly disagree, Don’t know

I'd say you were on the right track with one pie per question.

Stacked bars might work also, but would be confusing I think since the options weren't exactly the same for each question.
Saudi Prince
31-12-07, 11:46 PM
How far would you agree that English is the language of the oppressor?

Strongly agree, Fairly agree, Neither agree nor disagree, Fairly disagree, Strongly disagree

How far would you agree that the English language is able to unite Kenyans despite tribal differences?

Strongly agree, Fairly agree, Neither agree nor disagree, Fairly disagree, Strongly disagree, Don’t know

Those are the options to the answers. So I've got the answer in a percentage form.


How about this? I tried to draw a chart for the 2 questions. Try to download the file, please.


http://www.uploading.com/files/PJT5HF8A/unity.bmp.html
~Unity~
01-01-08, 12:40 AM
Hey thanks for that Saudi Prince. But that still means I'm going to have to make those bar graphs for each question and I have about 14 and I don't think my lecturer would want to see so many. So I've just figured a way of doing it in a table. It doesn't look professional at all but it should do.

Thank-you for taking the time out to do it though, plus I now know how to do one of those. JazakAllahu Khair :up:
Saudi Prince
01-01-08, 01:04 AM
Hey thanks for that Saudi Prince. But that still means I'm going to have to make those bar graphs for each question and I have about 14 and I don't think my lecturer would want to see so many. So I've just figured a way of doing it in a table. It doesn't look professional at all but it should do.

Thank-you for taking the time out to do it though, plus I now know how to do one of those. JazakAllahu Khair :up:


I have tried to put the 14 questions in 1 chart only. If the chart is cleae enough for you then you can change the data to 'your actual data' and then it will change in the graph automatically.


http://www.uploading.com/files/DB6XUCRE/unity.xls.html
~Unity~
01-01-08, 01:13 AM
Oh yeah that would work! Thanks for your time and efforts! Really appreciate it!! LOL @ Saudi is good!