Welcome to Chandoo.org. New here?

Thank you so much for visiting us & taking first step to become awesome in Excel. Please use below links to navigate our site.

Monitoring Monthly Service Levels using Excel Charts [Example]

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.

Continue »

Show hide list boxes using VBA

Show hide list boxes using VBA

Rama, one of our readers emailed this:
I Have Many List boxes In That I need to Hide Few Of them Using Check box

Show Hide list boxes by using a check box

We can use check box and a bit of VBA to do this easily. Something like above demo.

Read on to learn how to do this using Excel & VBA.

Continue »

Can you find that pattern? [Homework]

Can you find that pattern? [Homework]

Are you ready for an Excel challenge?

Today, your job is very simple. Just find a pattern in a text and return corresponding value.

Your Homework:

In a range we have some resource types & their billing rates.

In another range, we have some descriptions. Each description contains a resource type somewhere inside it. We need to retrieve billing rate for each description by looking up which resource type is mentioned in it.

See above diagram.

Continue »

Highlight best week & month in a trend chart [tutorials]

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.

Continue »

Dressing Financial Statements – What Motivated Mr. Bean to Defraud Latte?

Did you know What Happened at Last Coffee Day?
Mr. Bean “dressed up” the financial statements and was caught in the fraud. But he was the CEO of Latte! So why did he commit fraud in his own company??

Any Guess?

Take a cappuccino and I will give you a hint – How was Mr. Bean’s Bonus to be decided?

Read on to know more…

Continue »

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
Tax burden over years chart - recreated in Excel

Read on to learn how to create this chart using Excel.

Continue »

Formula Forensics No. 032 – Creating Dynamic Charts with Non-Contiguous Data

Formula Forensics No. 032 – Creating Dynamic Charts with Non-Contiguous Data

There are many web pages devoted to Excel Charts and there are many web pages devoted to Creating Dynamic Ranges, but a lot of these suffer when the data is poorly organised or non-contiguous.

Today we look at a Technique for Creating Dynamic Charts with Non-Contiguous Data.

Continue »