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

0 votes
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 by Kithuzzz
• 38,020 points
2,315 views

1 answer to this question.

0 votes

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.

enter image description here

answered Oct 18, 2022 by narikkadan
• 63,680 points

Related Questions In Others

0 votes
1 answer

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

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

answered Feb 8, 2022 in Others by Soham
• 9,710 points
1,062 views
0 votes
1 answer

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

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

answered Nov 8, 2022 in Others by gaurav
• 23,260 points
666 views
0 votes
1 answer

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

answered Nov 25, 2022 in Others by narikkadan
• 63,680 points
1,080 views
0 votes
1 answer

How to create exponential growth in excel over a year

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

answered Dec 24, 2022 in Others by narikkadan
• 63,680 points
571 views
0 votes
1 answer

Excel Pie-Chart in categories

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

answered Oct 8, 2022 in Others by narikkadan
• 63,680 points
1,094 views
0 votes
0 answers

MS Excel - SumProduct formula with Loop

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

Feb 18, 2022 in Others by Edureka
• 13,690 points
407 views
0 votes
1 answer

How to Paste JPEG as a gif in excel?

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

answered Oct 2, 2022 in Others by narikkadan
• 63,680 points
686 views
0 votes
1 answer

Can I use VBA in Excel 2010 Starter Edition?

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

answered Oct 8, 2022 in Others by narikkadan
• 63,680 points
491 views
0 votes
1 answer

Using excel I need to open PPT and create ".gif" image of a ."pdf" and save it

It appears happier if you get a ...READ MORE

answered Dec 24, 2022 in Others by narikkadan
• 63,680 points
454 views
0 votes
1 answer

MS Excel showing the formula in a cell instead of the resulting value

Make sure that... There's an = sign before the formula There's ...READ MORE

answered Nov 8, 2022 in Others by narikkadan
• 63,680 points
786 views
webinar REGISTER FOR FREE WEBINAR X
REGISTER NOW
webinar_success Thank you for registering Join Edureka Meetup community for 100+ Free Webinars each month JOIN MEETUP GROUP