Select the data for the chart.2. Click the Quick Analysis Tool button.3. Click the Charts tab, and then click the More Charts button to open the Insert Chart dialog. You can also open the Insert Chart dialog from the Insert tab, Charts group, by clicking the Recommended Charts button.4. The first tab in the Insert Chart dialog, Recommended Charts, displays the same chart options as the Charts tab in the Quick Analysis tool, plus a few more. When you select a chart type, a preview of the chart appears in the right pane of the dialog.5. Click OK to insert the selected chart into the worksheet.