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

Posted on 25 December 2009

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 (3)

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

Posted on 24 December 2009

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)

Treemap in Excel - Coming Soon

Posted on 24 December 2009

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 (11)

VBA Select Case - Using VBA Select Case Statement in Excel

Posted on 20 December 2009

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     

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

Posted on 16 December 2009

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 Chart' ... Continue Reading

Comments (2)

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

Posted on 13 December 2009

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 (1)