Browsing the archives for the Excel category
Keywords: Sparklines, MicroCharts, NanoCharts, In-cell graphing, mini charts, Excel
Version: Tested on Excel 2003
Download: NanoCharts demo (downloaded 1539 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% [?]
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 [...]
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 [...]
Popularity: 35% [?]
Keywords: Excel, color palette, customize, modify, alternative colors.
Version: Excel 97 or later
Download: Palette tool (downloaded 1975 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 [...]
Popularity: 23% [?]
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 [...]
Popularity: 9% [?]
