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 is of course undesirable since the data in series a isn’t even visible in the chart. Fortunately in Excel one is able to display data on a secondary y axis. Just select data series b, and right click. Select Format Data Series, the Axis tab and select Plot series on à Secondary axis (picture 2).
Picture 2.
Now data series a is associated with the primary and series b with the secondary axis. The problem is that the bars in the chart is overlapping and partially obscuring each other. This can be fixed by using a work-around according to the following steps:
Continue Reading »
Popularity: 4% [?]
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 step-by-step. Continue Reading »
Popularity: 11% [?]
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 want to quickly give the audience a idea on the spread of the data. My example are from the field of natural science, but the chart type is equally useful in other fields.
To create this type of box-plot chart we need four values from our data; the first and third quartile and the max and min values of the data set. Fortunately these functions are all included in Excel, so that makes our life a lot easier.
Continue Reading »
Popularity: 27% [?]
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. While Excel doesn´t have a built in step chart type one can use the x-y error bar function to work around this lacking feature.
Picture 1.
Picture 2.
Continue Reading »
Popularity: 8% [?]
Some time ago I wrote a script to automate disc defragmenting so that I could schedule it to late nights when no one is using the computer anyway. It turned out to be quite simple using VB scripting and Windows scheduler. Below you can see the commented script I use. You might need to make a couple of modifications if you have a localized copy of Windows (keyboard short-cuts and application names may be different).
Continue Reading »
Popularity: 5% [?]
