Charting Large Data Sets in Excel

BBA18's picture
Rank: Senior Gorilla | banana points 854

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?

Financial Modeling Course

  • Get An Edge For Your Interviews & Finance Career
  • The Best (and Most Affordable) Financial Modeling Self-study Courses.
  • WSO Members receive a 15% discount

Comments (2)

Jun 15, 2018

using excel for actual analysis = not smart in 2018. R & Python are how you do this.

Jun 16, 2018