How This Bear Market Compares – NY Times

A problem frequently encountered with displaying multiple series with overlapping data points within a single line chart is that they just seem to entangle themselves. To get an idea of all the data point that a series represents, the user has to either mentally segregate it from the rest or click on it to highlight the particular line. The NY Times recently published a chart How This Bear Market Compares that tries to ...

Continue Reading

How This Bear Market Compares - NY Times

Get each of your spreadsheets a customized menu

Posted on 09 October 2008

Get each of your spreadsheets a customized menu
Those who’ve worked with elaborate multi-worksheet dashboards would realize the usefulness of adding a customized menu option. Apart from other things, a customized menu option can be used to guide the user to specific portions of an excel spreadsheet. For example, if you have a long report consisting of multiple charts, pivots, images and data fields, you may want to spare the reader the effort of locating the most useful (or important) portions by creating a new menu option and ...
Continue Reading

Comments (1)

How much is $700 billion?

Posted on 03 October 2008

How much is $700 billion?
USA Today came out with this graphic recently which compares the size of the recent bailout package with the other historical packages in the past. I tried my own version of this and came pretty close to achieving the same results in excel. "Close" because there would be errors since the size of the boxes may not accurately represent the number corresponding to it. As Paulson said, "If you have ...
Continue Reading

Comments     

Own, Let-out or Rent – Making of a house

Posted on 21 September 2008

Own, Let-out or Rent - Making of a house
One question that comes to everybody's mind when thinking of investing in a house is whether the investment will be worth it. Over the weekend I worked out a basic model that attempts to work out the financials in three different scenarios - buying a house and occupying it, buying and letting out and thirdly, not buying a house at all. Expectedly, we can see, that buying a house may turn ...
Continue Reading

Comments (2)

Going online with your excel charts

Posted on 20 September 2008

Going online with your excel charts
Excel provides a way to convert the charts in an excel workbook to a webpage. To move your charts online, select the chart and use the Save as option to save the chart as a .mht/.mhtml web page. What's more, the charts on the web page are interactive....changing values in the worksheet reflect in the chart elements. A very useful, though a little cumbersome, way of publishing chart intensive dashboards, reports and ...
Continue Reading

Comments     

You’ve seen 2D, what about 3D simulation in excel

Posted on 20 September 2008

You've seen 2D, what about 3D simulation in excel
Peter Rakos in his article in Gamasutra shows how to create a 3D simulation in Excel. He uses the create polyline (Shapes.AddPolyline) function in excel to generate a set of  triangles (2D). A paid of these triangles is used to generate one surface of a rotating cube. 12 such triangles are used to generate the entire cube (12 triangles = 6 surfaces = 1 cube). Before each iteration, the previous shapes are destroyed ...
Continue Reading

Comments     

6 Easy Steps to Making an Interactive Map Chart in Excel

Posted on 14 September 2008

6 Easy Steps to Making an Interactive Map Chart in Excel
Creating interactive map charts in excel is one of the easiest things to do.....that is if you know how. I recently created this map chart showing the top 50 tropical storms to hit the Unitef States since 1900. As you move ahead in time from 1900 to 2005, the map shows the states that were hit by the storm, the damage caused, storm category and rank. It takes about 5 lines ...
Continue Reading

Comments (5)

Speed Gauges – An absolute No No

Posted on 11 September 2008

Speed Gauges - An absolute No No
.....because they take up a lot of space to show just one data element. However, if you still want to go ahead, you may want to take a look at this. (Inspired by the speed gauge depicted on BusinessObjects, now a SAP company). You can download the file here.
Continue Reading

Comments (2)

Tracking mouse movements in Excel

Posted on 11 September 2008

Tracking mouse movements in Excel
I wrote this small program that tracks the movement of the mouse in excel. The program uses an image to return the mouse X,Y coordinates. The shape that follows the mouse changes its attributes as it passes through various points in space. You can download the file here.
Continue Reading

Comments     

Creating tree structure in excel

Posted on 06 September 2008

Creating tree structure in excel
You can use the group and outline features in excel to create tree structures. On expanding each node the next branch becomes visible. You can download the file here.
Continue Reading

Comments (1)

The Jordan effect

Posted on 01 September 2008

The Jordan effect
tvbythenumbers.com paints the "Jodran Effect". Micheal's dominance of the NBA from 1991 to 1994 sent TV viewerships soaring to new heights. He then tried his hands at baseball and came back in 1996 not only to halt the decline while he was away but take them to yet newer levels. The ratings have never been that high again. (The upper line shows Viewership during NBA finals. The lower line shows viewership ...
Continue Reading

Comments     

DNA Strand simulation using Excel

Posted on 01 September 2008

DNA Strand simulation using Excel
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 ...
Continue Reading

Comments     

Tell me the time !! A TAG Heuer watch.

Posted on 23 August 2008

Tell me the time !! A TAG Heuer watch.
[caption id="attachment_130" align="alignnone" width="300" caption=""][/caption] Just playing around and having fun. Pretty simple code but one that realy works. You can have a look at the file here. Image courtesy www.dialaphone.co.uk
Continue Reading

Comments     

Sudoku solver in Excel VBA

Posted on 23 August 2008

Sudoku solver in Excel VBA
Update: You can download the Sudoku Solver in Excel with brute force here (latest version) here. For the uninitiated, Sudoku is a grid of 9x9 cells where each cell can and must have a value from 1 to 9 such that no number must be repeated in a row, column or any of the 9 groups of 3x3 grids. And not onto the circumstances behind this sudden urge to develop a sudoku solver. ...
Continue Reading

Comments     

  • Page 2 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