All articles with 'charting' Tag
In the 13th session of Chandoo.org podcast, lets turn our attention to on-going FIFA worldcup and ask an important question.
What is in this session?
A week ago, we discussed “Has it been a late goal FIFA worldcup?” and used various charts & analysis techniques to answer the question. In podcast, lets tackle the same problem, understand various approaches to answer questions like these & shares some lessons for all the analysts.
I have a surprise for you. Between the late night world-cup matches & my reinvigorated thirst for biking, I have difficulty finding time to write a long & detailed article for you. So I thought why not say hello to you and share an Excel tip while I am on a biking trip.
Go ahead and check it out. Its just 4 minutes.
Watch it below or on our YouTube channel.Continue »
Just like millions of viewers around the world, I too have been spending hours watching FIFA world cup football matches on TV. I don’t like spending hours watching TV. But when its FIFA world-cup time (which is once every 4 years), I am glued to the idiot box. Blame it on PaWaRa, my school teacher in 8th grade who instilled this passion.
So while watching the match day before yesterday (it was Holland vs. Chile), the commentator said, “This has been a world-cup of late goals” as both teams maintained 0-0 until 77 minute mark when Leroy Fer scored a goal for Holland.
That got me thinking,
Is this really a world-cup of late goals?
But I quickly brushed away the thought to focus on the match.
Later yesterday, I went looking and downloaded all the goal data for 2006, 2010 & 2014 FIFA world-cup matches (2014 data for first 36 matches).
Lets examine the hypothesis “2014 has been a world-cup of late goals”.Continue »
Recently we asked you, what do you struggle doing in Excel? 170 people responded to this survey and shared their struggles. In this post, lets examine the top 10 struggles according to you and awesome remedies for them.Continue »
Here is an interesting scenario.
Imagine you are responsible for customer satisfaction at ACME Inc. Every month you track customer satisfaction rate for the 3 products you sell which are conveniently named Product A, B & C.
You also have bands for the satisfaction rating.
- Rating of 85% or below is Average
- Rating between 85% & 95% is OK
- Rating above 95% is good
At the end of the year, you want to visualize the ratings for last 12 months for 3 products along with bands.
Something like above.
Unfortunately, there is no “Insert Banded line chart” button in Excel. So what to do?
That is what we will learn today. Ready?Continue »
In the 4th session of Chandoo.org podcast, lets talk about Pie charts.
Pie charts evoke strong opinions among analysts & managers. Some people love them and can’t have enough of them in reports. Others despise them and go to any lengths to avoid them. And that is why we are going to talk about them in this session.
You will learn,
- Special, secret transmission from guest stars
- What is a pie chart?
- Why they work? 2 reasons
- Why they don’t work ? 4 reasons
- Cousins & siblings of Pie charts
- Donut charts
- Gauge charts (speedometer)
- 3D pies
- Area charts
- Bubble charts
- 4 Situations when making a pie chart is ok
- Alternatives to Pie charts
- Mistakes you should avoid
- About the resources
Back when I was working as a project lead, everyday my project manager would ask me the same question.
“Chandoo, whats the progress?”
He was so punctual about it, even on days when our coffee machine wasn’t working.
As you can see, tracking progress is an obsession we all have. At this very moment, if you pay close attention, you can hear mouse clicks of thousands of analysts and managers all over the world making project progress charts.
So today, lets talk about best charts to show % progress against a goal.Continue »
Outside of a dog, a book is a man’s best friend. Inside of a dog it’s too dark to read. -Groucho Marx
We don’t have a dog (yet), but we have a lot of books. Anytime I am in a bookshop, I feel like a mosquito in fat-camp. So you can imagine me smacking my lips when I saw your suggestions for favorite Excel books recently. There were more than 50 different books recommended by our readers. Of course I cannot buy all the 50 in one go. That would make Jo (my wife) angry. So I bought one that most of you recommended.
It is a book about array formulas, advanced formulas and data analysis techniques. I am eagerly waiting for the delivery to devour it. Once I am done with it, I will post a review here.
What about you? What Excel book are you reading now? Please share in comments.Continue »
Today lets take a stroll outside what Excel can do and make something fancy, fun and may be useful.
Nowadays, many newspapers, websites and magazines are featuring info-graphics. An info-graphic is a collection of shiny, colorful & data-full charts (or often pieces of text.) In many of these info-graphics, you can see threaded-donut charts. Not sure what that is..? It is not same as the blasphemy of spoiling a soft, sweet, supple donut with a piece of string. No one should be excused for an offense like that.
What I am talking about is shown aboveContinue »
Few days ago, we learned how to create a pie+donut combination chart to visualize polls around the world in 2014. It generated quite a bit of interesting discussion (47 comments so far). One of the comments was from Roberto, who along with Kris & Gábor runs The FrankensTeam an online library of advanced Excel tricks, charts and other mind-boggling spreadsheet wizardry.
I really liked Roberto’s comments on the original post and a charting solution he presented. So I asked him if he can do a guest post explaining the technique to our audience. He obliged and here we go.
Over to FrankensTeam.Continue »
Today lets have a poll. Lets debate if this pie chart about world elections in 2014 is good or bad.
First lets take a look at the chart
This chart, published by The Economist talks about how 42% of the world population is going to vote this year. Take a look and read on to learn how you can re-create this in Excel.Continue »
Bar & Column charts are very useful for comparison. Here is a little trick that can enhance them even more.
Lets say you are looking at sales of various products in a column chart. And you want to know how sales of a given product compare with a lower bound (last year sales) and an upper bound (competition benchmark). By adding these boundary markers, your chart instantly becomes even more meaningful.
Lets learn how to create a column chart with lower & upper bounds in this tutorial.Continue »
For every column chart that is done right, there are a dozen that get messed up. That is why lets talk about 5 simple rules for making awesome column charts.
Tip: Same rules apply for bar charts too.Continue »
You have been there before.
Trying to compare last year numbers with this year, or last quarter with this quarter.
Today, let us learn how to create an interactive to chart to understand then vs. now.
Demo of Then vs. Now interactive chart
First, take a look the completed chart below. This is what you will be creating.Continue »
Finally my Excel classes in USA are over. It was a lot of fun traveling to new cities, teaching Excel & dashboards to enthusiastic crowds and making new friends. As if that is not fun enough, we (Jo, kids & I) are going on a 2,000 mile, 2 week road trip starting today.
Although I am enjoying all this, I also feel bad for not taking enough time to share new tricks, ideas & techniques with you here. So, I have a wacky, wild & awesome plan for you. Join us on our road trip.
That is right. You can join me on our road trip and see what I see, learn some pretty cool Excel tricks, all while sipping coffee and stretching legs in the comfort of your office cubicle.Continue »