VBA: Multilevel dependent drop-down in User Form
While creating the data entry form in VBA, we need to put several validations. One of them is dependent drop-down. In this article you will learn how to create multilevel
Blogs
Slide Meter Chart (Version-3)
This is the version-3 of Slide Meter Chart. In the Slide Meter Chart (Version-1), we displayed the KPI metric performance with solid bar. In the Slide Meter Chart (Version-2), we
Slide Meter Chart (Version-2)
This is the version-2 of Slide Meter Chart. In the (Version-1), we displayed the KPI metric performance with solid bar but in this version-2, we have displayed the KPI metric
Slide Meter Chart – Version 1
Slide Meter Chart is very useful and eye catching chart to show the KPI metrics performance. This chart has been designed with the help of Column Chart, Line Chart and
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
Highlight the Specific data point in a Line Chart Dynamically
In this chart we have explained how to Highlight the Specific data point in a Line Chart Dynamically. You can highlight the Minimum, Maximum and Selected data points in a
Info-graphics: Animated Hour Glass Chart in Excel
Animated Hour Glass Chart in Excel has been designed to display the KPI metrics like – Service Level, Quality Score, and Productivity etc. Whenever the value of metric will be
An Innovative chart for team level performance
This innovative and eye-catching chart, we have created a chart for team level performance using Line with Marker chart. In this chart we have displayed seven teams and their performance.
VBA: User form Validation for Mobile Number input
While create the Data Entry form in VBA, We need to put some validation in text boxes and combo boxes. In this article you will how we can put the
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