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.
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.