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
Ring Chart in Excel
Charts and Visualization

Ring Chart in Excel

Ring Chart is very beautiful and attractive visual in MS Excel. This chart has been designed by me and my team. Ring chart is basically a doughnut chart and we have given the ring shape to this doughnut by using and Excel auto shapes. This beautiful visual can be used in business dashboard, presentation or reports. You can use this chart to display the sales bifurcation.   [caption id="attachment_3798" align="aligncenter"
Filling Circle Chart
Charts and Visualization

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. Filled are of the circle shows the metric performance. To create this chart, we have taken the support of power point presentation to merge the shape and column chart in excel. This is totally data driven chart and will be
Charts and Visualization

Conditional Formatting in Stylish Doughnut Chart

In my last post I have explained how to create stylish doughnut chart in Excel. I hope you has enjoyed that chart. Now in this article, you will learn how to put Conditional Formatting in Stylish Doughnut Chart. When we will change our KPI value, Color and stylish of the doughnut chart will be changed automatically. Let's say we have below data to put the conditional formatting in stylish doughnut
Charts and Visualization

Stylish Doughnut Charts in Excel

In this article you will learn how to create 4 stylish doughnut charts in Excel. These doughnut charts are used to display the KPI metrics or progress of a project. Stylish Doughnuts can be used to in business dashboard or business presentation. Below are the steps to create stylish doughnut charts in Excel- Doughnut Chart-1: Let's say we have a KPI metric on cell D1 and its performance value on
Multilayered Doughnut Chart-Part1
Charts and Visualization

Multilayered Doughnut Chart : Part-1

In this article you will learn how to create a beautiful multilayered Doughnut Chart for KPI metrics. In this chart we can display 3 or 4 KPI metrics at a time. This chart can be used in business presentations or dashboards. Below is the data set for which we will create multilayered Doughnut Chart. [caption id="attachment_3257" align="aligncenter" width="228"] Metrics data set[/caption] Below are the steps to create the multilayered Doughnut
RAG Conditional formatting in Progress Circle Chart
Charts and Visualization

RAG Conditional Formatting in Progress Circle Chart

In this article you will learn how to put RAG (Red, Amber and Green) conditional formatting in Progress Circle Chart in Excel. Progress Circle Chart is a beautiful circle chart which can be used to display KPI metrics. Color of the  Progress Circle chart will be changed as Red, Amber and Green according to the value of metric. Below is the screenshot of Service Level value and color range for