Note: The chart wizard was removed from Excel starting with version 2007. It has been replaced with charting options located under the insert tab of the ribbon
The quickest and easiest way to create a chart in Excel 2003 and earlier versions is to use the Chart Wizard.
The Chart Wizard is composed of a series of dialog boxes that give you all the available options for creating a chart.
The four dialog boxes or steps of the Chart Wizard
- Choosing the chart type such as pie chart, bar chart, or line chart.
- Selecting or verifying the data that will be used to create the chart.
- Adding titles to the chart and choosing various chart options such as adding labels and a legend.
- Deciding whether to put the chart on the same page as the data or on a separate sheet.