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
Tag: KPI Chart
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
3D KPI Indicator in Excel
Several times we have to show the some indicator of our KPI metrics to indicate that particular metrics is in Red, Yellow or Green. 3D KPI Indicator in Excel Here
Info-graphics with Column chart (Part-2)
In this article you will learn how we can use info-graphics in the column chart for KPI metrics. We have created 4 different charts for Service Level. These charts can
Info-graphics with Line Chart
Line charts, as an efficient means of tracking and showcasing data trends over time, have become a go-to solution for visualizing metrics such as sales, revenue, and others. In this
RYG Dial Gauge Meter in MS Excel
RYG Dial Gauge Meter in MS Excel is very attractive and useful visual created by our team. This visual can be used to display the KPI metrics Like Service Level,
Conditional Formatting in Multiple Batteries Chart
Battery chart is a very nice visual to display a KPI metric. We can create the multiple batteries in a single chart. We can also use the conditional formatting in
Filling Circle Chart
Filling Circle Chart is very informative visual in excel created by our team. This chart can be used for a KPI Metrics like- Service Level, Quality Score, Sales Conversion etc.
Chart Templates in Excel
In this article you will learn how to save Chart Templates in Excel. You can save our favorite chart as a template reuse it or make company’s standard chart template.
Ultimate Speedometer in Excel
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.