Hi,

If you want to do charts there are many possiblities -
- You could plot a radar chart but this might be confusing to the audience,
I can send you a sample if you want.
- You can plot an XY-Scatter or Line chart showing Mean and +/- 1 or more
Standard Deviations - I can send you a sample.

If you just want to show data, then you can present the scores and mean and
+/- 1 or more standard deviations. You can also present the Percentile or
PercentRank for each score.

The functions to consider would be =AVERAGE(range), =STDEVP(range),
=PERCENTRANK(range,k), PERCENTILE(range,k)
Remember Standard Deviation is statistically meaningful when you reach a
population size of about 30.

As for charts, you might look at Jon Poltier's web site to see a lot of
samples and see if any strike your fancy.

http://peltiertech.com/Excel/Charts/
--
Thanks,
Shane Devenshire


"Alexandra Lopes" wrote:

Hi,

I want to group the collaborators in 3 groups (Good, average and bad),
in accordance with its score and to represent them graphically, in
charts. And also show the place of each within the score in one column.
I'm having a meeting of senior staff to decide who stays and who goes.


Thanks in advance.


ShaneDevenshire wrote:
Hi,

What do you mean "distribute" - what do you want to do - a chart, and what
do you want to show - place of each within the total collection?

Are you making a presentation, giving a talk, sending out report cards,
sending out pink slips, having a meeting of senior staff to decide who stays
and who goes, or presenting to all the staff to encourage better performance?