Control Chart in Excel – Create Six Sigma Quality Control Chart Using Excel

Control Charts are an important tool for process quality control. A control chart is generated by when upper and lower control limits are inserted in to a line chart representing changes in a variable over a given period of time. Control charts are an important member of the six sigma methodology and help in visually ascertaining the quantum (and trend) of variation observed in a process. The upper and lower quality control limits in ...

Continue Reading

Control Chart in Excel - Create Six Sigma Quality Control Chart Using Excel

Excel Flowchart

Posted on 25 June 2009

Excel Flowchart
Excel Flowchart 1.0 is free tool for creating great looking flowcharts in Excel. With Excel Flowchart 1.0 creating an excel flowchart is now as easy and quick as pressing a button. Whether it be documenting the workflow or designing a new business process, Excel Flowchart 1.0 gets the job done. Now design high quality excel flowcharts with neat well spaced steps. No dragging and dropping or having to format multiple objects one by one - Excel Flowchart 1.0 takes care of ...
Continue Reading

Comments     

Fix Runtime Error in VBA

Posted on 24 June 2009

Fix Runtime Error in VBA
To fix runtime errors is VBA, use the following three statements - On Error, Resume and Debug. The first one traps a runtime VBA error when it occurs, the second one tells the application the point from which to resume code execution when the error has been caught (if you decide to catch the error) and the third one informs the user where (and which) runtime error took place. A runtime Error in VBA can occur for a plethora of reasons. ...
Continue Reading

Comments (7)

Read Write to File, Excel Workbook, Access using Javascript & SQL

Posted on 22 June 2009

Read Write to File, Excel Workbook, Access using Javascript & SQL
Read Write to File, Excel Workbook, Access using Javascript and SQL Javascript when used with ADO* and SQL can read write from data sources such as a file, Excel or an Access database. (* ADO = ActiveX Data Object). Since this technique relies on the use of ADO, a bit about ADO before we begin to help you understand how this works. According to wiki, Microsoft's ActiveX Data Objects (ADO) is a set of Component Object Model (COM) objects for accessing ...
Continue Reading

Comments (18)

Funny Graphics

Posted on 21 June 2009

Funny Graphics
A couple of funny graphics to get you over the weekend blues :-) Viagra Sales (Courtesy: funnytimes.com) The right spot Finding the right man can be quite a challenge. (Courtesy: hottestsnaps.blogspot.com) Length of shorts (Courtesy: iamtheweather.com) The world of 100 If the world were to consist of only 100 people: ...
Continue Reading

Comments (3)

Bump Chart

Posted on 18 June 2009

Bump Chart
Bump charts got their name from “bumps race’”, a term used to refer to a boat race where each boat tries to “bump” the one in front and move up the chart. Bump charts have become quite common of late and are typically used to represent changes in the position of a given number of competing entities over a fixed time duration. Bump charts have been featured quite prominently on Kiaser ...
Continue Reading

Comments (2)

Stock Chart with Scroll and Zoom

Posted on 17 June 2009

Stock Chart with Scroll and Zoom
Stock charts come in various shapes. There are candlestick stock charts, line and bar stock charts, “Kagi” stock charts, moving average stock charts and everything in between. For a financial service provider how to present financial information pertaining to a specific stock can a critical question. On one hand, if you give too many options, you loose out on user comfort and increase API complexity. On the other, give too few options and you end up losing more demanding customers. ...
Continue Reading

Comments (9)

Chart Table – When a Beautiful Chart meets a Handsome Table

Posted on 16 June 2009

Chart Table - When a Beautiful Chart meets a Handsome Table
Chart table - as the name suggests - is a beautiful fusion of a chart and a table giving rise to a visually appealing yet information rich presentation of data. Not that the concept itself is anything new - experts have openly and vociferously championed the cause of the chart table, its various facets have been discussed at length in numerous forums and the latest versions of excel come equipped with tools that further aid their creation (namely sparklines). However ...
Continue Reading

Comments (1)

Area Chart with Multiple Overlapping Bands

Posted on 14 June 2009

Area Chart with Multiple Overlapping Bands
An area chart (or an area graph) comes in handy when plotting a set of metrics over a period of time. An area chart can also be transformed in to a band or a spline chart so that it represents changes in a metric within a certain band over a period of time. Shown below is an area chart which has been transformed in to a chart with a band (spline) by using two data series one of which is ...
Continue Reading

Comments (1)

Where did my money go ?

Posted on 11 June 2009

Where did my money go ?
Flowing data had this posted a few months back showing various infographics which chart out the financial crisis and the events related to it. There even an interesting clip that you can watch. Interestingly the article also carries the impressive NY Times graphic on how this bear market compares to ...
Continue Reading

Comments     

