Rating Meter
Charts and Visualization

Rating Meter Chart in Excel

Rating meter is very innovative and informative chart to show the Process or Portfolio level health in five buckets – Worst, Bed, Average, Good and Best. We have calculated these buckets on the base below given table. [caption id="attachment_7173" align="aligncenter" width="221"] Bucket Calculation[/caption] Below is the snapshot of Rating Meter Chart. We also have displayed a small smiley symbol in the center of rating meter. Shape and color of this
Analog Clock
Charts and Visualization Excel Tips and Tricks

Analog Clock in Excel (Pie Chart + Doughnut Chart)

After creating the Digital Clock, we have created a beautiful Analog Clock. This stunning Analog Clock we have developed using Pie Chart and Doughnut Chart. To calculate the formula automatically, we have used below given code. Option Explicit Sub Start_Clock() Dim sh As Worksheet Set sh = ActiveSheet sh.Range("N1").Value = "Start" x: VBA.DoEvents If sh.Range("N1").Value = "Stop" Then Exit Sub Application.Calculate GoTo x End Sub Sub Stop_Clock() Dim sh As Worksheet
Stylish Butterfly Chart
Charts and Visualization

Stylish Butterfly Chart – Version 1

We are back with one more interesting chart that is Stylish Butterfly Chart (Version-1). This is useful for the comparison of two team on different KPIs. You can use this in your dashboard or presentation to make it eye catching. Below is the data points which we have used to create this chart. [caption id="attachment_7121" align="aligncenter" width="370"] Data Points[/caption]   Below is the Stylish Butterfly chart- [caption id="attachment_7122" align="aligncenter" width="622"]
Informative KPI Indicator V2
Charts and Visualization

Informative KPI Indicator Chart Version-2)

This is the 2nd version of Informative KPI Indicator Chart. In this chart I have used a RAG color pallet in 10 slices (10% each). Here I have taken Service Level metrics, you can take your own metrics. As soon as you will change the Service Level%, Indicator will be moved accordingly.  I also have taken the Target of service level. Whenever actual value will be less than the target
Informative KPI Indicator
Charts and Visualization

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 taken Service Level metrics, you can take your own metrics. As soon as you will change the Service Level%, Indicator will be moved accordingly. This chart is very useful to use in business dashboard or business presentations. [caption id="attachment_7103" align="aligncenter"
Focus Chart in Excel
Charts and Visualization

Innovation: Focus Chart in Excel

Focus chart has been created by my team to highlight the top performer on chart in very innovative way. Top performer will be focused with a hanging light. It is a dynamic chart as soon as the number will be changed in the table hanging light will be moved accordingly.   [caption id="attachment_7096" align="aligncenter" width="854"] Focus Chart in Excel[/caption] Below are data points of above given chart- [caption id="attachment_7095" align="aligncenter"
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
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.