Category Archives: 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% [?]

Version: Tested with Excel 2003 Keywords: in-cell graph, in-cell chart, text chart graph In-cell graphs are built in Excel 2007, but these are notorously hard to read and actually does more to confuse the reciever than anything else. There are … Continue reading →

Popularity: 3% [?]

 Version: Tested on Excel 2003. Keywords: Excel, data points, custom images, change default It is surprisingly easy to change the somewhat boring, default data points in excel to something more of your own taste and imagination. Here’s how to do it: 1. Create … Continue reading →

Popularity: 2% [?]

Keywords: cell formatting, two values in one cell, average value, confidence interval Version: Should work in any Excel version from Excel 97 and forward. Sometimes it is useful to have the output from your excel sheets arranged in such a … Continue reading →

Popularity: 5% [?]

Keywords: Excel automation, VB controls, scrollbars Version: Excel 97 or later Let have a look at the VB controls in Excel. They can be quite handy when creating user oriented spreadsheets, or when building models to study relationships between parameters. … Continue reading →

Popularity: 3% [?]