How to Create Charts via the Quick Analysis Tool in Excel 2013
Click the Charts tab at the top of the Quick Analysis options palette.
Excel selects the Charts tab and displays chart option buttons. The first five buttons preview how the selected data in a different type of chart will look. The More Charts button opens the Insert Chart dialog box with the Recommended Charts tab selected. Here you can preview and select from an even wider range of chart types.