Custom Style of a slicer in Excel
In this article you will learn how to create a Custom Style of a slicer in Excel. By using the custom style in Slicer you can make your slicer based
Blogs
Change% in Pivot Table
In this article you will learn how to show Change% in a pivot table. For example, you have month wise sales and revenue in your pivot and you have to
Ultimate Speedometer in Excel
Ultimate Speedometer is one of my favorite visual. This speedometer has been created in Excel with help of auto-shapes. We have not used any type of chart to create this.
Project Plan (Gantt Chart) in Excel
Crafting a Project Plan (Gantt Chart) in Excel can initially appear to be an intimidating task. This is particularly true for those who are not well-versed with the nuances of
A Stunning Chart to display the 5 KPI Metrics together
This is incredibly beautiful and stunning Chart to display multiple KPI Metrics together. In this example we have used 5 KPI metrics – Service Level, Quality Score, NPS, Sales Conversion
Quick Data Formatting by Personal Macro
In this article you will learn how to create a Personal Macro in MS Excel. I have created this personal macro to format the data Quick Data Formatting. Any macros
Employee Wise Deficit and Surplus Sales Chart
In this article you will learn how to create an Employee Wise Deficit and Surplus Sales Chart. This chart will give 2 types of analysis. This will give an employee
Conditional Formatting in Stylish Doughnut Chart
In my last post I have explained how to create stylish doughnut chart in Excel. I hope you has enjoyed that chart. Now in this article, you will learn how
Stylish Doughnut Charts in Excel
In this article you will learn how to create 4 stylish doughnut charts in Excel. These doughnut charts are used to display the KPI metrics or progress of a project.
Multilayered Doughnut Chart : Part-2
In this article you will learn how to create a beautiful Multilayered Doughnut Chart to display the team level performance. This chart can be used in business dashboard or presentation.