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.

Chart for wall hygrometric physic (or how to create a chart with custom x axis intervals?)

Chart for wall hygrometric physic (or how to create a chart with custom x axis intervals?)

Livio, one of our readers from Italy sent me this interesting problem in email.

I would like to prepare an xy linear graphic as representation of the variation of temperature trough a wall between two different bulk temperature i.e. outside and inside a house. This graphic should show the temperature gradient trough the wall thickness. The wall is normally made by different construction materials (different layers, as bricks, insulation, …..) and so the temperature change but not as a straight line with only one slope, instead as few lines with different slopes (see below figure) Calculations are not difficult, and also prepare the graphic also not difficult.

But, I am looking a beautiful solution for x-axis. X-axis should be divided not with constant interval, instead with different length between each sub-division exactly as the different thickness of the wall. This is a correct graphic, because you can show the correct slope of each straight line though each layer of the wall.

Continue »

Learn Top 10 Excel Features

Learn Top 10 Excel Features

Last week, we had a lovely poll on what are your favorite features of Excel? More than 120 people responded to it with various answers. So I did what any data analyst worth his salt would do,

I analyzed the data and here are the top 10 features in Excel according to you.

Read on to learn more.

Continue »

Some charts try to make you an April fool all the time (or why 3d pie charts are evil)

Some charts try to make you an April fool all the time (or why 3d pie charts are evil)

Recently I saw a big screaming ad that said “the chartbuster rules”. Of course, I know that chartbusters rule. Not just because I was one of them :)

So I got curious and read on. And I realized the ‘chartbuster’ is actually a car, not some cool, spreadsheet waving, goatee sporting dude like Jon Peltier. What a bummer!

And then to my horror of horrors, I saw the exploding 3d pie chart, with reflection effects & glossy colors. And the sole purpose of the chart is to create an impression that Verna sells better than any car in India.

Today, lets talk about this chart and alternatives for it. Read on.

Continue »

How to create interactive calendar to highlight events & appointments [Tutorial]

How to create interactive calendar to highlight events & appointments [Tutorial]

One of the popular uses of Excel is to maintain a list of events, appointments or other calendar related stuff. While Excel shines easily when you want to log this data, it has no quick way to visualize this information. But we can use little creativity, conditional formatting, few formulas & 3 lines of VBA code to create a slick, interactive calendar in Excel. Today, lets understand how to do this.

Continue »

What is your favorite feature of Excel? [poll]

What is your favorite feature of Excel? [poll]

Its Friday, time for another poll.

This weeks topic is inspired from a discussion Jordan started in our forums.

I will go first.

My favorite features are,

Conditional formatting: Quickly highlight something that is not alright (or meets conditions), see trends with data bars or heat maps.
Pivot tables: Turn data in to understandable information with just a few clicks. When combined with slicers & conditional formats, becomes very powerful.
Formulas: Ofcourse, with out formulas, Excel would be a glorified notepad!

What about you? What are your favorite features in Excel? Go ahead and share with us by posting a comment.

Continue »

How well do you know your LOOKUPs? – Quiz Answers & Discussion

How well do you know your LOOKUPs? – Quiz Answers & Discussion

Last week, we had our very first quiz – “How well do you know your LOOKUPs?”. I hope you have enjoyed it.

Today lets understand the answers & explanations for this quiz.

Continue »

10 things that wowed me in Excel 2013

10 things that wowed me in Excel 2013

As you may new, the newest version of Excel is out for a while. I have been using it since last 6 months and enjoying it. Today, lets understand 10 things in 2013 that wowed me (and probably you too).

Continue »