GETPIVOTDATA Formula Excel – How to use GETPIVOTDATA Function with Pivot Table

Posted on 10 June 2009

GETPIVOTDATA Formula Excel - How to use GETPIVOTDATA Function with Pivot Table
Syntax of GETPIVOTDATA Formula Example of GETPIVOTDATA Formula Making GETPIVOTDATA Formula Dynamic GETPIVOTDATA formula is used with a pivot table to fetch values from it. GETPIVOTDATA Formula Syntax The GETPIVOTDATA Formula has the following syntax: =GETPIVOTDATA (DataField, PivotTableCell, FieldName 1, Item 1, FieldName 2, Item 2, ... FieldName N, Item N) However before we delve any deeper in the GETPIVOTDATA formula, let's get back to basics for a minute. Basic structure of a pivot table A pivot table is based ...
Continue Reading

Comments (13)

How to generate a sample set with normal distribution in Excel

Posted on 09 June 2009

How to generate a sample set with normal distribution in Excel
Normal distribution is one of the most commonly found distribution types in nature. The normal distribution is a continuous probability distribution where the data tends to cluster around a mean or average. If you were to plot the frequency distribution of a normal distribution, you will tend to get the famous inverted bell-shaped curve also known as the Gaussian function. Coming to the point, we are sometimes faced with situations where we would like to test out a hypothesis or carry ...
Continue Reading

Comments (9)

Make excel calculate faster – Quick tip

Posted on 09 June 2009

Make excel calculate faster - Quick tip
If you want to make your large excel workbook calculate faster and have about 10 seconds of time on your hands, use this trick. 1. Open the workbook and select the spreadsheet with the largest number of formulas (or data). 2. While keeping the 'Ctrl' key pressed, press 'End'. 3. Check the cell address that the cursor has moved to. 4. If the cursor is well beyond the last cell that had a formula ...
Continue Reading

Comments     

How to synchronize two or more pivot tables using VBA

Posted on 08 June 2009

How to synchronize two or more pivot tables using VBA
One often comes across situations when one wants to synchronize two or more pivot tables. The problem arises when two or more pivot tables have the same underlying data set but show different views to the user. In such cases, combining both of them without losing data separation is not really an option. I wrote this small piece of VBA code a few months back that can help synchronize pivots across ...
Continue Reading

Comments     

Beard Stories

Posted on 07 June 2009

Beard Stories
Beards are not a topic that you'd think someone would typically write about leave aside holding yearly competitions for. Dyers.org is Jon Dyer's site where he talk about life, leisure, movies and his experiments with beards. Sometimes its stuff like this that makes you realize that life is so much more fun when you're off the beaten path. Here is a nice chart of various beard styles on his site that caught my fancy. ...
Continue Reading

Comments (1)

The Weekend Strip

Posted on 07 June 2009

The Weekend Strip
Time for a break from the usual Excel stuff......a couple of chosen Dilbert's.....
Continue Reading

Comments     

Retirement Planner in Excel

Posted on 04 June 2009

Retirement Planner in Excel
Retirement planner in Excel will help you calculate your savings at the time of retirement. The Excel retirement planner takes in to consideration your monthly income, expenses, asset purchase over time, saving allocations and expectations of interest rates and asset appreciation to calculate the growth of your savings over a given period. You can download the retirement planner in excel here. All of us worry about the impeding retirement. How ...
Continue Reading

Comments     

Excel Chart Tip – Insert Chart Series in an Excel Chart

Posted on 03 June 2009

Excel Chart Tip – Insert Chart Series in an Excel Chart
Adding new series to an Excel Chart can be a boring job. Normally you'd edit the Excel chart by right clicking the chart area and adding a new series in the Source Data box (which can take up to 7 clicks). By using this quick tip you can now insert a new chart series with just two mouse clicks. Here’s how it can be done. Inserting a new series ...
Continue Reading

Comments (4)

In Cell Charts in Excel

Posted on 23 May 2009

In Cell Charts in Excel
An in cell chart in excel is a chart that has been reduced to fit in a single cell. In cell charts have been around for a long time but have gained significance in the past few years as projects and companies become more complex forcing analysts to pack more information per inch and more importantly, per second of the decision makers time. In this article we will discuss quick ...
Continue Reading

Comments (3)

Make Charts in Excel Using Symbols

Posted on 21 May 2009

Make Charts in Excel Using Symbols
You can use Excel to make charts using symbols and display unconventional characters. Here's a list of symbols that can be used for making charts in excel. You can generate these symbols in Excel by formatting normal alpha-numeric characters with in-built or custom fonts (Windings, MS Outlook etc.) Few quick tips: To make a bar graph Use the REPT(char) function in Excel to repeat a character. Choose from the list of symbols ...
Continue Reading

Comments (1)

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