Thread: creating a percentage chart based on values

Hi,

I'm trying to create a pie chart showing a percentage breakdown based upon a set of values that includes repeating values.

For example, for the list:

1
1
1
1
2
2
3
4

I'd like a pie chart that shows the pentage breakdown of the four unique values, not represent each line as it's own slice.

I'm not sure how to do this in Excel without manually calculating the percentages based. Any suggestions woul dbe much appreciated.

Create it as a pivot chart, it will group and count the values and put them right into a chart.