# All articles with 'charting principles' Tag

## Simple KPI Dashboard using Excel

Any Tom, Dick and Sally can make things complex. It takes guts and clarity to simplify things. That is why I was pleasantly surprised to see this dashboard prepared by Michigan State. You can see it in the detailed article.

Linda, one of My Excel School students shared this dashboard link with me and asked if I can show how to construct something like this. Here is my version of the dashboard.

Read this post to learn how to construct a similar dashboard on your own. Also, you can download the excel workbook and play with it.

Continue »

## Place Key Information in Golden Triangle on your Reports, Dashboards etc. [Quick Tips]

Published on Apr 29, 2011 in Charts and Graphs

Today, we will take a detour to world-wide web and learn how we can improve our dashboards, reports, presentations or workbooks by using one of the ideas, called as Golden Triangle.

Continue »

## Show Details On-demand in Excel [Tutorial + Training Program]

Published on Apr 7, 2011 in Charts and Graphs, products, VBA Macros

Yesterday, we have seen a beautiful example of how showing details (like distribution) on-demand can increase the effectiveness of your reports. Today, we will learn how to do the same in Excel.

Continue »

## Give more details by showing average and distribution [Charting Tips]

Published on Apr 6, 2011 in Charts and Graphs

When we have lots of data, we try to summarize it by calculating the average. As they say, averages are mean, they do not give away much.

I want to share with you an interesting example from Amazon.com on how they give more details by combining average with distribution.

As you might know, Amazon shows the rating of each of the products they sell. Customers & users rate the products from 1 to 5 stars. When you visit the product page you will see the average rating. But there is a small down-arrow next to it. When you click on it, Amazon shows you the break-up of that rating so you have a better idea of how the ratings are split.

Continue »

## Health-care Dashboard in Excel [Dashboard Week]

Published on Mar 22, 2011 in Charts and Graphs

As part of Dashboard Week, in this post, we will take a look at Health-care Dashboard prepared and shared by Alberto. He put together an excellent dashboard to visualize hospital performance and understand what is going on. Read this post to understand how this dashboard is made, watch a tutorial video & download example workbook.

Thank you Alberto for sharing the file & helping us learn.

Continue »

## Use Analytical Charts to Make your Boss Love You

Published on Mar 16, 2011 in Charts and Graphs

There are beautiful, powerful & awesome charting examples all around us. Today, I want to show you how we can harness the power of Excel to create Analytical Charts.

### Analytical What?!?

To be frank, I do not know what to call these charts, so I choose the term Analytical Charts. But this is what I have in mind when I say Analytical charts:

A chart is analytical chart,
(1) If it is interactive
(2) It it can answer different questions by re-structuring same data differently

Continue »

## The Grammy Bump Chart in Excel

Published on Feb 22, 2011 in Charts and Graphs

The folks at Washington Post made an interesting chart to understand whether winning a Grammy award makes any difference to album sales. Go ahead and browse it if you have not already seen it. Go, I will wait.

Are you impressed?

I really liked this chart. This is what I liked about the chart,

• It tells a story.
• It is an ego chart. We would all instantly search for our favorite artists and learn about how Grammy award changed their album sales.
• It is a simple chart. No clutter, no gaudy colors, just a bunch of lines and the story is out there.
• It lets you play.

In fact, I liked the chart so much that I wanted to make it in Excel.. You can see a snapshot of what I came up with above. Read the rest of this article to learn more.

Continue »

## How would you Visualize World Education Ranking Data [Homework + Video]

Published on Dec 20, 2010 in Charts and Graphs

Here is a charting challenge to begin your Christmas week. Recently Guardian’s Data Blog released World Education Rankings data and a sample visualization. Now your challenge is to make your chart visualizing World Education Rankings data.

You can see the chart I have constructed above. Read the rest of the post to find out how I made this chart and download the workbook.

Continue »

## Do you use (or make) Excel Dashboards? Tell us about yourself to win a free training kit

Published on Dec 16, 2010 in Charts and Graphs

(You can win my latest Excel Dashboard Training kit free, read this post to find out how.)

Over at Jorge’s ExcelCharts blog, he started a very good discussion on Excel Dashboards: Who needs them anyway?.

Jorge has very good experience designing, working on and teaching about dashboards. So he uses all that skill to gaze in to a crystal ball, to understand who needs excel dashboards and why. In this post, I build on his argument and ask you the big question – “If you make or use Excel Dashboards, who are you?”

Continue »

## Show Top 10 Values in Dashboards using Pivot Tables

Published on Dec 1, 2010 in Charts and Graphs, Pivot Tables & Charts

A good dashboard must show important information at a glance and provide option to drill down for details.

Showing Top 10 (or bottom 10) lists in a dashboard is a good way to achieve this (see aside). Today we will learn an interesting technique to do this in Excel.

Continue »

## Show Months & Years in Charts without Cluttering

Published on Nov 17, 2010 in Charts and Graphs

We make charts with date axis all the time. So, today we will learn how to set up axis settings in Excel so that Months & Years are shown neatly structured without cluttering your chart. See the example next to understand.

Continue »

## Analyze Competition with Scatter Plots – A business chart example

Published on Oct 25, 2010 in Charts and Graphs

Analyzing competition is one of the key aspects of running a business. In this article, learn how to use Excel’s scatter plots to understand competition, like shown aside.

The inspiration for this comes from a recent article on Asymco analyzing mobile handset market (Apple iPhone, Nokia etc.) and how it has changed since 2007.

Read the rest of the post to learn how to create this type of chart in excel. Also, you can download the chart template. Go ahead.

Continue »

## August 2010 – Best Month Ever (and 2 charting tips inside)

Published on Sep 3, 2010 in blogging, Charts and Graphs

Time to stop everything we do and celebrate, for, our little community at chandoo.org had the most fantastic, awesome month ever.

That is right. August 2010 has been the best month since I started chandoo.org. We have broken a majority of previous records in terms of conversations, connections, content and revenues.

In August, we had 17 posts, with 604 comments. We had 178,000 visitors reading 453,000 pages. Our RSS subscriber base grew to 11,917 (it was 5738 an year ago). August has been the best month in-terms of revenues too. We sold highest number of project management templates & excel formula e-books since launch. We had a stellar launch for wedding planner with 22 customers.

Read rest of this post to find statistics about chandoo.org and get 2 charting tips.

Continue »

## How do you make charts when you have lots of small values but few extremely large values? [Debate]

Published on Aug 20, 2010 in Charts and Graphs, Featured, Learn Excel

Here is an interesting charting problem we come across once in a while. We have a lot of small numbers and a few very large numbers. How do we effectively plot all of them in a chart?

Now, how do you go about making a chart?

Continue »

## 5 Rules for Making Better Charts (and one fun chart)

Published on Jul 30, 2010 in Charts and Graphs

Jeff Weir, an alert reader of this blog points me this chart showcasing voice-over artist’s for various Simpson’s characters. I am a hard-core Simpon’s fan, so I naturally wasted quarter-hour looking at the chart. That is when I realize this chart is not only fun, it also teaches 5 valuable lessons on making better charts. Read the rest of this post to find out the five rules.

Continue »