How to create a pie chart with 793 numbers? Possible?

  • Thread starter Thread starter excelnovice123
  • Start date Start date
E

excelnovice123

Hi, I've been trying to create a pie chart with 793 numbers on one single
colum, the column consists of various numbers and i would like to take a
percentage of numbers on the column, for example there are 100 tens ranging
from cell A1 to A99 and 500 1's ranging from cell A100 to A699 and other
numbers, is it possilbe to create a pie chart with that many numbers?
-- Every time i tried to create the pie chart using the chart wizard, the
finished chart will always shown with so many different slices, any tips on
how to create the pie chart would be greatly appreciated thanks in advance.
Mike
 
Do you want to group the numbers or what do you want to do?
If you want to group the numbers then it would be handy to use a pivot
table,
in the layout put the header first in the row and then in the data fields,
then doubler click the header in the data field and select count. then makem
a chart out of that

--
--

Regards,


Peo Sjoblom
 
Back
Top