LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
burkina
 
Posts: n/a
Default 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

 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On



All times are GMT +1. The time now is 12:47 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"