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?
using excel for actual analysis = not smart in 2018. R & Python are how you do this.
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.
See All Comments - 100% Free
WSO depends on everyone being able to pitch in when they know something. Unlock with your email and get bonus: 6 financial modeling lessons free ($199 value)
or Unlock with your social account...