Home>Blogs>Charts and Visualization>Multicolor Filling Bars in Excel Cells Without using Chart
Dynamic Data Bar
Charts and Visualization

Multicolor Filling Bars in Excel Cells Without using Chart

In the article, you will learn how to create Multicolor Filling Bars in Excel Cells without using Chart. You can use such visualization to display the project completion status with red color for delayed and green color for on time. Or you can use this trick to show the service level or Quality score with Red, Amber, and Green color with filling bars.

See our Project Management Dashboard

Multicolor Filling Bars in Excel Cells Without using Chart

Dynamic Data bars for Project Completion Status
Dynamic Data bars for Project Completion Status

Dynamic Data bars for Service Level with RAG-

Dynamic Data bars for Service Level with RAG
Dynamic Data bars for Service Level with RAG

Dynamic Data bars for Quality Score with RAG-

Dynamic Data bars for Quality Score with RAG-
Dynamic Data bars for Quality Score with RAG-

Visit our YouTube channel to learn step-by-step video tutorials

Youtube.com/@PKAnExcelExpert

Watch the step by step video tutorial:

we have used two types of conditional formatting to create such data bars.

  1. Fill Background color
  2. Data Bar

In the status column (Column D), we put the formula “=100%-C2” and fill it down.

conditional formatting to create multicolor data bars
conditional formatting to create multicolor data bars

First conditional formatting we put to fill the background color on the base of Column B.

  • For “On Time”, we put green color.
Conditional formatting for Green Background
Conditional formatting for Green Background
  • For “Delayed”, we put red color.
Conditional formatting for Green Background
Conditional formatting for Green Background

Then we put the Data Bar Conditional formatting with below setting-

  • Check Show Bar only.
  • Take “Type” as “Number” for Minimum and Maximum.
  • Put 0 for minimum and 1 for maximum.
  • Select color as white.
  • Select Bar Direction Right-to-Left

 

Data Bar Conditional formatting
Data Bar Conditional formatting

 

  • Click on OK

 

Multicolor Filling Bars in Excel Cells Without using Chart
Multicolor Filling Bars in Excel Cells Without using Chart

PK
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!
https://www.pk-anexcelexpert.com