Conditional Formatting in a Line Chart
Using Conditional Formatting in a Line chart is very nice idea. This chart is very useful to show the trends of the data. Here we have showcased the month on
Tag: Conditional Formatting
Highlight Top and Bottom Performer using conditional formatting
In this article you will learn how to use Conditional Formatting to Highlight Top and Bottom performer on the base of performance score. Top performer has been highlighted in green
3D KPI Indicator in Excel
Several times we have to show the some indicator of our KPI metrics to indicate that particular metrics is in Red, Yellow or Green. 3D KPI Indicator in Excel Here
Excel Template with Protection and Validation
We often required an Excel Template to send some persons or teams so that they can enter the data in the template and can sent it to us and then
Conditional Formatting in Multiple Batteries Chart
Battery chart is a very nice visual to display a KPI metric. We can create the multiple batteries in a single chart. We can also use the conditional formatting in
Traffic Lights in MS Excel
Creating the Traffic lights in excel is genuinely nice idea to show the Performance Indicator. We have created this traffic light by using auto shapes then connected it with the
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
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
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
Dynamic Calendar in Excel
The dynamic calendar template is a must-have for keeping track of important dates and appointments. It's easy to change the month and year and the calendar updates automatically. Form Control