I am back with a very innovative and Informative chart that is 3D Glass Chart in Excel. This chart can be used to display a KPI metrics like Service Level, Quality Score, Productivity etc. Here we have created this chart for Zone Wise Service Level. Below are the data points for which we will create this chart [caption id="attachment_8337" align="aligncenter" width="232"] Data Sets[/caption] Below are the steps to create this
This time we have developed an innovative and stunning Digital Clock in Excel. We have created this using Excel auto shapes and VBA. Click here to download this Excel workbook. Watch the step by step video tutorial:
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"
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
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"]
Our team has created this innovative visual to compare two team’s performances on multiple metrics. This is totally data driven charts and works like a Balance. There is a metric drop-down also available as a Form Control Combo Box. We can see the comparison of two teams for selected metrics. A small VBA code has been given written to rotate the shape according to the numbers. [caption id="attachment_3539" align="aligncenter" width="542"]
Ultimate Speedometer is one of my favorite visual. This speedometer has been created in Excel with help of auto-shapes. We have not used any type of chart to create this. To rotate the needle of speedometer, a small VBA code has been written in the change event on worksheet. [caption id="attachment_3553" align="aligncenter" width="1042"] Ultimate Speedometer in Excel[/caption] Click here to download the Ultimate Speedometer workbook. Watch step