Informative KPI Indicator Chart (Version-1)
I am back with one more stunning and Informative KPI Indicator Chart. In this chart I have used a RAG color pallet in 10 slices (10% each). Here I have
Blogs
Innovation: Focus Chart in Excel
Focus chart has been created by my team to highlight the top performer on chart in Excel in very innovative way. Top performer will be focused with a hanging light.
VBA: Dynamic Chart on User Form
Creating the Chart on a VBA user form is quite interesting. We have created 4 KPI Charts – Battery Chart, Speedometer Chart, Moving Man Chart and Progress Circle Chart on
VBA: Web browser in the User Form
In this article you will learn how to use a web browser in the user form. You can search anything or open a website using the text box VBA: Web
Excel Tip : Fill the blanks cells in your data
Many times we have zig-zag data which has to be formatted in proper manner to create some report or dashboard. In this article you will learn how we can Fill
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
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