Analyze your data instantly
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.
Need more help?
You can always ask an expert in the Excel Tech Community, get support in the Answers community, or suggest a new feature or improvement on Excel User Voice.