Thread: How to create pie chart with %

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" <jonREMOVExlmvp@peltierCAPStech.com> ¦b¶l¥ó
news:%23F%23ivmigFHA.3316@TK2MSFTNGP14.phx.gbl ¤¤¼¶¼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 ?
> >
> >