Cricketing Heat Map

Heat maps are pretty versatile. They have been used for everything ranging from charting home prices to changes in the stock market. (Average Listing Price for US states, week ending Feb 17, 2010. Source : www.trulia.com) (SNP performance, Feb 19, 2010. Source : www.finviz.com/map.ashx) Inspired by the last ball win over the South Africans yesterday night, I wondered if some of that ...

Continue Reading

Cricketing Heat Map

Volatility Chart in Excel – Lessons in Chart Design From NY Times

Posted on 12 January 2010

Volatility Chart in Excel - Lessons in Chart Design From NY Times
Here's a slightly dated chart from NY Times showing volatility on the Wall St across the century. The chart does commendable work in conveying information about a longish time series pretty effectively. I found some great chart design principles at work here that I could utilize for day to day charting needs. (Click on image to open larger version. Click here for the original version) Here's a look at a few of those ...
Continue Reading

Comments (13)

An Excel Chart’s Journey Across Versions

Posted on 10 January 2010

An Excel Chart's Journey Across Versions
Sometime back I wrote a post on making control charts using Excel. The chart was initially created in Excel 2003. The chart consisted of the plot values, the average line and upper & lower control limits. While the main data series was a line chart, the average, upper and lower control limits were plotted as dots of an X-Y and then were extended into lines using the horizontal error bars. Shown below is a sample. ...
Continue Reading

Comments (2)

One Axis Frequency Distribution Chart in Excel (Download & Template)

Posted on 13 December 2009

One Axis Frequency Distribution Chart in Excel (Download & Template)
One axis charts combined with the histogram are a great way to summarize unidimensional data. Excel does not provide provide in-built support for one axis frequency distribution charts but they can be created without breaking into a sweat. The Histogram The histogram trades off detail for ease of comprehension. Let's look at the chart below. This one's based on a set of 250 data points with ...
Continue Reading

Comments (3)

Change in Position – Which Chart Should I Use?

Posted on 16 October 2009

Change in Position - Which Chart Should I Use?
As an analyst, I often need to keep track of the change in position of various players in the industry. More often than not, the position change needs to be tracked between two specific points in time - say quarter 1 vs. quarter 2 or perhaps year 1 vs. year 2. In this article we take a look at a few alternative approaches to plotting position changes and find out which one serves us best. For this example let's take ...
Continue Reading

Comments (11)

Probability Charts – The IMF Way

Posted on 02 October 2009

Probability Charts - The IMF Way
IMF's world economic outlook report bought forth some interesting charts. The charts in question depicted the probability associated with future data points and highlighting the zones of uncertainty associated with each estimate. You can access the entire report here. Creating a Chart with Probability Bands around the chart data Often times there is a bit of uncertainty associated with data points. "Confidence level" is a term often used by statisticians to ...
Continue Reading

Comments (1)

Butterfly Chart – Excel Chart with Dual Converging Scales

Posted on 01 October 2009

Butterfly Chart - Excel Chart with Dual Converging Scales
A Butterfly chart is a chart where two entities are compared side by side using scales meeting at the center. Due to its shape, the chart resembles a butterfly and hence the name. These charts are sometimes also known as Funnel or Tornado Charts though I find "butterfly" to be a better description as it allows for a greater variation in shape than a funnel or a tornado does ! So let's jump ...
Continue Reading

Comments (8)

Chart Label Trick – Converting Chart Axis Labels to Table

Posted on 18 September 2009

Chart Label Trick - Converting Chart Axis Labels to Table
The labels used with the chart category axis are probably the most ignored part of the entire chart making process. You see, the labels on the value axis can be modified, the bars, the lines and the plot area - all of them can be embellished - colors added, widths adjusted, descriptions applied - the works you know ! Even the poor little gridlines can afford a makeover. But what about the chart's category axis label - what do ...
Continue Reading

Comments (3)

Chart Table – When Chart meets Table

Posted on 15 September 2009

Chart Table - When Chart meets Table
Chart table - as the name suggests - is a beautiful fusion of a chart and a table giving rise to a visually appealing yet information rich presentation of data. Not that the concept itself is anything new - experts have openly and vociferously championed the cause of the chart table, its various facets have been discussed at length in numerous forums and the latest versions of excel come equipped with tools that further aid their creation (namely sparklines). However ...
Continue Reading

Comments (6)

Chart Label Trick : Applying Descriptive Labels to Chart Series

Posted on 12 September 2009

