Keywords: Sparklines, MicroCharts, NanoCharts, In-cell graphing, mini charts, Excel
Version: Tested on Excel 2003
Download: NanoCharts demo (downloaded 2221 times)
Sparklines, or Micro charts, a concept invented by graphic design guru Edward Tufte , compress large amounts of data into intense, word-sized graphics, like for example:
Popularity: 11% [?]
Key words: Excel, interpolate missing data, line chart, skip empty cells
Versions: Excel 2003, 2002 and 2000
When you create a Line chart in Microsoft Excel, from data containing blanks cells you will notice that the line graph contains gaps for the missing data. Sometimes you may wish to plot missing data as interpolated and this can be achieved in two ways.
Method 1
In this method you tell Excel to plot empty cells as interpolated.by following these steps:
Popularity: 16% [?]
Keywords: confidence intervals, confidence levels, macro, function, excel, how to
Version: Excel 97 or later
Download:
In excel there are no native function for calculating confidence interval (CI) a function called CONFIDENCE to calculate the confidence interval, but it works slightly different from the custom confidence function I present here.
Since I need to do this calculation on a regular basis i decided to simplify this work by writing a VB function that will automatically calculate the confidence interval in Excel for a given range of values and confidence level (CL) between 1-99%. It will also present the output in a format that is suitable to copy and paste directly into reports and result sheets. There are many excellent sites that cover the theory behind CI, so I won’t repeat it here.
Popularity: 34% [?]
Keywords: Excel, color palette, customize, modify, alternative colors.
Version: Excel 97 or later
Download: Palette tool (downloaded 3509 times)
One of the drawbacks in Excel is the very limited built-in color palette. When doing presentations and reports I often wish to use colors different than the standard offer to create visually more appealing graphs that blend in with the rest of the lay out.
The good news is that it is possible to change the standard palette to user defined colors, but doing so either involves VB scripting and can seem quite distracting to the average user, or tedious clicking as you change colours one-by-one via the standard Excel menues. Running the following command in the VB editor would chance the color of the first swatch to red:
Popularity: 20% [?]
Keywords: Excel, box-plot,box plot, median, whiskers, percentile chart.
Version: Excel 97 or later
Dowload:
Due to the popularity of the Box-plot and whiskers chart in Excel article published some time ago I decided to revise the article with a new, improved way of creating box-plot charts containing more information. The approac is slightly different as you will see in the following step by step instruction.
Popularity: 8% [?]