Calculate frequencies and draw pie chart

  • Thread starter Thread starter burkina
  • Start date Start date
B

burkina

Hi,

I need to do what seems really a stupid thing, but I can't find an easy
way to do it with Excel.

Suppose to have a column like this:

A
B
B
A
C
A
A

The letters can be changed with anythin else, like numbers, whole
words, etc.
What I need is a chart pie with the frequencies of each letters.
So, the frequencies are A=4, B=2, C=1 and the pie should automatically
represent them with the right percentages.

It seems that you can't do that in excel with 'a single click'.
Is it true?
How should I do that?
If it's not so easy, can you suggest me other software?

Thanks,

Stefano
 
Hi

can't offer a "single click" solution - but it seems to work
1) click in your data range
2) choose data / pivot table and pivot chart report, accept all defaults
3) you should end up with one item on the field list, drag this item to both
the "rows" and "data" areas
4) on the pivot table toolbar, click on the chart icon - change the chart
type to pie & under chart options, display the % data labels.
 
Thank you!
It was the same solution I found after a while of trafficking on the
Excel options. It seems to work reasonably. However, I'm really amazed
at finding out that you can only export the produced plot within the
Office suite and not, say, as a jpg. I hope I'm wrong in this...

Stefano
 
Hi

you could always copy & paste it into Paint or some other drawing program
and save it as a jpg from there.
 
Thank you!
However, I'm still amazed there's not a default 'Export' option in
Excel...

Stefano
 
You're welcome. You can send suggestions to:

(e-mail address removed)

Put "Excel" in the subject line, so your suggestion will be forwarded to
the Excel product managers.
 
Back
Top