Multi-color Data bar with REPT function in Excel

#MulicolorDatabar #ConditionalFormatting
Hello Friends,
In this video, you will learn how to create a multi-color Data bar with REPT function in Microsoft Excel. We have used the conditional formatting to change the color on the basis of certain criteria.
Download the practice file from the below link:
www.pk-anexcel...
See our Power BI videos:
• Power BI Tutorial
Learn and download our interactive Excel dashboards free of cost-
• Excel Dashboards
Download the Free Project Management Dashboard
www.pk-anexcel...
Download the Calendar Control in VBA from below link
www.pk-anexcel...
Download our free Excel utility Tool and improve your productivity:
www.pk-anexcel...
See our Excel Products:
www.pk-anexcel...
Visit to learn more:
Chart and Visualizations: www.pk-anexcel...
VBA Course: www.pk-anexcel...
Download useful Templates: www.pk-anexcel...
Dashboards: www.pk-anexcel...
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-AnExcel...
Facebook:
/ pkanexcelexpert
Telegram:
t.me/joinchat/...
Pinterest:
/ pkanexcelexpert
LinkedIn:
/ pk-anexcelexpert
Instagram:
/ pkanexcelexpert
Visit our Amazon Store
www.amazon.in/...

[@TroyJScott]

I love how you do excel Man. Thank you for the content

[@PKAnExcelExpert]

Most welcome

[@rajsahu1029]

No comments as beauty of data is the speciality of you. ❤️❤️

[@PKAnExcelExpert]

Thanks for your valuable feedback🙏

[@thananaiyarapong4005]

Very helpful! Thank you!!

[@PKAnExcelExpert]

Most welcome

[@Rajan-kk8nl]

Very very intersting, your every videos, thank you so much.

[@PKAnExcelExpert]

Thanks for your valuable feedback🙏

[@sumardjo]

Thanks for your knowledge
for file sample is very good to practice learn
is very good
thanks

[@PKAnExcelExpert]

Most welcome

[@nsanch0181]

PK than you for the great video? I was familiar with the Rept, but never really got creative with the fonts. I tried Font Snap ITC and it made a nice looking ball type symbol. You have shown me some really cool tricks PK thank you.

[@PKAnExcelExpert]

Most welcome🙏

[@arturogallobalma4621]

You don't need to enter formulas, but in cell C2 enter =B2 drag up to C12, then select the range C2:C12, then Home --> Conditional Formatting --> Data Bars --> Solid Color and the chart is done.

[@jmathew6988]

Wow! Ingenious hack there. Solved my problem

[@PKAnExcelExpert]

Thanks

[@mohamedabo-ewisha6243]

Thanks for your knowledge💟💟💟

[@teoxengineer]

So many thanks for this good presentation without using chart techniques 👍
I’m waiting for this type of interactive tutorials

[@PKAnExcelExpert]

Thanks for your valuable feedback🙏

[@truewiking]

This is brilliant, Thank you very much 🙏

[@PKAnExcelExpert]

You're very welcome!

[@gandhiviji]

Very use full method to make chart, Amzed me

[@PKAnExcelExpert]

Thanks🙏

[@nadermounir8228]

Nice video and very informative 👍 Thank u PK

[@PKAnExcelExpert]

Most welcome

[@VisuLytics]

Very helpful video PK. Thanks

[@PKAnExcelExpert]

Most welcome

[@unnikrishnansanthosh]

great ideas, keep it up PK, thanks for sharing

[@PKAnExcelExpert]

Most welcome

[@temyraverdana6421]

Wow, an incredible trick. Thanks

[@PKAnExcelExpert]

Thanks for your valuable feedback🙏

[@RashidAlharmoodi]

This was very useful - thank you!

[@PKAnExcelExpert]

Most welcome🙏

[@katerina6495]

Beautiful, thank you PK

[@PKAnExcelExpert]

Most welcome

[@ICTNuggets]

Great video PK...thanks for uploading. In the future, can you please consider making a leave management system using SharePoint List, Power Apps, and Power Automate? Many thanks

[@PKAnExcelExpert]

We will try

[@diannanh]

Thank you so much for this!

[@PKAnExcelExpert]

You're so welcome!

[@cgl4572]

Thank you so much 😊

[@PKAnExcelExpert]

Most welcome

[@SyedMuzammilMahasanShahi]

Thanks for the share.

[@PKAnExcelExpert]

Most welcome

[@jgun0075]

Awesome 👍😎

[@PKAnExcelExpert]

Thanks🙏

[@Mu00lia]

Awosome

[@PKAnExcelExpert]

Thanks🙏

[@seendesign8795]

why I don't find this font in microsoft excel online?

[@mayankgupta7172]

How to separate data bar and datapoint in same cell

[@fandulearning3685]

How did you put that pipeline symbol in excel

[@PKAnExcelExpert]

To insert the pipeline symbol in Excel, simply press the Shift key and the backslash () key simultaneously. This will result in the appearance of the pipeline symbol (|) in the desired cell. Give it a try!

[@sunriseankuram1362]

Instead of PIPPING OR Zero can we keep image..ex: bottle

[@seleskaviyag6377]

How to copy this chart to powerpoint?

[@syedasad7681]

What pipe line?

[@batir8713]

Yep

[@fakosentle1655]

👊

[@PKAnExcelExpert]

Thanks🙏

[@user-uq1bh7ho8b]

حلووووو

[@PKAnExcelExpert]

شكرًا

[@mayankgupta7172]

Which font is this

[@mayankgupta7172]

Playbull

[@Aka-293]

You go way too fast thru your step by step even if I replay the video multiple times. It would help if you had text on the side