Quick Male-Female and Waffle Chart in Excel
In this article, we have created two Waffle charts and a Male/Female infographic chart. To create the waffle charts, we used the SEQUENCE function. You can use these chart in
Charts and Visualization
In this category, you will find comprehensive tutorials on creating stunning charts and visualizations in Excel. Impress your colleagues and boss with attractive and informative visuals by following our step-by-step guides. Each tutorial comes with a free practice file for download and tutorial videos to help you understand the process. Explore this category now and enhance your data analysis and presentation skills with Excel.
Weightage Analysis Template in Microsoft Excel
In this article, you will learn how to use Weightage Analysis Template in Microsoft Excel. Weightage Analysis is used to get the Weightage Score calculation based on different parameters. In
Quick Analysis Tool in Microsoft Excel
Quick Analysis Tool is used to apply the quick conditional formatting, Quick Charts, add Totals, Quick Pivot Tables and to add quick Sparklines in selected data. Quick Analysis Tool in
Multi-color Data bar with REPT function
In this article, we have created multi-color Data bar with REPT function in Excel. We have used the conditional formatting to change the color based on certain criteria. Multi-color Data
Find Top Employee with FILTER and RANK Function
In this article, we have explained how to find top selected employee with the help of FILTER and RANK Function. You will also learn the SORT and OFFSET Function. We
Process Circle Chart in Excel 2010
We were not able to create Process Circle Chart in Excel 2010 due to Secondary Axis option is not available in doughnut chart. Here we have used a trick to
Dynamic Graph with Camera
In this article, we have created a dynamic graph with Camera functionality of Excel. We have used conditional formatting in Chart. You can change the chart type using Form Control
Conditional formatting in Excel Chart
In this article, you will learn how to use Conditional formatting in Excel Chart. You can use this trick to show to Target Vs Actual number. Conditional formatting in Excel
Sales Analysis Heat Map by Time and Day
In this article, we have created a dynamic Sales Analysis Heat Map by Time and Day. Using this analysis, you will get to know your most busy time in a
Beer Mug Graph in excel
Beer mug chart is a beautiful infographic representation for KPI metrics in percentage like - Target Achieved%, Service Level%, Quality Score etc. Beer Mug Graph in excel [caption id="attachment_56543"