Chart Label Trick : Applying Descriptive Labels to Chart Series
Chart labels provide information related to the underlying data. In Excel, by default, chart labels can only consist of the following three - Series Name, Category Name and Chart X & Y Values. So what about situations when you want to convey additional information - for example, say a short description about the chain of events that had a material impact on sales (or say when you ...
Continue Reading

Comments (13)

Bar Chart with an Average Line for Each Group in Chart

Posted on 04 September 2009

Bar Chart with an Average Line for Each Group in Chart
In our previous article we covered adding an average line to a bar chart. At times, however, it may be useful to show an average line for each period or group when the chart consists of more than one such period or group. The advantage here is apparent - not only can the reader view the data points individually, he/she is also able to build a map of how various groups are placed with in relation to each other....
Continue Reading

Comments (1)

Interactive Chart in VBA using Mouse Move Event

Posted on 02 September 2009

Interactive Chart in VBA using Mouse Move Event
VBA can be used to make interactive charts that respond to mouse movements. In this article we first start of by making a simple bar chart embedded in a chart sheet and then use the mouse move event of the chart sheet to make it interactive. Create a simple Bar Chart For the purpose of this exercise, we take the list of top 15 billionaires and sort it based on their networth. We ...
Continue Reading

Comments (21)

Bar Chart with Average Line

Posted on 24 August 2009

Bar Chart with Average Line
A Bar Chart is used to represent data using horizontal bars. One way in which you can augment a bar chart is to add an average line. Create a bar chart Create a bar chart in Excel using any particular data set at your disposal. In our case, we took the Forbes list of the richest people on earth (2009 figures). Here's how the data looks like. To create a bar chart, select ...
Continue Reading

Comments (7)

VBA Chart

Posted on 20 July 2009

VBA Chart
Making a chart using VBA can be easy. VBA provides a handle to a chart object using the "ChartObject" class and to the chart data series trough the "Series" class. Let's look at a basic example where we use VBA to create an empty chart to our spreadsheet and then add data to it. [cc lang="vb"] Sub CreateChart() Dim ChartObj As ChartObject Dim ChartSeries as Series Set ChartObj = ActiveSheet.ChartObjects.Add ( Left: = 100, Width: = 550, Top: = 75, Height: = 325) Set ...
Continue Reading

Comments (7)

Javascript Charting Library

Posted on 06 July 2009

Javascript Charting Library
A Javascript charting library is a compilation of javascript code which helps you create charts in a browser. Here's a list of 5 Javascript charting libraries that I had a chance to review : (Each of the Javascript charting libraries reviewed below would offer its own custom functions to interact with the chart object. If a chart fits your need, you may want to read the chart library's API documentation in greater detail. However, if you're short on development time, this ...
Continue Reading

Comments (1)

How to Choose a Chart

Posted on 03 July 2009

How to Choose a Chart
How to choose a chart? Which chart would best fit the data set that I have? How do I choose the better chart type from Excel? Finding the right type of chart for the data set that you have can be a bit of a challenge. Given a set of seemingly equivalent alternatives, picking one chart over the other can turn out to be quite an interesting exercise. The chart chooser diagram can help you make a choice in situations ...
Continue Reading

Comments (8)

Chartjunk

Posted on 29 June 2009

Chartjunk
Chartjunk, a term first coined by Edward Tufte, refers to all those elements in a chart that add no further value. Chartjunk comes in many shapes and size - redundant labels, unnecessary gridlines, over-the-top use of colors and everything that a 'creative' mind can think of. However what should be kept in mind is that this term also has a strong contextual meaning. An element that may appear as chartjunk in one graph may serve a useful function in another ...
Continue Reading

Comments (6)

Bump Chart

Posted on 18 June 2009

Bump Chart
Bump charts got their name from “bumps race’”, a term used to refer to a boat race where each boat tries to “bump” the one in front and move up the chart. Bump charts have become quite common of late and are typically used to represent changes in the position of a given number of competing entities over a fixed time duration. Bump charts have been featured quite prominently on Kiaser ...
Continue Reading

Comments (2)

Stock Chart with Scroll and Zoom

Posted on 17 June 2009

Stock Chart with Scroll and Zoom
Stock charts come in various shapes. There are candlestick stock charts, line and bar stock charts, “Kagi” stock charts, moving average stock charts and everything in between. For a financial service provider how to present financial information pertaining to a specific stock can a critical question. On one hand, if you give too many options, you loose out on user comfort and increase API complexity. On the other, give too few options and you end up losing more demanding customers. ...
Continue Reading

Comments (9)

Area Chart with Multiple Overlapping Bands

Posted on 14 June 2009

Area Chart with Multiple Overlapping Bands
An area chart (or an area graph) comes in handy when plotting a set of metrics over a period of time. An area chart can also be transformed in to a band or a spline chart so that it represents changes in a metric within a certain band over a period of time. Shown below is an area chart which has been transformed in to a chart with a band (spline) by using two data series one of which is ...
Continue Reading

Comments (1)

  • Page 1 of 2
  • 1
  • 2
  • >

Subscribe

Keep up with the latest stories - Delivered right to your inbox
feedburner

Translate

English flagItalian flagKorean flagChinese (Simplified) flagPortuguese flagGerman flagFrench flagSpanish flagJapanese flagArabic flagRussian flagDutch flagHindi flagFilipino flagIndonesian flagThai flagTurkish flagPersian flag
treeemap software for excel


ARCHIVES