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
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
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 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
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 month Service Level and Target has been connected from and Excel cell. It can be easily analyzed that which months are not meeting the target. This is a dynamic chart, if we will change the target value then Red and
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 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 =
This innovative and eye catching chart, we have created using Line with Marker chart. In this chart we have displayed 7 teams and their performance. Below is the team wise Performance Score table. [caption id="attachment_6954" align="aligncenter" width="251"] Team Wise Performance Score[/caption] This Chart can be used in Business Dashboards or Presentations. Click here to download this Excel workbook. Watch the step by step video tutorial:
Several times we have to show the some indicator of our KPI metrics to indicate that particular metrics is in Red, Yellow or Green. Here we have created a 3D indicator with 3 solid balls. Below is the logic to change balls color- [caption id="attachment_4113" align="aligncenter" width="247"] Color Codes[/caption] Data of KPI metrics (Service Level) is coming from another worksheet. [caption id="attachment_4114" align="aligncenter" width="279"] Service Level Data[/caption] If we
Today I have come with a beautiful Filling Stacked Column Chart. In this chart I have showcased day wise Sales Conversion. There are 5 circles for 100% each for 20%. If the sales conversion value will be 20% then 1 circle will be filled and if Service Level value is 50% then 2 and half circle will be filled. Below is the day wise sales conversion- [caption id="attachment_4063" align="aligncenter" width="256"]
