All articles with 'template' Tag

Introduction to Panel Charts using Excel – Tutorial & Template

Published on May 12, 2010 in Charts and Graphs, Featured
Introduction to Panel Charts using Excel – Tutorial & Template

In this article we will learn what a Panel Chart is and how you can construct a panel chart in Excel.
What is a Panel Chart?

A panel chart is a set of similar charts neatly aligned in panels to help us understand some data which has multiple variables in it. Panel charts are also called by names “trellis displays” or “small multiples”. They are an effective way to display multi-variable data.

Here is an example panel chart showing the total defects per module over the last 4 weeks.

Continue »

Free Excel Calendar Template for year 2009 (and all years up to 9999)

Published on Dec 4, 2008 in Featured, Learn Excel, personal
Free Excel Calendar Template for year 2009 (and all years up to 9999)

Free excel calendar template for year 2009 (well, it works for any year all the way up to 9999)

Go ahead and download it, change the year number in the first sheet to 1981 or something and see the magic.

Continue »