The Sparklines category offers options to create line, column, or win/loss sparklines. The Quick Analysis tool allows you to create small, inline charts called sparklines that visually represent trends and patterns in your data. It automatically analyzes your data and suggests useful PivotTable configurations.
Once the pivot table is ready you can use suitable pivot chart for visual analysis of the data by clicking the PivotChart option. Use the Number Format option to reduce decimal places or altogether make it a whole number. The Tables tab offers various options for working with tables in Excel. You can choose to filter the data based on Year, Month, or Day. This category provides options to calculate common statistical measures for your data, such as sum, average, count, minimum, maximum, percentage total, and more. It recommends various chart types based on your data. This allows you to create various types of charts, including line charts, pie charts, clustered charts, and more. For example, you can highlight values above a certain threshold, identify duplicates, or emphasize data based on custom rules. You can apply conditional formatting rules to highlight cells based on specific criteria.
This category offers data bars, color scales, and icon sets. The Quick Analysis tool offers five (5) categories with different analysis options.
