Hi i have an excel hw and i cant understand how to do it although its easy! anyone can help?

Question

owlfred · Answer

Hoot! You just asked your first question! Hang tight while I find people to answer it for you. You can thank people who give you good answers by clicking the 'Good Answer' button on the right!

amistre64 · Answer

excel is pretty much putting the right data into the right cell

amistre64 · Answer

prettify it my merging cells using title fonts and such

anonymous · Answer

yes right but how can i convert a number to percent in order to appear
 in the pie chart?

amistre64 · Answer

can you attach file in here?  seeing it would be better than guessing at it :)

amistre64 · Answer

attachment

anonymous · Answer

attachment

anonymous · Answer

its on the third sheet. i got confused for the pie chart

amistre64 · Answer

if you simply click inside of the pie chart, youcan edit the data if its just for presentation

anonymous · Answer

also for the line graphs. i think th
ey look wrong

anonymous · Answer

do u mean i write 19% for excellent instead of 32 which is written in the pie chart

amistre64 · Answer

yes

amistre64 · Answer

attachment

anonymous · Answer

oh but where did these numbers in the pie chart come frm?its really weird

amistre64 · Answer

lol.... i cant say fer sure.

amistre64 · Answer

it says countif(school,"excellent")/100

amistre64 · Answer

but that isnt a percentage is it; that only works if there are 100 schools

anonymous · Answer

uh uts worng then?

amistre64 · Answer

#excellent
--------- = percent
 #schools

anonymous · Answer

so it must be without the /100

amistre64 · Answer

to get an accurate percentage I would say yes;

% = part/total  x100

anonymous · Answer

but without it, these numbers appear
 1900%
3800%
300%

amistre64 · Answer

i got 19%,38%, and 3% that appear

amistre64 · Answer

well; 32,63,5

amistre64 · Answer

there are 19 out of the 60 posted that are excellent

amistre64 · Answer

19/60 = .317 = 32%

anonymous · Answer

so it would be 32%?

anonymous · Answer

uh im so confused

amistre64 · Answer

yes; 32% of the schools listed are excellent

anonymous · Answer

and what about the other percentages?

amistre64 · Answer

attachment

amistre64 · Answer

you need to divide them by the total number of schools; which is '60'   NOT '100'

anonymous · Answer

i see

anonymous · Answer

wow you really have helped me. im really grateful for you

amistre64 · Answer

:)  good luck with it

anonymous · Answer

thank you very much :)