How to create pie chart with %

  • Thread starter Thread starter Ray in HK
  • Start date Start date
R

Ray in HK

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/
_______
 
Back
Top