I have got a problem that I don't if excel could help me to calculate the %
within a column and draw a pie chart.

My case is I have a column containing a series of numbers. e.g.
1,4,8,1,3,9,11,2,4,5,6,.........etc

I want to draw a pie chart that showing 1-3 , 4-6, 7-9, 9 with the
corresponding % inside that column.

Can anyone tell me how can I make it ?

Ray -

You need to calculate the frequencies in your data.

Let's assume your data is in A1:A12. In B1:B3 enter these numbers, the
upper limits on the groupings:

3
6
9

You can enter "9" into B4 without messing up any formulas below.

Select C1:C4, with C1 as the active cell. Type this formula:

=FREQUENCY(A1:A12,B1:B3)

then hold down CTRL+SHIFT while pressing ENTER. If done properly, Excel
inserts curly braces around the formula:

{=FREQUENCY(A1:A12,B1:B3)}

Here's how my sample data appears:

1 3 6
4 6 3
3 9 2
5 9 1
6
2
3
9
8
2
11
2

Select B1:C4 and make a pie chart. Apply data labels, using the category
name and percentage options. The entries in column B are the category
names, and Excel computes the percentages for you.

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Peltier Technical Services
Tutorials and Custom Solutions
http://PeltierTech.com/
_______


Ray in HK wrote:

I have got a problem that I don't if excel could help me to calculate the %
within a column and draw a pie chart.

My case is I have a column containing a series of numbers. e.g.
1,4,8,1,3,9,11,2,4,5,6,.........etc

I want to draw a pie chart that showing 1-3 , 4-6, 7-9, 9 with the
corresponding % inside that column.

Can anyone tell me how can I make it ?

Done !

"Jon Peltier" ¦b¶l¥ó
¤¤¼¶¼g...
Ray -

You need to calculate the frequencies in your data.

Let's assume your data is in A1:A12. In B1:B3 enter these numbers, the
upper limits on the groupings:

3
6
9

You can enter "9" into B4 without messing up any formulas below.

Select C1:C4, with C1 as the active cell. Type this formula:

=FREQUENCY(A1:A12,B1:B3)

then hold down CTRL+SHIFT while pressing ENTER. If done properly, Excel
inserts curly braces around the formula:

{=FREQUENCY(A1:A12,B1:B3)}

Here's how my sample data appears:

1 3 6
4 6 3
3 9 2
5 9 1
6
2
3
9
8
2
11
2

Select B1:C4 and make a pie chart. Apply data labels, using the category
name and percentage options. The entries in column B are the category
names, and Excel computes the percentages for you.

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Peltier Technical Services
Tutorials and Custom Solutions
http://PeltierTech.com/
_______


Ray in HK wrote:

I have got a problem that I don't if excel could help me to calculate
the %
within a column and draw a pie chart.

My case is I have a column containing a series of numbers. e.g.
1,4,8,1,3,9,11,2,4,5,6,.........etc

I want to draw a pie chart that showing 1-3 , 4-6, 7-9, 9 with the
corresponding % inside that column.

Can anyone tell me how can I make it ?