Stylish Circle Chart has been designed to display the KPI metric. It can make your dashboard more attractive. We have used Pie Chart and Oval shape to create this Chart. [caption id="attachment_11019" align="aligncenter" width="700"] Stylish Circle Chart[/caption] Click here to download this Chart
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 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 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
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
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
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
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
