Analyze your data instantly

Choose your chart using Quick Analysis

Quick Analysis takes a range of data and helps you pick the perfect chart with just a few commands. 

Your browser does not support video.
  1. Select a range of cells.

  2. Select the Quick Analysis button that appears at the bottom right corner of the selected data.

    Or, press Ctrl + Q.

    Quick Analysis

  3. Select Charts.


  4. 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.

Need more help?

Expand your Office skills
Explore training
Get new features first
Join Office Insiders

Was this information helpful?