Dynamic Chart on User Form
Charts and Visualization VBA

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 a User form which is fully dynamic. KPI value is connected with a Textbox. As soon as the text box value will be changed chart will show the updated number. We have also given the Change chart type drop-down. KPI
Web browser in User form
VBA

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. [caption id="attachment_7077" align="aligncenter" width="1310"] Web Browser in User form[/caption]   Below are the steps to create the web browser in the user form- Go to the Visual basic editor (Press Alt+F11) Open the Toolbox. [caption id="attachment_7069" align="aligncenter" width="604"] Open the Toolbox[/caption]  
Fill Blanks
Excel Tips and Tricks

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 the blanks in our data. Below is the data in which blanks cells have to be filled: [caption id="attachment_7049" align="aligncenter" width="507"] Data Sets[/caption]  We can fill the blanks using 4 differed tricks. 1-Using Filter: We can fill the blanks using
Dependent Drop-Down in VBA User Form
VBA

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 dependent drop-down in VBA user form. To create the dependent drop-down list, we have to create the data in Excel sheet as given in below image.   [caption id="attachment_7034" align="aligncenter" width="773"] Data for dependent drop-down[/caption]   Below is the VBA
Slide Meter Chart (Ver-3)
Charts and Visualization

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 displayed the KPI metric performance with semi filled bar. Now in this version of Slide Meter we have put the conditional formatting. If the value of Service Level will be less than target then it will be in Red otherwise
Slide Meter Chart (Ver-2)
Charts and Visualization

Slide Meter Chart (Version-2)

This is the version-2 of Slide Meter Chart. In the Slide Meter Chart (Version-1), we displayed the KPI metric performance with solid bar but in this version-2, we have displayed the KPI metric performance with semi filled bar.  This is a very eye catching chart and can be used in the business dashboard. [caption id="attachment_7022" align="aligncenter" width="856"] Slide Meter Chart (Ver-2)[/caption]    Click here to download this Excel workbook.  
Slide Meter Chart
Charts and Visualization

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 Auto shapes. Below is the data points which has been used to create this beautiful chart- [caption id="attachment_7009" align="aligncenter" width="232"] Data Point for Slider Meter Chart[/caption]   Below is the Slide Meter Chart (Ver-1). [caption id="attachment_7011" align="aligncenter" width="674"] Slide Meter
Highlight the data point
Charts and Visualization

Highlight the Specific data point in a Line Chart Dynamically

In this chart we have highlight the Minimum, Maximum and Selected data points in a beautiful line chart. This chart can be used in Business Dashboard or Presentation. Below is the snapshot to highlight the Minimum data point [caption id="attachment_6991" align="aligncenter" width="943"] Highlight the Minimum data point[/caption]    Below is the snapshot to highlight the Maximum data point [caption id="attachment_6994" align="aligncenter" width="950"] Highlight maximum data point[/caption] Below is the snapshot
Animated Hour Glass Chart
Charts and Visualization

Info-graphics: Animated Hour Glass Chart in Excel

Animated Hour Glass Chart has been designed to display the KPI metrics like – Service Level, Quality Score, and Productivity etc. Whenever the value of metric will be changes it will show an animation like below given image.       We have put the below given code on Worksheet Change event to show the animation Option Explicit Private Sub Worksheet_Change(ByVal Target As Range) Dim i As Integer If Target.Address =