# All articles with 'charting principles' Tag

## Start your bar charts from zero – Excel geeks screaming at you from mountain top

Published on May 15, 2017 in Charts and Graphs

Here is a simple but vital charting rule.

Start your bar (or column) charts from zero.

To illustrate why you should do this, let me share a personal example.

Over the weekend, the Jon Peltier visited Wellington. He is staying with Jeff (who occasionally guest blogs on Chandoo.org). On Sunday, we all decided to hike up a small mountain near my house for a leisurely family picnic.

While on the top of the mountain, Jo (my wife) took a few pics of us three Excel geeks.  As we were standing on a sloping mountain face this is how the pictures look.

Looking at the picture on left, you would confidently say that I am way shorter than other two. But picture on right tells a different story.

Continue »

## Correlation vs. Causation [Charting Chatter]

Published on Aug 3, 2016 in Charts and Graphs

Here is a trap that is easy to fall in to. Confusing correlation as causation. As analysts, it is our job to see the data as it is rather than imply causation that doesn’t exist.

Let’s sample a chart, recently featured in Economist’s graphic detail under the title Measuring well-being.

Continue »

## Don’t make your charts heavier than they should be – The weight of the world chart [case study]

Published on Jan 13, 2016 in Charts and Graphs

Here is an interesting chart from Economist, ironically titled The weight of the worldCan you tell what is wrong with it?

Continue »

## CP049: Don’t do data dumps!!!

Published on Nov 19, 2015 in Chandoo.org Podcast Sessions, Charts and Graphs

In the 49th session of Chandoo.org podcast, let’s talk about data dumps!

### What is in this session?

In this podcast,

• What is a data dump
• Examples of data dump
• Why we dump
• Ways to avoid data dumps
• Go for information dumps
• Sort the dump
• Filter the dump
• Give a table
• Resources for you
Continue »

## How countries spend their money – chart alternatives

Published on Sep 22, 2015 in Charts and Graphs

Econimist’s daily chart is a one of my daily data porn stops. They take interesting data sets and visualize in compelling ways. While the daily chart page is insightful, sometimes they make poor charting choices. For example, this recent chart visualizing how countries spend their money uses a variation of notorious bubble chart. Click on the chart to enlarge.

What is wrong with this chart?

Bubble charts force us to measure and compare areas of circles. Unless you have a measuring tape somehow embedded in your eyes and you are a walking human scientific calculator, you would find this task impossible.

So when you look at the chart and want to find out what percentage Japanese spend on restaurants or how much Americans pay for housing, your guesses will have large error margins.

Not only bubble charts are difficult to read, they are very hard to align. So when you have a bunch of bubbles, no matter how hard you try, your chart looks clumsy (see how the Russian food bubble eats in to Mexico’s bubble, as if it is too hungry 😉 )

Let’s check out a few alternatives to this chart. Read on…

Continue »

## Cropped chart: when some values are too big to fit

Published on Sep 9, 2015 in Charts and Graphs

We know that column charts are excellent for presenting information. But what if some of the columns are too tall and hijacking the rest. In a previous article, we discussed few of the approaches. Today let’s learn how to build a cropped chart (broken y-axis chart) using Excel, something like above.

Continue »

## Give descriptive titles to your charts for best results

Published on Aug 19, 2015 in Charts and Graphs

Here is a simple & effective tip on charting.

Give your charts descriptive & bold titles.

### How to set up title that are smart & descriptive?

1. Create the title you want in a cell
2. Select the chart title
3. Go to formula bar, press = and point to the cell with title
4. Press enter.
Continue »

## Make bar charts in original order of data for improved readability [charting tip]

Published on Aug 10, 2015 in Charts and Graphs

To make friends in a new town hit the bars – Old saying.
To make sense of a new data-set, make bar charts – New saying.

Bar charts (or column charts if you like your data straight up) are vital in data analysis. They are easy to make. But one problem. By default, a bar chart show the original data in reverse order.

See the above example.

Unfortunately, we humans read from top to bottom, not the other way around.

Continue »

## Use shapes to enhance your Excel charts [tip]

Published on Aug 8, 2015 in Charts and Graphs

Here is a simple way to enhance your Excel charts – use shapes & pictures in your charts.

We will learn how to create something like above.

Continue »

## CP041: 6 charts you’ll see in hell – v2.0

Published on Aug 6, 2015 in Chandoo.org Podcast Sessions, Charts and Graphs

In the 41st session of Chandoo.org podcast, Let’s take a trip to data hell and meet 6 ugly, clumsy, confusing charts. I am revisiting a classic Chandoo.org article – 6 Charts you will see in hell.

### What is in this session?

In this podcast,

• Quick announcement about Awesome August
• 6 charts you should avoid
• 3D charts
• Pie / donut charts with too many slices
• Too much data
• Over formatting
• Complex charts
• Charts that don’t tell a story
• Conclusions
Continue »

## Shading an area chart with different colors for up & down movements [case study]

Published on Jul 29, 2015 in Charts and Graphs

We all know that area charts are great for understanding how a list of values have changed over time. Today, let’s learn how to create an area chart that shows different colors for upward & downward movements.

The inspiration for this came from a recent chart published in Wall Street Journal about Chinese stock markets.

We will try to create a similar chart using Excel. We are going to create the above chart in Excel.

Continue »

## CP038: Data to Ink Ratio – What is it, How to optimize it, Techniques & Discussion

Published on Jul 9, 2015 in Chandoo.org Podcast Sessions, Charts and Graphs

In the 38th session of Chandoo.org podcast, Let’s optimize data to ink ratio of your charts.

What is in this session?

In this podcast,

• Announcements
• What is Data to Ink Ratio?
• Obvious ways to optimize Data to Ink Ratio
• More ways to optimize Data to Ink ratio
• Highlighting what is important
• Conclusions
Continue »

## Changing stubborn opinions with visualizations [case study]

Published on May 29, 2015 in Charts and Graphs

We, analysts take pride in the fact that we tell stories. But what if you have a boss, client or colleague who wouldn’t buy the story?

This is a problem we face often. Let’s say your boss has stubborn opinion about something, like more advertising leads to more sales. You know the data doesn’t support this theory. But how do you change your boss’ mind?

Here is an interesting way, showcased in NY Times recently.

Continue »

## CP032: Rules for making legendary column charts

Published on Apr 2, 2015 in Chandoo.org Podcast Sessions, Charts and Graphs

In the 32nd session of Chandoo.org podcast, let’s make legendary column charts.

### What is in this session?

Column charts are everywhere. As analysts, we are expected to create flawless, strikingly beautiful & insightful column charts all the time. Do you know the simple rules that can help you create legendary column charts?

That is our topic for this podcast session.

In this podcast, you will learn

• Few personal announcements
• Rule 0: Start at zero
• Rule 1: Sort the chart
• Rule 2: Slap a title on it
• Rule 3: Axis + grid-lines vs. Lables
• Rule 4: Moderate formatting
• Conclusions
Continue »

## CP029: Impress your boss with Excel charts – 6 step road map for you

Published on Feb 5, 2015 in Chandoo.org Podcast Sessions, Charts and Graphs

In the 29th session of Chandoo.org podcast, let’s impress the boss with Excel charts.

### What is in this session?

Many Excel charts live a short life. They spawn in an ambitious analyst’s spreadsheet. They go to boss with literally flying colors. The boss frowns, they disappear in to recycle bin.

Don’t curse your Excel charts with short life span.

That is our topic for this podcast session.

In this podcast, you will learn

• Quick announcements about 50 ways & Einstein
• 6 step road map for charting success