# 43|EXCEL – Billionaire Chart Chase

BYU Student Author: @Donovon
Reviewers: @Parker_Sherwood, @Klayton, @IWillyerd
Estimated Time to Solve: 15 Minutes

We provide the solution to this challenge using:

Overview
You’ve always dreamed of becoming a billionaire. You’ve read countless books and articles about the habits and traits of successful people, but you’re still struggling to find your way to the top of the top. That’s where this week’s challenge comes in. By analyzing Forbes’ list of billionaires, you’ll gain valuable insights into what it takes to become a billionaire. You’ll learn about the age at which billionaires tend to achieve their success, the countries that are home to the most billionaires, and the industries that produce the most billionaires. Armed with this knowledge, you’ll be better equipped to chart your own path to success.

You recently overheard some classmates talking about PivotCharts in Excel and figured this might be a good way to visual your findings. Make use of them as you follow the instructions to this challenge. Good luck with the exercise, and don’t forget to have fun!

Instructions

2. Take a few minutes to study the Forbes Billionaire sheet to see the information available to you.
3. Open the Age Ranges sheet. Use the pre-configured PivotChart to create a bar chart showing the number of billionaires by age. Create groupings for each five-year range.
4. Open the Wealthiest Nations sheet. Use the given PivotChart to create a bar chart showing the sum of net worth by country. Filter the data to only show the top ten countries and sort it to have the largest on the left. Add data labels to the top of each bar.
5. Open the Percent Industries sheet. Use the PivotChart to create a pie chart showing the sum of net worth associated with each industry. Add data labels for each slice and format them as percentages of the whole. Also add industry labels to each slice.
6. Open the First Letter sheet. On this one you can let your creativity shine! Add a new column to the Forbes Billionaires sheet that contains only the first letter of the associated name. Create a new PivotChart and use this new field to design a compelling visualization showing the most fortuitous first letter. Do you need to change your name?

Data Files

Suggestions and Hints

You don’t need to create calculated fields for any of the pivot tables/charts.
For question 3: There is a built-in grouping function if you right-click on the pivot table (not the pivot chart).
For question 4: By using filters on the pivot table, you can filter to the Top 10.
For question 5: You can change the chart type by going to Design->Type on the ribbon.

Solution

CanyonEsplin_Billionare_Chart.xlsx (368.7 KB)

3 Likes

Challenge43_Billionaire_Chart_Chase.xlsx (360.2 KB)

Here is my completed Excel task for 9/18/2023.
-Nick Mangum

4 Likes
3 Likes
3 Likes

Challenge43_Billionaire_Chart_Chase.xlsx (348.2 KB)

1 Like

Challenge43_Billionaire_Chart_Chase.xlsx (352.0 KB)

Learned a ton! Great challenge.

2 Likes
2 Likes

Challenge43_Billionaire_Chart_Chase.xlsx (338.9 KB)

1 Like

Challenge43_Billionaire_Chart_Chase (1).xlsx (360.2 KB)
I looked at the list of billionaires for too long haha. Thanks for collecting and publishing this data and these challenges Donovon!

1 Like

Challenge43_Billionaire_Chart_Chase.xlsx (371.2 KB)

2 Likes

Challenge43_Billionaire_Chart_Chase.xlsx (386.5 KB)

1 Like
1 Like
2 Likes

Challenge43_Billionaire_Chart_Chase.xlsx (339.5 KB)

1 Like

Challenge43_Billionaire_Chart_Chase.xlsx (349.7 KB)
Thanks for the challenge!

1 Like

Here is my solution!

1 Like

Challenge43_Billionaire_Chart_Chase.xlsx (281.8 KB)

1 Like

ChartChase_9-15-2023.xlsx (337.7 KB)
This challenge was a good reminder on all the options you have with pivot tables. Check out my results!

2 Likes

Challenge43_Billionaire_Chart_Chase.xlsx (349.3 KB)
Billionaire Chart Chase for Emily Russell

1 Like