Author Archives: Jesper

Installing an external USB Hard Drive in Windows XP

When you buy an external HD casing and a new hard drive you will notice after assembling drive and casing that it’s not quite plug n’ play, but initialization and formatting is neede to make it work properly and show … Continue reading

Popularity: 3% [?]

Comments Off

Introduction to basic VB controls in Excel

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

Comments Off

Non-overlapping bar-chart on two axis

Keywords: Excel, bar-chart, secondary axis, differing data sets, non-overlapping bar chart. Version: Excel 97 or later Sometimes you might want to display two data series that differ greatly in value in the same bar chart. If you use the default … Continue reading

Popularity: 4% [?]

Comments Off

Dynamic text fields in Word header

Version: Should work at least with any version from Office 97 and forward. In this article I’m going to show you how to get dynamically updated section or chapter headers in Word. This will allow you to create a nice … Continue reading

Popularity: 11% [?]

15 comments

Box-plot and whiskers chart in Excel

Keywords: Excel, box-plot,box plot, whiskers, quartile chart. Version: Excel 97 or later UPDATE: See also the Improved advanced box-plot and whiskers chart in Excel. UPDATE 2: This method is largely outdated, please see the latest entry about box plot and … Continue reading

Popularity: 27% [?]

13 comments