Multicolor Filling Bars in Excel Cells Without using Chart

#DynamicDataBar #Visulaization
Hello Friends,
In this video 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.
Download the practice file from below given link:
www.pk-anexcelexpert.com/mult...
Download the Free Project Management Dashboard
www.pk-anexcelexpert.com/exce...
Download our free Excel utility Tool and improve your productivity:
www.pk-anexcelexpert.com/prod...
See our Excel Products:
www.pk-anexcelexpert.com/prod...
Visit to learn more:
Chart and Visualizations: www.pk-anexcelexpert.com/cate...
VBA Course: www.pk-anexcelexpert.com/vba/
Download useful Templates: www.pk-anexcelexpert.com/cate...
Dashboards: www.pk-anexcelexpert.com/exce...
Watch the best info-graphics and dynamic charts from below link:
• Dynamic Graphs
Learn and free download best excel Dashboard template:
• Excel Dashboards
Learn Step by Step VBA:
• VBA Tutorial
Website:
WWW.PK-AnExcelExpert.com
Facebook:
/ pkanexcelexpert
Telegram:
t.me/joinchat/AAAAAE2OnviiEk5...
Pinterest:
/ pkanexcelexpert
Visit our Amazon Store
www.amazon.in/shop/pkanexcele...

[@nsanch0181]

Thank you for the trick PK. Once again you showed me a new and better way of doing things. Thank you!

[@rossybink]

Any Service Level Manager would love this. Thanks, great work! 👍

[@PKAnExcelExpert]

Thanks for your valuable feedback

[@philipberesford2648]

Brilliant job. All the detail needed and still concise.

[@PKAnExcelExpert]

Thanks for your valuable feedback🙏

[@LudwigSpiegel]

Thank you for Sharing! Just what I was looking for!

[@PKAnExcelExpert]

Thanks for your valuable feedback

[@StephaneR0sa]

It's very smart to use backward white to have at the same time a progress bar and a value based color ! Thanks :-)

[@PKAnExcelExpert]

Thanks for your valuable feedback

[@saramurgia8367]

really a very good tutorial. well made, clear and not boring. bravo!

[@PKAnExcelExpert]

Thanks for your valuable feedback🙏

[@shilandatstewart]

Exceptional tutorial. Exactly what I needed

[@PKAnExcelExpert]

Thank you very much!

[@rajsahu1029]

Nice. A good revision of conditional formate also done

[@abdelhadia8712]

Thanks a lot Professor

[@amal2503]

Nice and effective! Thanks Pk

[@PKAnExcelExpert]

Thanks for your valuable feedback

[@snowwhite2146]

Thank you for this excellent video!

[@PKAnExcelExpert]

You're very welcome!

[@razzaqabdur1761]

fantastic sir, Thanks

[@senthooranaccel9529]

You are a star !

[@PKAnExcelExpert]

Thanks a lot.

[@wahidovich2021]

God bless you PK, I've been looking for this one exactly the one as in "Service Level" data sheet, I just didn't know how to phrase my question :(
Thanks a lot man!

[@PKAnExcelExpert]

Thanks for your valuable feedback

[@dhanu502]

Great content and excellent explanation PK Sir. Thank you very much.

[@PKAnExcelExpert]

Thanks for your valuable feedback🙏

[@janezklun]

Nice approach, thank you for sharing, Best regards

[@PKAnExcelExpert]

Thanks for your valuable feedback

[@deepaknagar5697]

Wow, amazing , thank you.

[@PKAnExcelExpert]

Thanks for your valuable feedback

[@nitinsingh.2107]

Great work!

[@PKAnExcelExpert]

Thank you! Cheers!

[@JeffersonAMontoya]

Excelente maestro

[@PKAnExcelExpert]

Thanks for your valuable feedback

[@kunio4143]

Thanks for sharing, very useful:)

[@PKAnExcelExpert]

Thanks for your valuable feedback

[@jaydeeplimbad90]

Thank you Sir... For conditional formatting process....

[@PKAnExcelExpert]

Thanks for your valuable feedback

[@Luciano_mp]

Awesome, good, thanks.👍

[@PKAnExcelExpert]

Thanks for your valuable feedback

[@jewelmia2126]

Excellent, thank you.

[@PKAnExcelExpert]

You are welcome!

[@albertozamora7099]

Thank you this was very helpful

[@PKAnExcelExpert]

Glad it was helpful!

[@mavado5046]

Wow you are very clever!

[@PKAnExcelExpert]

Thanks🙏

[@iwankurniawan9666]

Thank you so much my GURU ..

[@PKAnExcelExpert]

Most welcome

[@GeorgeAJululian]

thank you extremely helpful

[@PKAnExcelExpert]

Thanks for your valuable feedback

[@rajeshchoudhary2520]

Thank You Sir....Very Nice Video

[@PKAnExcelExpert]

Thanks for your valuable feedback

[@vanessabbrooks698]

Amazing Thank you

[@PKAnExcelExpert]

Most welcome🙏

[@abdusshakur2878]

very nice helpful video Thank you

[@PKAnExcelExpert]

Most welcome

[@pandharinathjoshi6565]

Wonderful sir

[@PKAnExcelExpert]

Thanks for your valuable feedback

[@gov_laxvlogs3982]

