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
Tag: Dynamic Chart
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. [caption id="attachment_57797" align="alignnone"
KPI Dashboard with Tooltip in Excel
In this article, we have created Chart Tooltip in KPI Dashboard in Microsoft Excel. You can use this trick to show the details of a number with the chart. We
Cross Filter Functionality in Excel Chart
Excel is a powerful tool that provides a wide range of features to help you analyze and present data effectively. One of the most key features in Excel is the
Dynamic Comparison Analysis Chart in Excel
In this article, you will learn how to create a dynamic comparison Analysis Chart in Microsoft Excel. Using this chart you can compare one employee's performance with other. We have
Stylish and Dynamic Comparison Chart
In the article, we have created a stylish and dynamic comparison chart in Microsoft Excel. This chart can be used to compare the metric like -Sales, Revenue, profit, etc. between
Dynamic Filled map in Excel
In the article, You will learn how to create a dynamic filled map in Microsoft Excel. Filled Map is available with Office 365 subscription. You can display the Region, country,
Dynamic Spin Wheel in Excel
In this article, we have created a dynamic spin wheel in Excel. You can add or remove the name in spin wheel dynamically. You can change the rotation range, speed
Top/Bottom Analysis dashboard in Excel
In this article, we have created Top/Bottom Analysis dashboard using a sales dataset. This is a dynamic dashboard. We have used Slicers, Form control Option buttons and form control Scrollbar