View Single Post
  #1   Report Post  
Ray in HK
 
Posts: n/a
Default 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 ?