TABLE OF CONTENTS This appendix contains instructions for constructing semilog plots with the Microsoft Excel spreadsheet. Semilog, short for semilogarithmic, paper is graph paper having one logarithmic and one linear scale. It is used in many scientific and engineering applications including frequency response illustrations and Bode Plots.
Figure I.1 shows the Excel spreadsheet workspace and identifies the different parts of the Excel window when we first start Excel.
Figure I.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.
Begin with a blank spreadsheet as shown in Figure I.1.
Click Chart Wizard
Click X-Y (Scatter) Chart type under the Standard Types tab on the Chart Wizard menu.
The Chart sub-type shows five different sub-types. Click the upper right (the one showing two continuous curves without square points.)
Click Next, Series tab, Add, Next.
Click Gridlines tab and click all square boxes under Value X-axis and Value Y-axis to place check marks on Major and Minor gridlines.
Click Next, Finish, click Series 1 box to select it, and press the Delete
