Category Archives: Excel

NanoCharts add-in development

As I decided to develop the NanoCharts (a concept more known as Microcharts or Sparklines) into an Excel add-in I’ve started by specifying features and functionality and came up with the following list: Three different types of charts; bar, line … Continue reading

Popularity: 12% [?]

5 comments

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 1789 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 2442 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