We have created an attractive visualization to display multiple KPI performance in Excel. We have used Excel auto shapes to create this visualization. RAG (Red, Amber, and Green) color changes dynamically to display the KPI performance. This visualization can be used for any type of KPI data type like – Numbers, percentages or decimals etc.
10 Jul 2019
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
In this article, we have created a Pivot Chart to display the department wise employees count by different age groups.