Excel’s Quick Analysis button allows you to instantly produce various kinds of charts, such as line and column charts, or insert tiny graphs called sparklines.
- Choose a range of cells.
- Click the Quick Analysis button that emerges at the bottom right corner of the highlighted data. Or, press Ctrl + Q.
- Pick Charts.
- Hover over the chart types to glance at a chart, and then press your desired chart.