Browsing the blog archives for June, 2007
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 bar chart option in Excel you might then get something like in picture 1 below.
Picture 1.
This [...]
Popularity: 3% [?]
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 looking document that is easy to navigate for the reader. We will work the example through [...]
Popularity: 10% [?]
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.
In this tutorial I will describe how to create neat looking box-plot graphs with whiskers in Excel. This chart type is particularly useful when presenting data series representing many replicate samples and you [...]
Popularity: 26% [?]
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 chart according to picture 1 and 2 below. Doing this is easier than it might first seem. [...]
Popularity: 7% [?]
