The button appears at the bottom right corner of the selected range.īased on the type of selected data, you’ll see the most recommended chart types with previews. Select the data range, then click Charts on the floating toolbar. Inserting charts using Quick Analysis Tool Go to the Home Tab and click on the ribbon. That is all we require! Let us assume that you prefer the common way to use all of the conditional formatting features. Data Bars, color-based highlighting, icons sets.The Quick Analysis Tools provides the most used functions: We get a quick live preview and select the option you want. The key differences between QAT and regular methods: If you want to learn all about conditional formatting, we strongly recommend our definitive guide.
Now let us see how to apply conditional formatting using QAT. Formatting Ranges using Quick Analysis Tool You can choose from the following tools: Formatting, Charts, Totals, Tables, and sparklines. If you like using Excel shortcuts, apply the Ctrl + Q combination.Ĭlick the Quick Analysis button on the bottom-right corner of the range. From now the QAT toolbar will appear by default. Check Show Quick Analysis options on selection. You can choose two methods to activate the tool.
How to turn on the Quick Analysis feature?