X

Excel Chart Maximum Y Axis Value and Axis Interval (Major Unit)

Determine Maximum and Minimum Y Axis Value of an Excel Chart Determine Chart Axis Interval (or Major Unit) It's interesting…

Prevent Users Ctrl Break (ing) Your VBA Code During Execution

Anytime I write VBA code that runs for more than a split second, one of my worries remains that someone…

Cricketing Heat Map

Heat maps are pretty versatile. They have been used for everything ranging from charting home prices to changes in the…

Opera Anyone ?

Looks like I am not the only one suffering from browse fatigue. Excel guru Dick Kusleika recently made the shift…

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

So how do you fit multiple scales on a single excel chart? No, we are not referring about the primary…

The Content Aggregator Called Excel

So you have been toiling away on a spreadsheet that must reach the CEO's desk before the end of the…

Table Formula in Excel (Something I didn’t Know Till Yesterday)

Table formulas were something that I discovered recently. Actually our reader m-b commented that he prefers to convert a range…

Multithreaded VBA – An Approach To Processing Using VBScript

Today's guest post is authored by Daniel Ferry, a longtime professional Excel developer and consultant (and a newbie blogger). A…

Named Range – A Few Quickies

Named Ranges are probably one of the most useful features in Excel. Named ranges can add interactivity, make long formulas…

So How Many Of These Excel Shortcuts Do You Know, Punk ?

So you thought you knew every goddam' Excel shortcut out there? Thought that you were the quickest draw around the…

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…

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

A Big Thank You

Its been one and a half year since I started this blog. For the first few months, I thought I…

Square Bubble Heatmap Chart

A what!!! A Square Bubble Heatmap Chart !!! What has the Bison been eating lately. Frankly .. I don't really…

VBA IF Function – Using IF, ELSE:, ELSEIF, IF THEN in VBA code

The IF function in VBA is one of the most frequently used of all statements. The IF function checks if…

Treemap Add-In For Excel – Treemap Software Demo

Treemaps are an interesting way to look at data. Here is the first preview of the treemap add-in for excel.…

A New Rig

Last week my computer broke down. This time, unlike previous occasions, it just wouldn't resurrect itself. That rig was my…

Data Validation List in Excel – Create Drop Down List Using Data Validation in Excel

Data Validation feature in Excel allows the user to create a drop down list in Excel. The drop down list…

Treemap in Excel – Coming Soon

Its been a few days since I posted. In case you were wondering what I was up to - yours…

VBA Select Case – Using VBA Select Case Statement in Excel

The VBA Select Case Statement is an important construct in the VBA language. The Select Case statement in VBA allows…