Browse by Tags

Before one can position an address (a street address or a town itself) on a map, it must be converted to geographic coordinates (latitude and longitude). Then, that latitude and longitude is mapped to a particular location on the map. Figure 1 shows several thousand U.S. cities and towns on a Mercator projection [...] Read More...

A binary clock, or more accurately a binary-coded decimal clock, shows each digit in binary. I first saw one at a friend’s place and it served as an interesting ice breaker. The below image is from Excel. Specifically, it is an Excel chart, though most would be hard pressed to recognize it [...] Read More...

The x-axis of a Column chart can contains either category values (the x values are equidistant) or dates. Neither of these allows for a truly numeric x axis. This tip shows how to simulate a column chart that has cardinal numbers on the x axis (cardinal numbers contain a sense of ‘distance’ – [...] Read More...

Tornado diagrams graphically display the result of single-factor sensitivity analysis. This lets one evaluate the risk associated with the uncertainty in each of the variables that affect the outcome. Single-factor analysis means that we measure the effect on the outcome of each factor, one at a time, while holding the others at their [...] Read More...

For a version in a page by itself (i.e., not in a scrollable iframe as below) visit http://www.tushar-mehta.com/publish_train/xl_vba_cases/13-03%20Shapes%20on%20a%20Map.shtml Tushar Mehta Read More...

Recently, 1,158 participants selected the winner, against the spread, of 19 NCAA College Football bowl games. I, being one of those participants, selected 8 correct winners - not my best effort. Let’s see how everyone else did. And the data Wins Players Normal 0 0 0 1 0 0 2 0 0 3 1 2 4 6 7 5 31 22 6 77 55 7 145 108 8 196 170 9 217 213 10 209 213 11 160 170 12 68 108 13 38 55 14 6 22 15 4 7 16 0 2 17 0 0 18 0 0 19 0 0 1158 1154 The formula in column C is =ROUND(NORMDIST(A2,AVERAGE($A$2:$A$21...

I got a couple of email responses to Failed Charting. Andries sent in this line chart Keith of Trellis Charts sent in a number of cool charts Trellis has a free beta version. If you try it out, leave a comment and tell me what you think. Read More...

TM AutoChart is a shareware Excel add-in that links the minimum, maximum, major, and minor values of a chart axis to worksheet cells. http://www.tushar-mehta.com/excel/software/autochart/index.html Over the past few months I have been trying out different Ribbon layouts for chart related add-ins. For now, I have settled on a split button where the large button provides [...] Read More...