# 126|EXCEL – Visualizing Volume
**URL:** https://www.techhub.training/t/126-excel-visualizing-volume/683
**Category:** Challenges
**Tags:** stocks, graphs, excel, beginner, financial
**Created:** [May 25, 2023, 2:36am UTC](https://www.techhub.training/t/126-excel-visualizing-volume/683 "2023-05-25T02:36:48Z")
**Posts on this page:** 5
**Page:** 1
### Author:  [@Donovon](https://www.techhub.training/u/Donovon)
#### Post date: [May 25, 2023, 2:36am UTC](https://www.techhub.training/t/126-excel-visualizing-volume/683/1 "2023-05-25T02:36:48Z")
_BYU Student Author_: @Donovon
_Reviewers_: @Alex_Garrett @MitchFrei @Hyrum
_Estimated Time to Solve:_ 15 Minutes
We provide the solution to this challenge using:
- Excel
- [Go here to perform this challenge in Tableau](https://www.techhub.training/t/126-tableau-visualizing-volume/682)
- [Go here to perform this challenge in Power BI](https://www.techhub.training/t/126-powerbi-visualizing-volume/2155)
Need a program? Click [here](https://www.techhub.training/t/information-about-software-used-on-techhub-training/138).
**Overview**
You have just started an internship as a stockbroker at your dream company. The pressure is on to learn quickly and provide value so you can secure a full-time offer at the end of the summer. You’ve just finished orientation and your new manager has asked you to spend the rest of the day getting familiar with some of the tools you’ll be using over the next couple of months. She told you that she’d be impressed if you could create a chart in Excel showing the companies with the highest total trading volume in 2016. She says you can format this chart however you’d like as long as it’s easy to understand. As one final note, your manager mentions that using a tree map might be appropriate for the dataset.
Make sure you take time to understand the format of the data before you attempt to create the chart. Read the instructions carefully and you’ll be sure to make an impression!
**Instructions**
1. Download the data and open it in Excel.
2. Create a new table that has each ticker name and the sum of its volume only in the year 2016. It may be helpful to use a PivotTable in this process.
3. Create a tree map chart using the data in this new table.
4. Don’t forget to name your chart!
**Data Files**
- [Challenge126\_Data.csv](https://byu.box.com/shared/static/3ey8wnro9uwji76fg8scmv7v4o5c1c3q)
- [Challenge126\_Data\_Dictionary.docx](https://byu.box.com/shared/static/hrdn7a662j1ape8m7kj3dyyr66i54fkr)
**Solution**
[Challenge126\_Solution.xlsx](https://byu.box.com/shared/static/061pn96gn34jr7cnxrc6vi3uam5sjec0)
_Solution Video:_ [Challenge 126|EXCEL – Visualizing Volume](https://youtu.be/YuvsojaU7Ec)
---
### Author:  [@Andrew\_Malone](https://www.techhub.training/u/Andrew_Malone)
#### Post date: [April 10, 2024, 3:20am UTC](https://www.techhub.training/t/126-excel-visualizing-volume/683/2 "2024-04-10T03:20:31Z")
Loved this challenge! Here is my solution! It took me about 20 minutes to do, but partly due to the sheer amount of data slowing down excel. Great challenge!
---
### Author:  [@Hannah\_Jordan](https://www.techhub.training/u/Hannah_Jordan)
#### Post date: [June 30, 2024, 2:34am UTC](https://www.techhub.training/t/126-excel-visualizing-volume/683/3 "2024-06-30T02:34:41Z")
[Challenge126\_Data.csv](https://www.techhub.training/uploads/short-url/hdu8ivpEmIOnRTPCOaCxsbN6jbp.csv) (15.1 KB)
I enjoyed this challenge! It took me about 15-20 minutes to complete.
---
### Author:  [@Ryan\_Deng](https://www.techhub.training/u/Ryan_Deng)
#### Post date: [March 12, 2025, 5:13pm UTC](https://www.techhub.training/t/126-excel-visualizing-volume/683/4 "2025-03-12T17:13:50Z")
Finished this challenge in about 30 minutes!
---
### Author:  [@Cate\_Ducote](https://www.techhub.training/u/Cate_Ducote)
#### Post date: [March 13, 2025, 5:42pm UTC](https://www.techhub.training/t/126-excel-visualizing-volume/683/5 "2025-03-13T17:42:06Z")
Time: 20 mins
Level: Beginner
My file was too big so a picture will have to do!