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.
Oct 17, 2022 in Others 1,232 views

## 1 answer to this question.

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. • 63,220 points

## How to take a screenshot of a current Activity and then share it?

For me, I captured and then shared ...READ MORE

## Calculate the number of days between a cell and today in excel?

Use the DATEDIF function when you want ...READ MORE

## In a excel formula I need to create a list of names on one sheet based upon criteria/data of another sheet

The final formula is: =IF(ROWS(\$H\$3:H3)<=\$I\$1,INDEX(Personnel! ...READ MORE

## How to create exponential growth in excel over a year

To find an interest rate that will ...READ MORE

## Excel Pie-Chart in categories

create a pivot pie chart. You can manually ...READ MORE

## MS Excel - SumProduct formula with Loop

1 I have 4 arrays of data where ...READ MORE

## How to Paste JPEG as a gif in excel?

Solution  Step 1 Navigate to the folder that contains ...READ MORE

## Can I use VBA in Excel 2010 Starter Edition?

No, unfortunately you can't use VBA in ...READ MORE