Monthly Archives: June 2007

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

Step chart type in Excel

Keywords: Excel, step chart, delta x, delta y. Version: Excel 97 or later This article was originally posted on BloggPro.com. It is possible with Excel to create a graph showing for example Δx and Δy between datapoints, simply a step … Continue reading

Popularity: 8% [?]

1 comment