Analyze your data instantly Select a range of cells. Select the Quick Analysis button that appears at the bottom right corner of the selected data. Or, press Ctrl + Q. Select Charts. Hover over the chart types to preview a chart, and then select the chart you want. Source: Microsoft