Browsing the blog archives for October, 2007
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 1871 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% [?]
