All articles with 'charting' Tag

5 simple rules for making awesome column charts

Published on Aug 29, 2013 in Charts and Graphs
5 simple rules for making awesome column charts

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 »

How to create a Then vs. Now interactive chart in Excel?

Published on Aug 6, 2013 in Charts and Graphs
How to create a Then vs. Now interactive chart in Excel?

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 »

Are you ready for 2,000 miles, 15 days & 10 Excel tips road trip?

Published on Jun 24, 2013 in Charts and Graphs, personal
Are you ready for 2,000 miles, 15 days & 10 Excel tips road trip?

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 »

How to create a column chart with background image in Excel ?

Published on May 6, 2013 in Charts and Graphs, Excel Howtos
How to create a column chart with background image in Excel ?

Tony sends this chart and asks if it can be done in Excel.

It sounded like a good challenge for a lazy Sunday morning. So here we go. (Posting it on Monday).

Now I could not get an oil rig photo or that data. So I made up few numbers and used a photo of Flinders street station I took when I was in Melbourne last year.

Continue »

How to create an Interactive Chart in Excel? [Tutorial]

Published on Apr 23, 2013 in Charts and Graphs, Excel Howtos
How to create an Interactive Chart in Excel? [Tutorial]

Imagine you have a worksheet with lots of charts. And you want to make it look awesome & clean.

Solution?

Simple, create an interactive chart so that your users can pick one of many charts and see them.

Today let us understand how to create an interactive chart using Excel.

Continue »

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

Published on Apr 18, 2013 in Charts and Graphs
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

Published on Apr 16, 2013 in Charts and Graphs, Learn Excel, Power Pivot, VBA Macros
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)

Published on Apr 12, 2013 in Charts and Graphs
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 »

10 things that wowed me in Excel 2013

Published on Apr 3, 2013 in Charts and Graphs, Learn Excel
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 »

There is an Easter egg in this chart!

Published on Mar 27, 2013 in Charts and Graphs
There is an Easter egg in this chart!

Do not worry, you are not time traveling or seeing things. Its just that, this year I have decided to publish our Easter Egg a few days early.

And oh, I have 3 reasons for it:

  1. 2 of my favorite festivals – Easter & Holi (a festival of colors, celebrated in India) are this week. Holi is today (Wednesday) & Easter on Sunday.
  2. My kids are super excited about Holi as this is the first time they will be playing it. So we have family time from today until Wednesday and I do not feel like writing a blog entry on Friday :)
  3. I like to have 3 reasons for everything.

Hence the Easter Egg is advanced a few days. But it is just as fun (or may be better) as previous Easter eggs.

Continue »

Use Advances vs. Declines chart to understand change in values

Published on Feb 21, 2013 in Charts and Graphs
Use Advances vs. Declines chart to understand change in values

Lets say you are responsible for sales of 100s of products (which belong to handful of categories). You are looking at sales of each product in last month & this month. And you want to understand whether sales are improving or declining by category. How would you do it?

Turns out, this is not a difficult problem. In fact, this question is asked every day & answered using Advances vs. Declines chart.

You may have seen this chart in financial newspapers or websites. Shown above, Advances vs. Declines chart tells us how many items have advanced & how many have declined.

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

Continue »

Shading above or below a line in Excel charts [tutorial]

Published on Feb 13, 2013 in Charts and Graphs
Shading above or below a line in Excel charts [tutorial]

When comparing 2 sets of data, one question we always ask is,

  • How is first set of numbers different from second set?

A classic example of this is, lets say you are comparing productivity figures of your company with industry averages. Merely seeing both your series as lines (or columns etc.) is not going to tell you the full story. But if we can shade our productivity line in red or green when it is under or above industry average… now that would be awesome! Something like above.

Continue »

Monitoring Monthly Service Levels using Excel Charts [Example]

Published on Dec 20, 2012 in Charts and Graphs
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 »

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

Published on Dec 12, 2012 in Charts and Graphs
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 »

How the tax burden has changed over the years – Excellent chart by NYTimes & Redoing it in Excel

Published on Dec 6, 2012 in Charts and Graphs

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 »