Monitoring Monthly Service Levels using Excel Charts [Example]
Recently, I wrote a tutorial on tax burden in USA chart.
Jared, One of our readers liked this chart very much. Jared works as a workforce scheduler and has data similar to our chart. So he applied the same technique to analyze monthly service levels for last 7 years & sent me the file so that I can share it with all of you.
First take a look at the demo of Jared’s chart. And read on to know how this works.
Highlight best week & month in a trend chart [tutorials]
When analyzing business data like sales, shop visits or productivity, one of the questions managers always ask is,
What is the best month / week for this data?
To answer this question, we need to make a chart that looks like above. Today, lets learn how to highlight portions of such charts that correspond to best week or best month.
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.
Project Portfolio Dashboard in Excel [Part 2 of 2]
In this 2 part tutorial, we will learn how to design a project portfolio dashboard. Part 1 discussed user needs & design. Part 2 will show you Excel implementation.
Click here to get your copy.
Final Implementation – Project Portfolio Dashboard
First lets take a look at the finalized dashboard implementation. Continue reading to learn more & download this dashboard.
Happy Diwali [Animated Chart inside]
My heartiest Diwali wishes to all our readers.
The spirit of Diwali is to encourage people to spread joy, celebrate good things and throw away darkness (evil). These ideas are universal. So let me wish you a very happy Diwali.
Diwali, festival of lights, is celebrated in the month of October / November. It is one of my favorite festivals since childhood. A time when all family members get together, celebrate all the good in their life, laugh and light a few fire crackers (fire works).
This year, our kids (Nishanth & Nakshatra) too are excited about the festival. They are eager to light diyas (small lamps), watch the fire works and enjoy. Naturally I do not feel like opening Excel.
But then…,
Sometime during my morning coffee, I thought “hey, why not create a small Diwali greeting using Excel?”
So here we go.
Pie of a Pie of a Pie chart [Good or Bad?]
There are some charts that look so stunning and yet confusing. You cant make up your mind whether it tells a compelling story or it is just plain wrong.
Today, let me present you one such chart. I call this Pie of a Pie of a Pie chart.
Journey of Hurricane Sandy – Animated Excel Chart
Hurricane Sandy has taken front seat in all major news channels, papers, websites even in far off places like India. I hope & pray that our readers in US East coast are safe.
Today, lets understand the journey of Hurricane Sandy in this animated chart, prepared by Chris from Excel365.