Column Data into a Pie Chart?
 

I've got an Excel sheet composed of column data. I want to put a pie chart on another
sheet that represents the percentage of data, so that if the column is:

Apples
Apples
Oranges
Pears

I'll get a pie chart that shows me 50% Apples, 25% Oranges, 25% Pears.

How do I do this???

Thanks,

Bill.

Column Data into a Pie Chart?
 

Hi Bill. I've had to do something similar and have cludged a method together
that works, but takes several steps. Hopefully, one of the guru's will have
a better suggestion that I could learn from.

Assuming your data is in column A, in A1 type a label such as Fruit and then
sort to get them all together. Next use Data-Subtotal, using the Count
function. This will give you the number of each type.

Next copy the table, open a new worksheet, select A1 and Edit-paste
special-values . In an adjacent helper column labeled Count, say in column
C, type this formula and copy down to the end of the data, not including the
grand total: =IF(right(A2,5)="Count","C",""). This puts a C in each row
where there is a total for each type of fruit. Finally, sort the table on
column C, descending, and this will bring all the totals to the top. Delete
all the individual fruit rows and do your pie chart on the remainder. On the
data labels table in the pie chart wizard select Series Name and Percentage.

If you don't want to see the word Count in your pie chart then go to Edit -
Replace and replace Count with nothing.

HTH
Sincerely, Michael Colvin


"Bill" wrote:

I've got an Excel sheet composed of column data. I want to put a pie chart on another
sheet that represents the percentage of data, so that if the column is:

Apples
Apples
Oranges
Pears

I'll get a pie chart that shows me 50% Apples, 25% Oranges, 25% Pears.

How do I do this???

Thanks,

Bill.

Column Data into a Pie Chart?
 

Thanks, Michael!!! This worked for me!!!



"Michael" wrote in message
...
Hi Bill. I've had to do something similar and have cludged a method together
that works, but takes several steps. Hopefully, one of the guru's will have
a better suggestion that I could learn from.

Assuming your data is in column A, in A1 type a label such as Fruit and then
sort to get them all together. Next use Data-Subtotal, using the Count
function. This will give you the number of each type.

Next copy the table, open a new worksheet, select A1 and Edit-paste
special-values . In an adjacent helper column labeled Count, say in column
C, type this formula and copy down to the end of the data, not including the
grand total: =IF(right(A2,5)="Count","C",""). This puts a C in each row
where there is a total for each type of fruit. Finally, sort the table on
column C, descending, and this will bring all the totals to the top. Delete
all the individual fruit rows and do your pie chart on the remainder. On the
data labels table in the pie chart wizard select Series Name and Percentage.

If you don't want to see the word Count in your pie chart then go to Edit -
Replace and replace Count with nothing.

HTH
Sincerely, Michael Colvin


"Bill" wrote:

I've got an Excel sheet composed of column data. I want to put a pie chart on
another
sheet that represents the percentage of data, so that if the column is:

Apples
Apples
Oranges
Pears

I'll get a pie chart that shows me 50% Apples, 25% Oranges, 25% Pears.

How do I do this???

Thanks,

Bill.

Column Data into a Pie Chart?
 

Your welcome, Bill. I'm glad it helped. Merry Christmas
--
Sincerely, Michael Colvin


"Bill" wrote:

Thanks, Michael!!! This worked for me!!!



"Michael" wrote in message
...
Hi Bill. I've had to do something similar and have cludged a method together
that works, but takes several steps. Hopefully, one of the guru's will have
a better suggestion that I could learn from.

Assuming your data is in column A, in A1 type a label such as Fruit and then
sort to get them all together. Next use Data-Subtotal, using the Count
function. This will give you the number of each type.

Next copy the table, open a new worksheet, select A1 and Edit-paste
special-values . In an adjacent helper column labeled Count, say in column
C, type this formula and copy down to the end of the data, not including the
grand total: =IF(right(A2,5)="Count","C",""). This puts a C in each row
where there is a total for each type of fruit. Finally, sort the table on
column C, descending, and this will bring all the totals to the top. Delete
all the individual fruit rows and do your pie chart on the remainder. On the
data labels table in the pie chart wizard select Series Name and Percentage.

If you don't want to see the word Count in your pie chart then go to Edit -
Replace and replace Count with nothing.

HTH
Sincerely, Michael Colvin


"Bill" wrote:

I've got an Excel sheet composed of column data. I want to put a pie chart on
another
sheet that represents the percentage of data, so that if the column is:

Apples
Apples
Oranges
Pears

I'll get a pie chart that shows me 50% Apples, 25% Oranges, 25% Pears.

How do I do this???

Thanks,

Bill.