Home>Blogs>Charts and Visualization>3D KPI Indicator in Excel
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:

Meet PK, the founder of PK-AnExcelExpert.com! With over 15 years of experience in Data Visualization, Excel Automation, and dashboard creation. PK is a Microsoft Certified Professional who has a passion for all things in Excel. PK loves to explore new and innovative ways to use Excel and is always eager to share his knowledge with others. With an eye for detail and a commitment to excellence, PK has become a go-to expert in the world of Excel. Whether you're looking to create stunning visualizations or streamline your workflow with automation, PK has the skills and expertise to help you succeed. Join the many satisfied clients who have benefited from PK's services and see how he can take your Excel skills to the next level!

Leave a Reply