Create a pie chart of ages showing under 30 s 30-50 s and over 50 s

Question

I have a 2010 Excel document with a ton of customer information. I know how old the clients are. These values are floats. A pie chart that displays the proportions of clients under 30, between 30 and 50, and above 50 is what I'm after.

2,000 or more rows are present. I choose the column, choose Inset, then select Pie Chart. A disco ball-colored chart with the digits 1 through 9 appears; Excel then crashes. I understand that; at that point, there are too many ages to include in a pie chart.

I choose the column, choose Inset, then select Pie Chart. A disco ball-colored chart with the digits 1 through 9 appears; Excel then crashes. I understand that; at that point, there are too many ages to include in a pie chart.

In order to give me the values "Under 30," "Over 30 and under 50," and "Over 50," I've tried adding a column with nested if statements. Given that this column has only 3 distinct values, I reasoned that I could use it to make a pie chart. I was hoping for the proportion of each age group. But all I get is a blank pie and a legend value of 1. Any help is greatly appreciated.

Answer 1

Two things:

• A pie chart does not aggregate data automatically. You need to do the aggregation and feed the aggregated data to the pie chart
• A pie chart needs numbers, not text. Well, any chart does.

So, to aggregate, you can use Countif or Countifs. For example, in the screenshot below the three numbers are calculated this way:

under 30    =COUNTIFS(A:A,"<30")
30 to 50    =COUNTIFS(A:A,">=30",A:A,"<50")
over 50     =COUNTIFS(A:A,">=50")

Then select the data as in the screenshot and insert a pie chart.

Add data labels and change the data label to show percentages if you want.