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. Being a demo, the number of data points are limited to 50. Here the a demo file containing the treemap add-in for Excel. (The demo treemap version is limited to a maximum of 50 rows and is meant for evaluation purpose only. The full version does not contain this restriction.) ...

Continue Reading

Treemap Add-In For Excel - Treemap Software Demo

A New Rig

Posted on 28 December 2009

A New Rig
Last week my computer broke down. This time, unlike previous occasions, it just wouldn't resurrect itself. That rig was my first build and had been with me for the past eight years. It wasn't a thoroughbred, a humble Duron (AMD) at heart but it had its fair share of adventures. All those impromptu college parties, those last minute project reports, getting hauled around in a rug-shack, a thousand tweaks to squeeze the last remaining MHz out of the processor, even ...
Continue Reading

Comments (1)

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

Posted on 25 December 2009

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 created using data validation allows the user to pick and choose a single value from the entire list and thus prevents entry of invalid values. The drop down list can be created by typing in a set of values, using a range of cells or by writing a formula in the data validation option box. Create a Drop Down List ...
Continue Reading

Comments (5)

Treemap in Excel – Coming Soon

Posted on 24 December 2009

Treemap in Excel - Coming Soon
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 ...
Continue Reading

Comments (12)

VBA Select Case – Using VBA Select Case Statement in Excel

Posted on 20 December 2009

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 the program to execute one set of statements out of many based on what a given expressions evaluates to. In today's post we will look at some basic and intermediate ways in which it can be used when writing VBA code. Basic Form of the VBA Select Case Statement [cc lang="vb"] Select Case expression_to_test Case expression_value_1 : Code to Execute When expression_to_test = expression_value_1 Case ...
Continue Reading

Comments (8)

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

Posted on 16 December 2009

Control Chart in Excel Using VBA - Six Sigma Control Chart Code & Software
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 ...
Continue Reading

Comments (5)

One Axis Frequency Distribution Chart in Excel (Download & Template)

Posted on 13 December 2009

One Axis Frequency Distribution Chart in Excel (Download & Template)
One axis charts combined with the histogram are a great way to summarize unidimensional data. Excel does not provide provide in-built support for one axis frequency distribution charts but they can be created without breaking into a sweat. The Histogram The histogram trades off detail for ease of comprehension. Let's look at the chart below. This one's based on a set of 250 data points with ...
Continue Reading

Comments (3)

Custom Format to Catch Numbers Appearing as Text

Posted on 11 December 2009

Custom Format to Catch Numbers Appearing as Text
When raw data (in text *txt or csv format) is imported to excel, the conversion can sometimes have an unintended side-effect - the numbers come out as text after the process. The only choice left is to identify the columns that contain numbers masquerading as text and then to use the text to column option on each of the columns one-by-one. If the number of columns is large, eyeballing the data can be a bit of a strain. Here a ...
Continue Reading

Comments (3)

Bar Graph with Helper Stacked Bars

Posted on 10 December 2009

Bar Graph with Helper Stacked Bars
Always wanted to make a stacked bar graph but were afraid connoisseurs would smirk. Let me present - the stacked bar graph with helper bars - the latest addition to the charting fraternity. (Drum rolls) In case you were wondering how this one got made, here are the steps: Set Up the Data for the Bar Graph In this example, we pick up ...
Continue Reading

Comments (6)

Pareto Chart Table – A More Meaningful Analysis (Download & Template)

Posted on 09 December 2009

Pareto Chart Table - A More Meaningful Analysis (Download & Template)
Pareto charts are one of the basic pillars of the six sigma methodology and are typically used to depict the frequency of occurrence of issues that affect 'production'. Although one usually sees them being used as standalones, the humble pareto chart can very well be augmented in order to make it a much more meaningful tool for tracking and resolving pending issues & errors. Let's look at one such approach that utilizes a combination of a horizontal pareto chart ...
Continue Reading

Comments (5)

Keyboard Shortcuts in Excel to Sort, Add, Hide Pivot Table Items and Fields

Posted on 03 December 2009

Keyboard Shortcuts in Excel to Sort, Add, Hide Pivot Table Items and Fields
Here are some quick keyboard shortcuts in Excel to help you survive in the pivot table jungle. Keyboard shortcut to Sort Fields and Items in a Pivot Table Thought that you would have to drag the field or the item across the pivot table using the mouse. Hold on - you can use the keyboard too. Simply type the field or the item ...
Continue Reading

Comments (5)

Timeline Chart in Excel with Interactive Event Descriptions (Download & Template)

