Using the Chart Wizard in Excel

If you need to create a different "picture" of your spreadsheet information, you can put it in a chart. Excel has a really neat Chart Wizard to help you select which data you want to chart in what ever type of chart you want. Often, a chart can communicate much more effectively than a table full of numbers.

---

How To Use the Chart Wizard:

1. Select the data you want to include in the chart.
   • The data should include all the values you want included in the chart as well as any labels that identify those values.
2. Click the Chart Wizard button to display the first of four Chart Wizard dialog boxes.
   • At any point in the Wizard, you can click Back to return to the previous step.
3. Select a chart type, and click Next.
   • You can view a sample of what your chart will look like by pressing and holding the View Sample button.
4. In the second Chart Wizard dialog box, you can select a data range for the chart.
   • If you selected a range before clicking the Chart Wizard button, this will not be necessary.
   • You can also specify whether the data in the selected range should be interpreted by rows or by columns.
5. When finished, click Next.
6. In the third Chart Wizard dialog box, you can add a title and labels for various parts of the chart. When finished, click Next.
   • You can also set such things as Axes labels, which gridlines you want displays, placement and content of the legend and various labels for data, etc.
7. In the final Chart Wizard dialog box, you specify whether you want to create a separate chart sheet, or embed the chart as an object in a worksheet.
8. When you are satisfied with all your choices, click Finish to create the chart.