All articles with 'charting principles' Tag

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

Published on Apr 29, 2011 in Charts and Graphs
Place Key Information in Golden Triangle on your Reports, Dashboards etc. [Quick Tips]

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
Show Details On-demand in Excel [Tutorial + Training Program]

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
Give more details by showing average and distribution [Charting Tips]

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
Health-care Dashboard in Excel [Dashboard Week]

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
Use Analytical Charts to Make your Boss Love You

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 Grammy Bump Chart in Excel

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
How would you Visualize World Education Ranking Data [Homework + Video]

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.

Post your submissions using comments.

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
Do you use (or make) Excel Dashboards? Tell us about yourself to win a free training kit

(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
Show Top 10 Values in Dashboards using Pivot Tables

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
Show Months & Years in Charts without Cluttering

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
Analyze Competition with Scatter Plots – A business chart example

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
August 2010 – Best Month Ever (and 2 charting tips inside)

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
How do you make charts when you have lots of small values but few extremely large values? [Debate]

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
5 Rules for Making Better Charts (and one fun chart)

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 »

Display Alerts in Dashboards to Grab User Attention [Quick Tip]

Published on May 25, 2010 in Charts and Graphs
Display Alerts in Dashboards to Grab User Attention [Quick Tip]

Dashboards can be overwhelming with lots of details and context. A simple way to drag user’s attention to important stuff in the dashboard is to use alerts. See this example to understand what alerts mean. How to display alerts in Excel Dashboards? The easiest way to display alerts is to use Excel 2007’s Conditional Formatting […]

Continue »