Chart Table – When Chart meets 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 ...

Continue Reading

Chart Table - When Chart meets Table

Chart Label Trick : Applying Descriptive Labels to Chart Series

Posted on 12 September 2009

Chart Label Trick : Applying Descriptive Labels to Chart Series
Chart labels provide information related to the underlying data. In Excel, by default, chart labels can only consist of the following three - Series Name, Category Name and Chart X & Y Values. So what about situations when you want to convey additional information - for example, say a short description about the chain of events that had a material impact on sales (or say when you ...
Continue Reading

Comments (13)

Bar Chart with an Average Line for Each Group in Chart

Posted on 04 September 2009

Bar Chart with an Average Line for Each Group in Chart
In our previous article we covered adding an average line to a bar chart. At times, however, it may be useful to show an average line for each period or group when the chart consists of more than one such period or group. The advantage here is apparent - not only can the reader view the data points individually, he/she is also able to build a map of how various groups are placed with in relation to each other....
Continue Reading

Comments (1)

Bar Chart with Average Line

Posted on 24 August 2009

Bar Chart with Average Line
A Bar Chart is used to represent data using horizontal bars. One way in which you can augment a bar chart is to add an average line. Create a bar chart Create a bar chart in Excel using any particular data set at your disposal. In our case, we took the Forbes list of the richest people on earth (2009 figures). Here's how the data looks like. To create a bar chart, select ...
Continue Reading

Comments (7)

VBA Chart

Posted on 20 July 2009

VBA Chart
Making a chart using VBA can be easy. VBA provides a handle to a chart object using the "ChartObject" class and to the chart data series trough the "Series" class. Let's look at a basic example where we use VBA to create an empty chart to our spreadsheet and then add data to it. [cc lang="vb"] Sub CreateChart() Dim ChartObj As ChartObject Dim ChartSeries as Series Set ChartObj = ActiveSheet.ChartObjects.Add ( Left: = 100, Width: = 550, Top: = 75, Height: = 325) Set ...
Continue Reading

Comments (7)

Javascript Charting Library

Posted on 06 July 2009

Javascript Charting Library
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 (1)

How to Choose a Chart

Posted on 03 July 2009

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

Comments (8)

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)

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

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     

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)

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)

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)

How to create a Gantt Chart in Excel

Posted on 07 May 2009

How to create a Gantt Chart in Excel
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 ...
Continue Reading

Comments (8)

How to Create a Pareto Chart in Excel

Posted on 05 May 2009

How to Create a Pareto Chart in Excel
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 ...
Continue Reading

Comments (11)

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

Posted on 04 May 2009

How to create an Excel Flow Chart - (Template and Software)
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 ...
Continue Reading

Comments (4)

Excel Waterfall Chart Template with Negative Values

Posted on 16 April 2009

Excel Waterfall Chart Template with Negative Values
If all you need to do is to get a copy of the Excel Waterfall Chart Template with Negative Values then you can simply download it here. For those interested in knowing how to create a waterfall chart in excel, please read on. How do I create a waterfall chart in excel? There are two ways to create a waterfall chart in Excel. The first is to simply lay out a grid ...
Continue Reading

Comments (29)

Create Chart using Named Range in Excel

Posted on 31 March 2009

Create Chart using Named Range in Excel
Creating a chart that uses a named range is excel can be accomplished by following these basic steps. Before we begin, let us first look at the building blocks. What is a named range? A named range is a group of cells that have explicitly been given a name. Every time you refer to that name, the workbook automatically knows that the user is referring a collection of cells that name represents. You can assign ...
Continue Reading

Comments (14)

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