D.1 The Excel Spreadsheet Window

Figure D.1 shows the Excel spreadsheet workspace and identifies the different parts of the Excel window when we first start Excel.

Figure D.1: The Excel Spreadsheet Workspace

Figure D.2 shows that whenever a chart is selected, as shown by the visible handles around the selected chart, the Chart drop menu appears on the Menu bar and that the Chart toolbar now is visible. We can now use the Chart Objects Edit Box and Format Chart Area tools to edit our chart.

Figure D-2: The Excel Spreadsheet with Chart selected

D.2 Instructions for Constructing Semilog Plots

1. Start with a blank spreadsheet as shown in Figure D.1.

2. Click on ChartWizard.

3. Click on the X-Y (Scatter) Chart type under the Standard Types tab on the ChartWizard menu.

4. The Chart sub-type shows five different sub-types. Click on the upper right (the one showing two continuous curves without square points.)

5. Click on Next, Series tab, Add, Next.

6. Click on Gridlines tab and click on all square boxes under Value X-axis and Value Y-axis to place check marks on Major and Minor gridlines.

7. Click on Next, Finish, click on the Series 1 box to select it, and press the Delete key on the keyboard to delete it.