XVIII. COMPUTER GRAPHING OF DATA

 

Graphs are the effective way to present information because they allow the viewer to absorb a lot of information quickly and see the whole picture in once.

Graphs can be created as chart sheets or they can be embedded in a worksheet. Sometimes you may want to place a graph on the same worksheet as the source data or to show only the portion of the data. That can easily be done by using Microsoft Exel, the ChartWizard tool.

 

EXERCISE # 1: CREATING YOUR OWN GRAPH

 

Suppose you have a worksheet with information. To add a graphic object to the worksheet do the following:

1.    Turn on the computer. Go to Microsoft Excel and enter the data you obtained in the experiment.

2.    Select the cells by clicking on the first or last cell and holding the button of the mouse drag the arrow over the cell's range you are interested in. Note: You don't have to select a cell within the data range to start a ChartWizard, but if you don't, you have to manually enter the data range later.

3.    Click on the Insert Chart.

When you release the mouse button, the ChartWizard Step 1 of 4 dialog box will be displayed. The dialog box for each step of the ChartWizard includes Cancel, Back, Next, and Finish buttons:

         Click on Cancel to stop the ChartWizard - no chart will be created.

         Click on Back to go back to the previous step.

         Click on Next to proceed to the next step.

         Click on Finish when you are done specifying the chart properties - the chart will be created immediately.

4.    Step 1 of the ChartWizard allows you to choose the chart type. Select the chart type you want and press Next button. For linear plots XY (scatter) is preferred.

5.    The ChartWizard Step 2 of 4 dialog box lets you specify the range of data you want to include in the chart.

         Check if Data Range specified is correct. If not, change it by typing a new reference or by selecting a different range.

         The Series tab allows you to add or remove the data series.

6.    When the range is correct, click on Next.

7.    The ChartWizard Step 3 of 4 dialog box lets you to choose the chart options. This step controls the placement of the chart elements; e.g. titles, gridlines, and data label or values.

         Insert chart title. In couple of seconds you may view the title appeared in the graph on the right.

         Insert the names of the axes. You may also view them to appear on the chart.

         Click on Gridlines on the top part of the dialog. Choose the pattern you need. Major gridlines are recommended.

         Click on Data Labels to add or remove labels and values to series the click on Next.

 

8.    In the ChartWizard Step 4 of 4, you specify the chart location: as embedded chart on worksheet or as chart sheet. Select As Object In and click on Finish to create the chart. Click directly on the graph to select it and pressing the left button move the graph to the particular position. Double click on the graph. The dialog box Format Plot Area will appear. Choose the background color and the style of the line.

9.    Repeat the steps 1-7, but in step 8 choose the option As New Sheet and click on Finish.

10.Turn off the computer when you are done with your graph.