Add a heading to the column of numbers, then you could create a pivot
table to summarize the data, and create a pie chart from the pivot table
results.
There are instructions for pivot tables in Excel's Help, and Jon Peltier
has information and links:
http://peltiertech.com/Excel/Pivots/pivotstart.htm
In the pivot table, add the number field to the row area, and another
copy of the number field to the data area, as Count of number.
beachlife wrote:
how can I show a pie chart with % of same value entries in a column eg.
values of 1,1,1,1,1,2,2,2,3,3 I want a chart to show 50% are 1's, 30% are 2's
and 20% are 3's
--
Debra Dalgleish
Excel FAQ, Tips & Book List
http://www.contextures.com/tiptech.html