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

1 comment

Automated and scheduled HD defragmenting

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

Leave a comment