![Your browser does not support video. Install Microsoft Silverlight, Adobe Flash Player, or Internet Explorer 9.](https://cxcs.microsoft.net/static/public/surface-and-devices/neutral/4873755a-8b1e-497e-bc54-101d1e75d3e7/d07c07fd6aabfe12ed716e87301dc3a1a3a7b5b0.png)
Try it!
Excel's Quick Analysis button lets you instantly create different types of charts, including line and column charts, or add miniature graphs called sparklines.
-
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.