Javascript Charting Library

Posted on 06 July 2009

A Javascript charting library is a compilation of javascript code which helps you create charts in a browser. Here's a list of 5 Javascript charting libraries that I had a chance to review : (Each of the Javascript charting libraries reviewed below would offer its own custom functions to interact with the chart object. If a chart fits your need, you may want to read the chart library's API documentation in greater detail. However, if you're short on development time, this ... Continue Reading

Comments     

Array Formulas in Excel - Excel Array Formula Syntax & Array Constants

Posted on 05 July 2009

Array Formulas in Excel An Array Formula in excel is a formula that uses arrays instead of single cell value as input. Excel Array Formulas can be thought of as many formulas packed into a single super formula. In this article we will take a look at the syntax of an array formula, its various parts, learn how to write a basic array formula and then graduate on to writing the more powerful versions of it. Before we begin, let ... Continue Reading

Comments (6)

COUNTIF Formula Excel - How to use Excel COUNTIF Function

Posted on 04 July 2009

Syntax of COUNTIF Formula Example of COUNTIF Formula Possible Errors returned by the COUNTIF Formula COUNTIF formula in Excel counts the numbers of cells in a range that meet the given condition. COUNTIF Formula Syntax COUNTIF Formula has two parts: COUNTIF (range, criteria) range range is the range in which the value that you are trying to find out is located. criteria criteria is the value whose occurence in the above range we would like to count. ... Continue Reading

Comments (2)

IF Formula Excel - How to use Excel IF Function

Posted on 04 July 2009

IF formula in Excel checks whether a given condition evaluates TRUE or FALSE. Syntax of IF Formula Example of IF Formula Possible Errors returned by the IF Formula IF Formula Syntax IF Formula has three parts: IF(criteria, value_when_true, value_when_false) criteria criteria is the condition that we would like to evaluate for being TRUE or FALSE. value_when_true value_when_true is the value that will be returned by the function when the above criteria evaluates to TRUE. This ... Continue Reading

Comments (3)

Javascript Get the Current Path without %20 and / backslash

Posted on 03 July 2009

To get the current path using javascript without the %20 and / (backslash), use the following code: [cc lang="vb"] var path = document.location.pathname; alert (path); [/cc] However using the javascript path variable in this manner gives something like this: So now we use the string replace function in Javascript to rectify this: [cc lang="vb"] var path = document.location.pathname; path = path.replace(/\//gi, ""); path = path.replace(/%20/gi, " "); path = path.replace(/\\/gi, "\/"); alert (path); var path = document.location.pathname; [/cc] This javascript code gives us the path ... Continue Reading

Comments     

How to Choose a Chart

Posted on 03 July 2009

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 make a choice in situations ... Continue Reading

Comments (8)