60 sports in six charts
On twitter I follow many charting and visualization related accounts. One of them is @Andy Kriebel, who runs Makeover Monday. The idea is simple. Every Monday they publish a data-set and ask the community to visualize. Last Monday (7th May, 2018), they have published about toughest sport by skill data. This categorizes 60 sports by 10 skill categories to find out which sport is the toughest. Over the weekend, Andy posted a summary of all toughest sport viz entries. Many of the entries are made in Tableau. I thought it would be a fun challenge to re-create some of these charts in Excel. The result is this post. 60 sports in 6 charts. Check out the charts and download workbook to learn more.
First four charts are re-creations of Tableau designs. Last two are mine.
Employee Performance Panel Charts in Power BI with R
Yesterday we saw a beautiful example of panel charts with R. Today let me show you how to create the same (or even better) with Power BI & R. What you need: Power BI Desktop and R Raw data set – rem-data.csv Creating Panel Charts in Power BI with R Load CSV data in to […]
Employee Performance Panel Charts – Excel vs. R [video]
Recently, I had to make a bunch of panel charts. After wrangling with Excel (and a tiny bit of VBA) to create them, I wondered if we are suffering needlessly by being too loyal to Excel. I switched to R and could create these panel charts in almost no time (well, first I had to learn how to pivot the data using dplyr). Today, let me share the experience.
How to visualize multiple variables over several years? [Contest]
Our newest contest is inspired from a question asked by Kaushik, one of our forum members, interesting problem.
Need to quickly visualize 3 variables ( Company, years, Financials) in a single […] chart.
Create a chart to understand multiple variable data and you could win $100 Amazon gift card. Do send your charts before 4th of July to qualify for the prizes.
Excel Links – from USA edition
Hello there,
My travel to US was fantastic and fun. Many thanks to Jocelyn & Rob Collie, who found a nice apartment for us and made sure we are settled down in almost no time. Weather has been excellent so far too with lots of sunshine and blue skies. We went to a nearby park the other day and kids really loved walking on trials and exploring.
Gentle reminder
Today is last day to sign-up for my USA Masterclass
Today is last day to join my USA Advanced Excel & Dashboards masterclass with early bird discount. If you live near Chicago, Washington DC or Columbus and love Chandoo.org style of teaching, then you will benefit alot from my masterclass. We have very few spots left in Chicago & Columbus. So go ahead and book yours today and save $200.
How the tax burden has changed over the years – Excellent chart by NYTimes & Redoing it in Excel
If I need some charting inspiration, I always visit New York Times. Their interactive visualizations are some of the best you can find anywhere. Clear, beautifully crafted and powerful. Long time readers of Chandoo.org knew that I like to learn from visualizations in NY Times & redo them using Excel.
Today let me present you one such chart. This is based on an interactive visualization prepared by NY Times explaining how the tax burden has changed over years for various income groups.
Take a look at tax burden chart – Excel implementation
Read on to learn how to create this chart using Excel.
Excel Links – Going to Togo Edition
After a long time, I am writing one more Excel links post. First let me share a quick personal update.
I am invited to Lome, Togo to spend a day at Ecobank – CFO conference in 3rd week of September. I will be conducting a one day masterclass on Advanced Excel & Dashboard Reporting. I am excited about this trip as I have never been to any African country. I will post some pics and tell you how it went once I am done with the conference.
Moving on to Excel Links for today,