How to Use a Chart Wizard in MS Excel 2007

1. Open the Excel workbook with the data that you wish to chart.
2. Select all the cells containing the relevant data. Press 'CTRL' and 'A' to select them all.
3. Select 'Chart' from the Insert menu. This will open the Chart Wizard.
4. Select a chart type under 'Standard Types.' If you are unsure how a specific chart will represent your data, click it to view a preview. Click 'Next' when you are done.
5. Confirm the data range to include in your chart. The information is already filled in to show the cells you selected in Step 2, but you can switch around the order in which your spreadsheet's rows or columns appear on the final chart. Click 'Next' when you are done.
6. Choose from the wide range of chart options in the next window. They are divided into six tabs: Titles, Axes, Gridlines, Legend, Data Labels and Data Table. If you have the 'Preview' box checked on these pages, you can see what various options will look like. Note that users trying to create basic charts can leave these options at their default settings; they can be changed later if need be. Click 'Next' when you are done.
7. Choose whether to place your chart in the existing workbook or to create a new document. Click 'Finish' when you are done.