visualization Category

KPI Dashboards - Improving with Quartile Information - [Part 3 or 4]

on 3 Sep, 2008 in Excel Tips, Featured, ideas, visualization | 9 Comments

KPI Dashboards - Improving with Quartile Information - [Part 3 or 4]

Creating KPI Dashboards in Microsoft Excel is a series of 4 posts by Robert from Munich, Germany.
Read part 1 & 2 of this series, Creating Key Performance Indicator Dashboards in Excel with Scroll Controls, Adding sort options to excel dashboards before reading this post.

The challenge - Adding Percentile Information
Let’s get back to our last week’s [...]

Read More >>

6 charts you will see in hell

on 3 Sep, 2008 in Excel Tips, Featured, visualization | 4 Comments

6 charts you will see in hell

Often it is easy to get carried away with a tools features. Excel is no exception. But here is a list of grotesque charts that you should never make, not even on your last day at work.
1. Leave the radar charts for Spidermen

why?

You can hardly conclude anything by looking at them
They need lot of tweaking [...]

Read More >>

Cool Visualizations of the Week [Aug 29]

on 29 Aug, 2008 in cool infographics, visualization | 0 Comments

Cool Visualizations of the Week [Aug 29]

Once every week Pointy Haired Dilbert celebrates the art of chart making by sharing 4-5 of the best info-graphics featured in various web sites. Click here to see the charts featured earlier.
How to does Love, Anger, Joy and other emotions look like?

Have you ever wondered how your emotions look like? That is exactly what folks [...]

Read More >>

Creating KPI Dashboards in Microsoft Excel [Part 2 or 4] - Adding One Click Sort

on 27 Aug, 2008 in Analytics, Excel Tips, Featured, ideas, visualization | 25 Comments

Creating KPI Dashboards in Microsoft Excel [Part 2 or 4] - Adding One Click Sort

Creating KPI Dashboards in Microsoft Excel is a series of 4 posts by Robert from Munich, Germany.
Read part 1 of this series, Creating Key Performance Indicator Dashboards in Excel with Scroll Controls before reading this post.

The Challenge - Sorting
With the post KPI Dashboard Table – Scroll we started a little series of posts on [...]

Read More >>

5 wonderful visualizations you must see [Aug 22]

on 22 Aug, 2008 in cool infographics, ideas, visualization | 1 Comment

5 wonderful visualizations you must see [Aug 22]

Every week Pointy Haired Dilbert celebrates the art of chart making by sharing 5 of the most beautiful, innovative and effective infographic ideas from various sites. Click here to see the visualizations featured earlier.
Pop, Soda or Coke? - Countywise terms used for sweetened carbonated water

The pop-vs-soda map tells how marketers have been effective and creating [...]

Read More >>

Display symbols in excel chart axis

on 21 Aug, 2008 in Excel Tips, hacks, ideas, visualization | 6 Comments

Display symbols in excel chart axis

Here is a quick excel tip to make your charts look professional by showing symbols in the axis labels instead of text.
Just follow these 4 simple steps:

First identify the symbols you want to show on the axis or as data label from symbol fonts like webdings, wingdings or a custom dingbat font like company [...]

Read More >>

Creating KPI Dashboards in Microsoft Excel [Part 1 of 4]

on 20 Aug, 2008 in Excel Tips, Featured, ideas, visualization | 24 Comments

Creating KPI Dashboards in Microsoft Excel [Part 1 of 4]

Creating KPI Dashboards in Microsoft Excel is a series of 4 posts by Robert from Munich, Germany. Robert has been using excel for last 18 years starting with MS Excel version 3.0 in 1990. He has huge passion for data visualization and presentation using excel. When I got a mail from him 2 weeks back [...]

Read More >>
Page 5 of 11« First...«34[5]678»...Last »