how do I set up a pie chart to show % of same value entries

[beachlife]

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]

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.