bubble chart | Excel & VBA

Square Bubble Heatmap Chart

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

How to Choose a Chart

Posted on 03 July 2009

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

Comments (8)

DNA Strand simulation using Excel

Posted on 01 September 2008

Excel can be used to create neat little simulations for classroom traings. I remember a long time back, I had a tough time trying to understand how the strands of a DNA coil around each other. Well....I tired my hands at creating a rotating DNA strand using 3-D bubble charts.....stright 'n simple for the most part......the trick lies in making the base and linking pairs change their overlaps after rotating every ...

Comments