Thanks 👍

[@PKAnExcelExpert]

Most welcome🙏

[@ranarizwanahmed]

Very good tutorial

[@PKAnExcelExpert]

Thanks for your valuable feedback

[@nonoobott8602]

Your videos are always very insightful. Thanks for sharing

[@PKAnExcelExpert]

Thanks for your valuable feedback

[@jackmonsel8987]

Good Job, I just wished there was a way to get rid of annoying colored border around the white bars.

[@mohankumar-lc3pm]

Thank you

[@PKAnExcelExpert]

Welcome

[@Cristiano_Ronaldo_28_17_7]

Wow nice sir i understood i will use it but sire can you teach us forecasting manpower calculation scheduling WFM part please sir please

[@pandharinathjoshi6565]

You are great sir., sir one question you can write comment sir... how you think to do excellent idea pls

[@kyleparadise9821]

Great content; question. With the first example, can you make the remaining of the data bar a different color? For instance if it is 75% on time, it will be filled green 3/4 of the cell. Can you color the remaining 1/4 of the cell a different color?

[@pawansharma-wo3xh]

Very good pk...
Please also start tutorial on power BI and DAX

[@PKAnExcelExpert]

Thanks for your valuable feedback. Will upload soon

[@Alibabachalise]

Sir thank you for the Lesson and permission to download practice file. Appreciated very much

[@PKAnExcelExpert]

Thanks for your valuable feedback

[@qualityrelaxationmusic9284]

Great. Please start on python and pandas library.. to atomate the excel report. Really we need it. And your teaching skill is awsome. Please please please start your videos on python

[@PKAnExcelExpert]

Thanks for your valuable feedback. I will try.

[@apn6824]

Very good info PK..But I have told you already that you have to zoom in while typing or selecting options so that viewers can see it clearly what you're doing. It will easy to understand & practiced clearly

[@PKAnExcelExpert]

Thanks for your valuable feedback. I will take care of this in upcoming videos

[@sharvari.s.vichare]

Good pk

[@PKAnExcelExpert]

Thanks for your valuable feedback

[@shubhamverma2800]

Dear sir I requested to you that please make a video about the power bi. I want want to learn from your video.

[@duikmans]

What would you do if you also have to include negative percentages in your data bar?

[@alializadeh8195]

Thanx

[@PKAnExcelExpert]

Welcome

[@vogueasr2363]

❤

[@PKAnExcelExpert]

Thanks 🙏

[@agungrahmadiutama2178]

👍👍👍👍👍

[@PKAnExcelExpert]

Thanks

[@shivannahr780]

ms access form data entry tutorial
Start sir very interested your teaching thanks sir

[@PKAnExcelExpert]

Please watch the below given videos-
ua-cam.com/video/4WXzPROcjLE/v-deo.html
ua-cam.com/video/aYJatDiNswQ/v-deo.html

[@sanand222]

V nice video... V useful...can u create a dashboard sla scorecard based on the requirements like ABN rate, ASA, FCR, CSAT AND OTHER PARAMETERS

[@PKAnExcelExpert]

Please refer the below given playlist.
ua-cam.com/play/PLbDvAYjpWJ7CpupRYMRkXSN0L92t7nUuF.html

[@drislam1231]

thank you very much really beneficial,
could we remove the remaining borders of cell fill color
because bar is slightly smaller than cell hieght making part of cell background appears

[@PKAnExcelExpert]

Yes we can

[@pankaj3648]

Sir , insentive sheet excel की बनानी है ।

[@krishnaveni6384]

Can anyone help with a macro how to write formula based on column header and fill down till last used row..
Specially when formulas are written in separate sheet say
sheet1 as all the formulas and sheet name( Col a = headers, col b= formula)
Sheet 2 has headers in row 1, in horizontal, macro should look sheet1 and list the formula in sheet 2 once the headers matches and has to fill till last used row
Unsure how to do that

[@hijodeGaladriel]

Si si teclado está en español y no les funciona con And, deben poner Y

[@effatmehmood6654]

I have taken single data and have highlighted with colors, but when i add data bars .. it disappears 100 percent and showing red bar bigger..

[@jazyhappy5018]

I want to show progress with status only. Like if I select completed then bar should show 100% if in progress then it should be 50% and pending should be 25% not started 0%

[@sumank2190]

Sir...How to Use....Pk's Utility Version 1.0 & 2.0 in Win-7,MS Off-2010....am using MS Off 2010...am Add in version 1.0..still it is not working in my system...??? Same for 2.0 also....Pls....give me Solutions for those problems..???

[@krissyb884]

This doesn’t work for me. The white bar fills the cell based off the %. For example, if the cell was 30%, the white bar would fill the cell up 30% of the way instead of 70%. Any fixes for this issue ?

[@meganharris8651]

Same for me i dont understand please help!

[@BMAA_off]

Hello

[@moskitowilliam4398]

PK, let me know if u need anything from Ghana
God bless you

[@luckyverma2357]

Hello Sir i would like to get in touch with for an assignment, i have also mailed you and messaged you in telegram, waiting for your kind response

[@luckyverma2357]

?????

[@mahirbadanagki]

Thank you

[@PKAnExcelExpert]

Most welcome

[@luckyverma2357]

?????