BYU Student Author: @Donovon
Reviewers: @Parker_Sherwood, @Klayton, @IWillyerd
Estimated Time to Solve: 15 Minutes
We provide the solution to this challenge using:
Need a program? Click here.
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
- Download the spreadsheet, which contains information for each of the billionaires on Forbes’ list.
- Take a few minutes to study the Forbes Billionaire sheet to see the information available to you.
- 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.
- 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.
- 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.
- 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