Multiple KPI Visualization
Charts and Visualization

Multiple KPIs Visualization in Excel

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.

We have displayed below given sample KPIs on the visualization –

Sample KPIs
Sample KPIs

We have used color code as per below given conditions.

Color conditions
Color conditions

Below is the snapshot of below given visualization –

Multiple KPI Visualization
Multiple KPI Visualization

Click here to download the Practice file-

Watch the step by step video tutorial:

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