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" ¦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 ? |
All times are GMT +1. The time now is 02:34 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com