3D KPI Indicator
Charts and Visualization

3D KPI Indicator in Excel

Several times we have to show the some indicator of our KPI metrics to indicate that particular metrics is in Red, Yellow or Green.

Here we have created a 3D indicator with 3 solid balls. Below is the logic to change balls color-

Color Codes
Color Codes

Data of KPI metrics (Service Level) is coming from another worksheet.

Service Level Data
Service Level Data

 

If we will change the date, Service Value will be updated automatically and color of text and indicator will be changed.

For Red color indicator will look like below color-

Indicator for Red Color
Indicator for Red Color

 

For Yellow color indicator will look like below color-

Indicator in Yellow color
Indicator for Yellow color

For Green color indicator will look like below color-

Indicator for Green color
Indicator for Green color

 

Click here to download Excel Template

 

Watch the step by step Video tutorial:

PK
My Name is PK. I am founder of PK-AnExcelExpert.com. 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

Leave a Reply

Your email address will not be published. Required fields are marked *