Teach MeShow MeLet Me TryPrint

Creating a Chart Using the Chart Wizard

A chart is a visual representation of data from your workbook. Charts add a visual element to your workbook and also help convey the information in a simple, easy to understand manner. The Chart Wizard in Excel walks you through the steps of converting the data in your workbook into a chart.

To use the Chart Wizard:

  1. Select the data you want to display in your chart.
  2. Click the Chart Wizard button on the Standard toolbar.
  3. Select the chart type and click Next.
  4. Select the data range for your chart and click Next.
  5. Add or modify the chart options and click Next.
  6. Place the chart, either in a new worksheet or in an existing worksheet.
  7. Click the Back button to go back to earlier screens in the wizard and make any adjustments you want.
  8. When you are satisfied with your chart, click Finish.

To open the Chart Wizard, you can also select Chart... from the Insert menu.