Sales Score meter Chart -V2
Charts and Visualization

Dynamic Sales Score Meter Chart

In this article, we have created a dynamic sales score meter chart. In this chart we have displayed the sales core on a speedometer chart. We have displayed the sales rating also as Worst, Bad, Average, Good and Best. To create this chart, we have used Pie and Doughnut chart combination.

We have create two different version of this chart. In the first chart we have used a form control combobox to select the employee name. In the chart we have displayed all 5 rating colors.

Sales Score meter Chart -V1
Sales Score meter Chart -V1

In the second chart, we have displayed a form control listbox to select the employee name. In the chart we have displayed only related rating slide.

Sales Score meter Chart -V2
Sales Score meter Chart -V2

Watch the step by step video tutorial:

Click here to download the practice file.

PK
My Name is PK. I am founder of PK-AnExcelExpert.com. I am a Microsoft Certified Professional. I have more than 10 years of experience in Data Visualization, Excel Automation and dashboard creation. Excel is my passion and I like to do always something innovative in Excel and share it with other people.
https://www.pk-anexcelexpert.com