Author Archives: Jesper

NanoCharts enables Excel In-Cell charts with Sparklines concept

Keywords: Sparklines, MicroCharts, NanoCharts, In-cell graphing, mini charts, Excel Version: Tested on Excel 2003 Download: NanoCharts demo (downloaded 1867 times) Sparklines, or Micro charts, a concept invented by graphic design guru Edward Tufte , compress large amounts of data into … Continue reading

Popularity: 11% [?]

4 comments

Interpolate empty cells in Excel line charts

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 … Continue reading

Popularity: 16% [?]

5 comments

Automatically calculate confidence intervals in Excel

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 … Continue reading

Popularity: 34% [?]

8 comments

Add new colors to the default Excel palette

Keywords: Excel, color palette, customize, modify, alternative colors. Version: Excel 97 or later Download: Palette tool (downloaded 2637 times) One of the drawbacks in Excel is the very limited built-in color palette. When doing presentations and reports I often wish … Continue reading

Popularity: 20% [?]

3 comments

Improved advanced box-plot and whiskers chart in Excel

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, … Continue reading

Popularity: 8% [?]

8 comments