Pie Chart using percentages

Hi,

first you'll have to prepare the data for the chart. Excel charts don't summarize data, you will have to do that first. So, create a table like the three lines in your example, and calculate the occurrences of each account with a SUMIF function

=SUMIF(A1:A7000,"Account A")

Make sure you enter the correct account name in the formula. Do this for each account type.

Now you have three numbers, which you can graph as a pie chart. You can format the pie chart to show the percentage labels - double click the pie chart, click the Data Labels tab and click Percentage.

Of course, you can use Excel to calculate the percentage of the numbers, too. For this, you need to calculate the sum of your three account values and then divide each account sum by this total, formatted as percent.


HTH