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 up in for example Windows Explorer.
1. Go to the Start menu and open the Control Panel, Administrative tools, Computer Management and then Disk Management.
2. Select the new hard drive which should appear (see picture below)
Popularity: 3% [?]
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. In this article we will look at a simple scrollbar control.
1. For the purpose of this tutorial, create a new spreadsheet and in cell B4 enter “Level”, in cell C3 and D3 enter “A” and “B” respectively.
Picture 1
Popularity: 3% [?]
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:
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.
UPDATE 2: This method is largely outdated, please see the latest entry about box plot and whiskers chart in Excel 2010.
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.
Popularity: 27% [?]