Calculate frequencies and draw pie chart
 

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.

--
Cheers
JulieD
check out www.hcts.net.au/tipsandtricks.htm
....well i'm working on it anyway
"burkina" wrote in message
oups.com...
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

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.

--
Cheers
JulieD
check out www.hcts.net.au/tipsandtricks.htm
....well i'm working on it anyway
"burkina" wrote in message
ups.com...
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

Andy Pope has a free add-in that you can use to export images:

http://www.andypope.info/vba/gex.htm

burkina wrote:
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...


--
Debra Dalgleish
Excel FAQ, Tips & Book List
http://www.contextures.com/tiptech.html

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:



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

burkina wrote:
Thank you!
However, I'm still amazed there's not a default 'Export' option in
Excel...

Stefano



--
Debra Dalgleish
Excel FAQ, Tips & Book List
http://www.contextures.com/tiptech.html