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.


  • The Chart Options part of the wizard allows you to add titles, legends, labels, and other information to your chart.
  • You can create a chart on its own or as part of a worksheet. To place a chart in its own worksheet, click the As new sheet in: option in the Chart Wizard.

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