M365 Excel - Instant charts using Quick Analysis

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

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.

   

3. Select Charts.

   

4. Hover over the chart types to preview a chart, and then select the chart you want.
5. Select More > All Charts to all available see all charts available. Preview and select OK when done to insert the chart.