How to Choose a Chart

How to choose a chart? Which chart would best fit the data set that I have? How do I choose the better chart type from Excel? Finding the right type of chart for the data set that you have can be a bit of a challenge. Given a set of seemingly equivalent alternatives, picking one chart over the other can turn out to be quite an interesting exercise. The chart chooser diagram can help you ...

Continue Reading

How to Choose a Chart

VLOOKUP Formula Excel – How to use Excel VLOOKUP Function

Posted on 01 July 2009

VLOOKUP Formula Excel - How to use Excel VLOOKUP Function
Syntax of VLOOKUP Formula Example of VLOOKUP Formula Possible Errors returned by the VLOOKUP Formula VLOOKUP formula matches a string against the 1st column of a range and returns any cell value from the matched row. VLOOKUP Formula Syntax VLOOKUP Formula has three parts: VLOOKUP (value_to_find, range_to_search_in, column_number_to_return, match_type) value_to_find value_to_find is the value that we would like to find. You can specify a string, a number or a cell ...
Continue Reading

Comments (9)

VBA For Loop – For Next and For Each In Next

Posted on 01 July 2009

VBA For Loop - For Next and For Each In Next
The For Loop in VBA is one of the most frequently used loops in VBA. The For loop has two forms: For Next and For Each In Next. The For loop is typically used to move sequentially through a list of items or numbers. To end the for loop at any given point we can use the exit for statement. Let's take a closer look at each of these loops. ...
Continue Reading

Comments (15)

Chartjunk

Posted on 29 June 2009

Chartjunk
Chartjunk, a term first coined by Edward Tufte, refers to all those elements in a chart that add no further value. Chartjunk comes in many shapes and size - redundant labels, unnecessary gridlines, over-the-top use of colors and everything that a 'creative' mind can think of. However what should be kept in mind is that this term also has a strong contextual meaning. An element that may appear as chartjunk in one graph may serve a useful function in another ...
Continue Reading

Comments (6)

How To Create Pivot Table Using VBA

Posted on 28 June 2009

How To Create Pivot Table Using VBA
How to create a pivot table using VBA? Assuming that the data for the pivot table is laid out like this, then all you need to create a pivot using vba are there four lines of code: ActiveWorkbook.PivotCaches.Add(SourceType:=xlDatabase, SourceData:= ActiveSheet.UsedRange).CreatePivotTable TableDestination:="", TableName:= "PivotTable1", DefaultVersion:=xlPivotTableVersion10 ActiveSheet.PivotTableWizard TableDestination:=ActiveSheet.Cells(1, 1) ActiveSheet.PivotTables("PivotTable1").AddFields RowFields:="Name" ActiveSheet.PivotTables("PivotTable1").PivotFields("Name").Orientation = xlDataField The pivot table so created using the VBA code above can be ...
Continue Reading

Comments (6)

Funny Side Up – I

Posted on 28 June 2009

Funny Side Up - I
What was meant to be a leisurely stroll with my more-expensive half along the beachfront yesterday, turned into half an hour of soaking in the rain followed by about 2 hours of journey back home. While on the way back, I saw a man helping a blind old woman onto the train carriage. A few minutes into the journey, as the station approached, she began walking towards the exit door. Fearing that she could miss her step and hurt herself, I ...
Continue Reading

Comments     

Hide Error Value and Error Indicators in Excel

Posted on 26 June 2009

Hide Error Value and Error Indicators in Excel
To hide error value and error indicators in Excel you can use any of the following means: Hide error values using conditional formatting Hide errors indicators by turning off background error Hide error values by using IF(ISERROR()) function Hide error using a custom VBA function Let's take a closer look at each type of error handling method. Hide error values using conditional formatting Click on the cell that contains an error value. From the menu, select 'Format' -> 'Conditional Formatting'. ...
Continue Reading

Comments (3)

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

Posted on 25 June 2009

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 a control chart need not ...
Continue Reading

Comments (5)

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

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

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

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

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)



Translate

Chinese (Simplified)DutchEnglishFilipinoFrenchGermanHebrewHindiItalianJapanesePortugueseRussianSpanish

treeemap software for excel