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

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

Posted on 09 December 2009

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

## Six Sigma Table

Posted on 12 May 2009

A Six sigma table is a table that depicts the (six) sigma value corresponding to various accuracy levels. The six sigma table can be downloaded here. By looking down the tabulated values of the accuracy levels, you can find the (six) sigma level that corresponds to your accuracy level. The sigma table has five columns – the yield or the accuracy level ( 1 – the defect rate), the ...

## Six Sigma Calculator in Excel

Posted on 11 May 2009

How do you make a six sigma calculator in Excel? Well it's all really quite simple in excel....the calculator needs only a single formula to generate the sigma level for a process!!! You simply plug the number of opportunities & defects into an excel spreadsheet and calculate the sigma level by using NORMSINV (1 - defect/opportunities). You can download a copy of the six sigma calculator in excel here. Before ...

## House of Quality Template in Excel

Posted on 10 May 2009

You can download the house of quality template in excel here. House of quality is a graphic tool analyzing the relationship between a firm's focus on improvement and the needs of its customers.It is a part of the Quality Function Deployment (QFD). Visually, it looks like a grid with a correlation matrix at its top and left side. The customer needs vs the firm's product features form the main body of the house of quality. Using this template in ...

## How to create a Gantt Chart in Excel

Posted on 07 May 2009

This article shows how to make Gantt charts in excel. Though Excel remains the preferred choice for creating simple Gantt charts, there are other commercial tools available for developing more complex versions of the Gantt chart. GANTT Charts are an important project management tool. In this article, I will describe how to create gantt chart in excel with a marker for show today's date. Using a stacked chart in excel, we ...

## How to Create a Pareto Chart in Excel

Posted on 05 May 2009

Find out how to create a Pareto chart in Excel. A Pareto chart can be created in Microsoft Excel as a combination of a bar and a line chart. A Pareto chart (also known as the Pareto graph) is a combination of two data series, one set of points representing a set of independent values and the other representing the cumulative sum of those values. The independent values are typically represented by vertical bars in which the values are arranged ...

## How to create an Excel Flow Chart – (Template and Software)

Posted on 04 May 2009

This tutorial shows how to create a Flow charts in Excel. Flowcharts help you logically represent a sequence of activities in a process. Before you begin, you may want to download and analyze this sample flowchart template created using excel. Making flowcharts in Excel can be as easy and fast as it is in Microsoft Visio without having to buy a license for the later. If you work in a company where a lot of planning and process engineering ...