Posted on 01 December 2009

Timeline Chart in Excel with Interactive Event Descriptions (Download & Template)
A timeline chart allows the reader to understand the chain of events as they take place over a period of time. The events are typically represented as markers along a horizontal or a vertical line. In our previous post on adding interactive labels to chart, we saw how to fit a large number of event descriptions in a single chart. Today we look at a similar approach in order to ...
Continue Reading

Comments (2)

Remove Background Tool in Office – Results from the Test Drive

Posted on 27 November 2009

Remove Background Tool in Office - Results from the Test Drive
The remove background tool is one of the new features introduced in Office 2010. Ever since I downloaded the public beta, I've been itching to take it for a test drive and this weekend, I did just that. I tried my hands at two images - one with high and the other with low contrast. So let's look at the results Remove Background from a High Contrast Image We picked up an ...
Continue Reading

Comments (3)

Data Validation in Excel – How to Use Data Validation Feature in Excel

Posted on 24 November 2009

Data Validation in Excel - How to Use Data Validation Feature in Excel
Data Validation feature in Excel prevents invalid entries from being entered into a cell in a sheet. Data validation can be set up to work with numbers, text string, date / time or customized formula so that we can restrict the set of values that can be entered in a cell and also prevent wrong entries being made at the time of data entry. Data validation can also be used to create drop down lists so that the user ...
Continue Reading

Comments (1)

Excel 2010 vs Excel 2007 : Basic Performance Test

Posted on 24 November 2009

Excel 2010 vs Excel 2007 : Basic Performance Test
My first impression of Excel 2010 was that it 'felt' faster than Excel 2007. So one of the first things that I did was to take it for a test ride. Now, I must admit, testing isn't my forte. A long long time back when I was a developer, I used to write horrible code. I had a fancy for declaring variables like i1, i11, i111 (and so on and so forth) and seldom wrote comments that could explain ...
Continue Reading

Comments (5)

Slicer VBA Code – Create, Change or Modify a Pivot Table Slicer using VBA

Posted on 23 November 2009

Slicer VBA Code - Create, Change or Modify a Pivot Table Slicer using VBA
Here is some VBA code that can help you automate working with a slicer in Excel. Slicers, as you would know, are the latest introduction to Excel. As I mentioned in my previous post, they can also be programattically controlled using simple VBA code. Let's see how. Slicer Creation using VBA - Basic Steps Let's look at the slicer hierarchy - a workbook has slicer caches (accessed the SlicerCaches object), each slicer cache in turn having multiple slicers (one for each ...
Continue Reading

Comments (7)

Slicer in Excel – The Pivot Table Remote Control

Posted on 20 November 2009

Slicer in Excel - The Pivot Table Remote Control
Slicer What is a Slicer? One can think of a slicer as an extension of a pivot table which makes the job of filtering the pivot table data easier. One shortcoming that pivot tables earlier had was that you could not control them remotely. Short of VBA, you could do things with pivot tables only when you had one in front of you. A slicer on the other hand acts as a 'remote control' for the pivot table. You can ...
Continue Reading

Comments (7)

Sparklines in Excel – New Features in Excel 2010 Series

Posted on 19 November 2009

Sparklines in Excel - New Features in Excel 2010 Series
Excel 2010 introduces a new feature called sparklines. Sparklines are essentially miniature charts showing only the plot and pretty much nothing else (though you can turn on chart axis if you want). The advantages are obvious. In the same amount of space that it to present a normal excel chart with a handful of data points, you can pack a dozen or more sparkline charts. If used intelligently, the data loss due to absence of reference lines and ...
Continue Reading

Comments (6)

Excel 2010 – Beta Review

Posted on 18 November 2009

Excel 2010 - Beta Review
Excel 2010 beta is out today. For those who read my review of Excel 2007, I mentioned that the chances of my being able to try out Excel 2010 anytime soon weren’t very high. Excel 2010, I thought at that time, and considering how Excel 2007 turned out, would simply be too big a resource hog to work with the hardware that my pc runs on. In that case I would have to give my faithful old pc ...
Continue Reading

Comments (4)

Pivot Table Quick Tip – Using Pivot Table to Separate Data

Posted on 16 November 2009

Pivot Table Quick Tip - Using Pivot Table to Separate Data
So the poor little manager looks at his computer and says, "how to heck am I supposed to separate this data down to individual sheets for each department." The manager in question had just been handed over a large file containing financial information for all the departments in his organization and was asked to break it down so that each department's data should end up in a separate sheet. The manager ...
Continue Reading

Comments (4)

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