Objectives:

1. Use ChartWizard to create a chart in an Excel worksheet

Open an existing worksheet

If your worksheet is not open,

1. Choose File/Open.

The Open dialog box appears.

1. Select the appropriate drive, folder, and filename.
2. Click OK.

Top of Page

Inserting a Chart into your sheet.

Your sheet will look like the one illustrated below when you complete this activity.

1. Click the ChartWizard button.



The cursor will turn into cross-hairs with the ChartWizard icon attached.

2. Draw a chart area below the data by clicking and dragging from the upper-left corner of chart area to lower right-corner of chart area.

The first of several ChartWizard boxes appears.



3. Select the data to graph and labeling information.

In the example, this is the RANGE A2 through M4.

4. Click Next.

Now you see next ChartWizard box.

5. Select Line.
6. Click Next.

Now you see next ChartWizard box.

7. Select Option 10.
8. Click Next

Now you see next ChartWizard box.



9. Click Next.

The final ChartWizard box appears.



10. Make sure Add a Legend? is selected.
11. Type a Title for your chart.
12. Click Finish.
13. Re-size and Move the chart if necessary.

Save your worksheet

Top of Page

Copyright - Technology Training Team

Please contact us at TechTrainTeam