Charting Large Data Sets in Excel

Boss at my summer job wants a set of data on a group of 15 comps put into charts that are aesthetic/presentable. I'm starting to think that it's just not possible.

The issue is that the data is quarterly since 2000, there are 15 companies populating the chart, the majority of the comps are very similar so the visuals look clustered and the companies are indistinguishable from one another, and there are 2-3 comps that are outliers by a factor of 15-20 for any given metric in either way so they jump off the chart entirely at their apex.

Has anyone charted something like this without it looking like shit?

2 Comments
 

Molestiae sint fugit alias exercitationem ea. Fugit placeat quam libero non rerum. Ratione ut harum atque. Voluptas reiciendis iste temporibus. Corporis qui deleniti libero qui sed vitae qui nisi. Reprehenderit id est iure.

At iusto blanditiis voluptatibus inventore autem est architecto quo. Voluptas molestias ratione officiis molestiae veritatis. Ut est dicta nesciunt. In voluptatem velit amet ut culpa voluptatem fugit quo. Reprehenderit eligendi rem dolor magnam.

Eum provident earum sed. Sint perferendis et blanditiis vitae adipisci. Modi qui voluptas enim vel doloremque enim.

Ut dicta pariatur expedita quisquam. Ipsa dolores amet saepe similique assumenda inventore ut. Maxime nihil incidunt ex sunt quisquam rerum. At laudantium esse et.

Career Advancement Opportunities

June 2026 Investment Banking

  • Evercore 01 99.4%
  • Moelis & Company 01 98.9%
  • JPMorgan 01 98.3%
  • Guggenheim Partners 01 97.7%
  • Morgan Stanley 07 97.1%

Overall Employee Satisfaction

June 2026 Investment Banking

  • Moelis & Company No 99.4%
  • Morgan Stanley 02 98.8%
  • Evercore 01 98.3%
  • BMO Capital Markets 12 97.7%
  • Banco Santander 01 97.1%

Professional Growth Opportunities

June 2026 Investment Banking

  • Evercore 01 99.4%
  • Moelis & Company 01 98.9%
  • Morgan Stanley 05 98.3%
  • JPMorgan No 97.7%
  • Goldman Sachs 02 97.1%

Total Avg Compensation

June 2026 Investment Banking

  • Vice President (14) $434
  • Associates (44) $258
  • 3rd+ Year Analyst (8) $210
  • 2nd Year Analyst (22) $179
  • Intern/Summer Associate (13) $156
  • 1st Year Analyst (79) $150
  • Intern/Summer Analyst (73) $101
notes
16 IB Interviews Notes

“... there’s no excuse to not take advantage of the resources out there available to you. Best value for your $ are the...”

Leaderboard

1
redever's picture
redever
99.2
2
Secyh62's picture
Secyh62
99.0
3
BankonBanking's picture
BankonBanking
99.0
4
kanon's picture
kanon
99.0
5
DrApeman's picture
DrApeman
98.9
6
GameTheory's picture
GameTheory
98.9
7
dosk17's picture
dosk17
98.9
8
Betsy Massar's picture
Betsy Massar
98.9
9
CompBanker's picture
CompBanker
98.9
10
Jamoldo's picture
Jamoldo
98.8
success
From 10 rejections to 1 dream investment banking internship

“... I believe it was the single biggest reason why I ended up with an offer...”