Conditional Formatting in Multiple batteries Graph in Excel

Hello Friends,
In this video you will learn how to create a multiple batteries beautiful 3D chart along with conditional formatting.
Please download the excel file from below given link:
www.pk-anexcel...
Website:
www.PK-AnExcel...
Facebook:
/ pkan-excel-expert-9748...
Pinterest:
/ pkanexcelexpert
Telegram:
t.me/joinchat/...
Twitter:
/ priyendra_kumar
Send me your queries on telegram:
@PKanExcelExpert

[@Angexcel]

Simply without words, very good innovation, greetings from Bogotá Colombia. The language is not an obstacle, very grateful.

[@PKAnExcelExpert]

Thanks for watching and sharing your valuable feedback

[@jbkregs2766]

Your videos are fantastic. Thank you so much for taking the time to make them. They are a huge help.

[@PKAnExcelExpert]

Thanks for your valuable feedback

[@mujtabalakhany7456]

Awesome, Flawless and maximum... Love to watch your creativity and innovation that how you did and manoeuvre

[@PKAnExcelExpert]

Thanks for your valuable feedback

[@pandharinathjoshi6565]

Nice sir., conditional format 🙏🙏

[@PKAnExcelExpert]

Thanks for your valuable feedback

[@flexd08]

Mr. PK, you are indeed an Excel Expert. You made my day anytime always... You are a great teacher bro.

[@PKAnExcelExpert]

Thanks for your valuable feedback.

[@mathyalagan6345]

Hello sir, i am Mathiyalagan from Sri Lanka. very useful your sessions. thank you so much

[@PKAnExcelExpert]

Thanks Mathiyalagan,
For watching the video and sharing your valuable feedback.
Please share this with your friends and colleagues whoever is looking for excel and vba tutorials.
Thanks for your support to my channel.

[@andrestherock1]

Hello I'm watching your videos and I need to say that all of them are amazing, thks a lot.

[@RJG-Studios]

Very nice video, I like it very much.
This is very helpful for making nice dashboards.

[@jbkregs2766]

I created this chart for work, its amazing. How could I format to use yellow as well for when half the target is met??

[@dangthoi90]

Thank you ! From Vietnam

[@PKAnExcelExpert]

Thanks for watching

[@AhmedSaeed-iv3hi]

Thank You For Your Easy Way .....................

[@PKAnExcelExpert]

Thanks for your valuable feedback

[@drsumansuman4440]

Hi PK, Can we do this in Power BI also? If yes, could you please share the video, Thank you so much. You explain step by step, it is easy to follow up.

[@syedshah9411]

Dear PK, really I learnt a lot from your videos as a great help to mankind. Further I want to know if we can use three colors, red, amber and green for ranges below 70%, between 70% to 85% and above 85% respectively. If yes then how because I used the formula but got error. Thanks

[@PKAnExcelExpert]

Thanks for your valuable feedback. Yes we can use 3 colors also. I will definitely try to make such video very soon.

[@syedshah9411]

Please pk upload the video for three colors or write in the comment box the procedure so that I could complete my required graph. I tried so many formulas but they are not 100% fitted.

[@yamin207eb]

Thanks you dear. Included in my KPI report after a little amendment

[@PKAnExcelExpert]

Thanks for watching and sharing your valuable feedback

[@jbkregs2766]

Very very cool!!

[@PKAnExcelExpert]

Thanks for your valuable feedback

[@craigwatkins2285]

I love this! I followed your video and was able to create exactly what I was looking for. I do have a question, however. I have TWO "batteries" that exceed 100%, and have "grown" taller than the other batteries. Is there any way to lock the battery size, regardless of percentage?

[@kapilsharma1704]

hi sir. you are doing an awesome job. Also could you suggest how to make it for 10 % as total rather than 100 %. plz reply

[@soumalyadutta3941]

Awesome..

[@PKAnExcelExpert]

Thanks for your valuable feedback

[@dharmabalanjayaveerapandia165]

Excellent tool ! and I am using in my dash board . Is it possible to add values in the data label along with the %? Pls help me to have both in the chart. Thanks in advance.

[@projectscnc2462]

Awesome!! Sir

[@PKAnExcelExpert]

Thanks for your valuable feedback

[@ashanthipanaluwa1130]

Could you please help how to create this chart using slicers. Many Thanks for your valuable knowledge. Very impressive.

[@gurubalaful]

very nice bro

[@TechnicalVloggerindia92]

Amazing 🤟🤟🤟

[@PKAnExcelExpert]

Thanks for your valuable feedback

[@williamlira8470]

Excelent.......very very good

[@PKAnExcelExpert]

Thanks for watching and sharing your valuable feedback

[@alvospusb]

Very good... thanks

[@jbkregs2766]

Is it possible to keep the solid red but show a transparent green based on a forecast?

[@AshishKumar-dc2zd]

Wow, Great Bhai

[@PKAnExcelExpert]

Thanks for the watching and sharing your valuable feedback

[@ALPHERATZ3650]

Amazing video!! !:)

[@PKAnExcelExpert]

Thanks for watching and sharing your valuable feedback

[@rajeshangamuthu6106]

Very Nice Video,, I have question here, if my attainment goes above 100%, how do I eliminate the transparent green and the entire bar looks only as solid green, Pls help

[@PKAnExcelExpert]

Hi Rajesh,
Thanks for your valuable feedback. Usually this chart is for 0 to 100%. If you are aware the maximum limit of your Metric then you can use it.

[@syedshah9411]

Dear pk, since two months I have been waiting for your video which I have requested, three colors graph. Kindly expedite it for that I shall be very thankful to you.

[@jonathanmoreno5237]

Hello Friend. How come on the spanish 365 office version the NA() formula is not working? Other than that, everything is up and running. Could you please help me out?

[@alonsoalbertotacorallungo5906]

EXCELENTE VIDEO

[@PKAnExcelExpert]

Thanks for the watching and sharing your valuable feedback

[@abdulmalek1539]

very very good

[@PKAnExcelExpert]

Thanks for watching and sharing your valuable feedback

[@maheshmahi3378]

Hi PK.. if SL% is 0%.. value( 0% )it is not showing in bar graph.

[@anilvijayvargiya2101]

In conditional 3d graph how we can link 10 executive 12 months performance by single graph. Pls share

[@hemanthkumar1956]

Bhai please prepare a chart on invoicing

[@PKAnExcelExpert]

will try to create

[@VigneshS-gv4eq]

Brother, Please help me with macro recording, I am eagerly waiting for that.

[@ashwanikumarpaswan2331]

How to use in 2013 excel

[@dggaming5542]

#Pk: an excel expert how to use this in excel 2007

[@robert-skibelo]

Dislike. Music in the background is really distracting. Unnecessary and inappropriate. Really stupid idea.

[@irfanshaikh-lw2nm]

very very good

[@PKAnExcelExpert]

Thanks for watching and sharing your valuable feedback