excel chart | Excel & VBA

Multiple Scale Chart - Adding Customized Scale to Each Category in a Chart

Posted on 03 February 2010

So how do you fit multiple scales on a single excel chart? No, we are not referring about the primary and secondary scales on an Excel chart here, we are talking about adding a customized scale for each category in the chart. Take for example the receipts portion of the U.S. federal budget - a data set with multiple categories such as individual income, social security, excise, estate and other taxes & duties. ...

Comments (8)

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

Posted on 12 January 2010

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 ...

Comments (11)

Square Bubble Heatmap Chart

Posted on 06 January 2010

A what!!! A Square Bubble Heatmap Chart !!! What has the Bison been eating lately. Frankly .. I don't really have a name for this chart. It is a bubble chart. The bubbles are square. And it's a heatmap. So I'll call it a Square Bubble Heatmap Chart or better still, S.B.H.C. for short 8-) . The Basic Data Set For the Bubble Chart Now let us assume for a moment that ...

Comments (6)

Treemap Add-In For Excel - Treemap Software Demo

Posted on 29 December 2009

Treemaps are an interesting way to look at data. Here is the first preview of the treemap add-in for excel. Being a demo, the number of data points are limited to 250. Also, to keep things simple, the demo is being made available as a standalone excel workbook. Usage Download the excel workbook given at the end of the post. The demo will work only with Excel 2003 although the complete add-in has been tested to work with Excel 2003 upto ...

Comments (4)

Treemap in Excel - Coming Soon

Posted on 24 December 2009

Its been a few days since I posted. In case you were wondering what I was up to - yours truly was busy coding a program to create treemaps in Excel. Treemaps are interesting creatures. You can pack a few thousand data points in a single treemap and utilize just about the same space as any of the traditional charts. The term 'treemap', as we see it being used nowadays, actually refers to the inward growing members of the treemap ...

Comments (11)

Control Chart in Excel Using VBA - Six Sigma Control Chart Code & Software

Posted on 16 December 2009

In Six Sigma Control charts using Excel we saw how to make control charts using named ranges. From there on, it was a short hop to porting the logic to VBA. So here is the VBA code for automating the creation of a six sigma control charts. It has been tested with Excel 2000, Excel 2007 and Excel 2010. How to Use the Control Chart Program 1. Simply click the 'Make Control Chart' ...

Comments (2)