How to use Conditional formatting in Excel Chart

[@andhikansinaba7478]

Thanks for the video...

[@PKAnExcelExpert]

My pleasure

[@adig755]

Thank you for your great keys

[@PKAnExcelExpert]

My pleasure!

[@SabiqAli-x7d]

Thank You. Really helpful

[@PKAnExcelExpert]

Glad it helped!

[@valleymuse9508]

Awesome. A lifesaver. Thanks.

[@PKAnExcelExpert]

Thanks for your valuable feedback

[@bwright1470]

Heads up...in Excel 2016 i was not able to do the graph in one go. I had to make an 100% stacked graph and then switch graph styles/types afterwards to just a regular stacked graph. FYI....thanks for the vid PK

[@pandharinathjoshi6565]

Very nice sir

[@PKAnExcelExpert]

Thanks for your valuable feedback

[@TheAjju008]

You explaine very well. Thanks

[@PKAnExcelExpert]

Thanks for your valuable feedback

[@alexmorgan4553]

Am literally doing a homework online with this

[@PKAnExcelExpert]

Thanks for your valuable feedback

[@geetatolani1645]

Thank you so much sir 😊

[@PKAnExcelExpert]

Welcome

[@Bauernschinken]

Thanks a lot for this video.
Very well explained and easy to understand - helped me a lot! :)

[@PKAnExcelExpert]

Thanks for watching and sharing your valuable feedback

[@miladsoltanalipour8760]

Good idea!

[@pavithrapavithran3666]

Innum konjem detail la irundha nalla irukum😦😦🤓

[@eng.a]

Thank you

[@PKAnExcelExpert]

Most welcome🙏

[@BRAAAPOLOGY]

Thank you! Great tutorial!

[@PKAnExcelExpert]

Thanks for your valuable feedback

[@mohamedhashem6927]

thank you very much

[@dereksfetishfortheuniverse8142]

Thanks!

[@PKAnExcelExpert]

Thanks for your valuable feedback

[@muhammadhassanali5579]

Good tutorial (y)

[@PKAnExcelExpert]

Thanks for your valuable feedback

[@heshamlotfy2173]

Hi my Dear, Can we use a formula to make a chart similar to this chart but a formula between range more than specific value and less than another specific value in the same time?

[@krishnamurthyhunagund1049]

Nice one PK

[@mohammadwohidullahmozumder3407]

Great work sir.

[@PKAnExcelExpert]

Thanks for your valuable feedback

[@adig755]

Can it is possible for monthly basis,
Say 10 different outsales on 10 different dates of January, February .... march...
12 colour for 12 month

[@mandalanil23]

Nice sir ji

[@PKAnExcelExpert]

Thanks for your valuable feedback

[@germaingyesah5724]

Can you do this with pivot table?

[@PKAnExcelExpert]

Yes, we can do it. I will try to create a video on this topic soon

[@somankamondal2001]

Please can you advise the formulas as how i can show "complete" , "WIP" and "Not received" status in bar graph.

[@golammohiuddin272]

Hi PK, can I make conditional formatting using 3 different color?

[@arielcascallares]

Does this still work with pivot charts?

[@rubentchonmo5629]

hi my dear, thanks for your video.
in french excel the forlular is not working if(B2

[@ashahmed2001]

the NA values appear when we add the data labels how to elinaite them when plotting and adding data labels pls explain

[@PKAnExcelExpert]

will create a video on this topic

[@ashahmed2001]

@@PKAnExcelExpert in new excel version we can remove from hidden cells but in old versions manually we have clear by selection if there is any other method pls advise PK sir

[@mns1965]

Hello PK, I have gone through both videos of yours on conditional formatting and dynamic graph with multiple format. My question, is it possible to combine both these in one graph? Thanks, Sathesh

[@PKAnExcelExpert]

Hi Sathesh,
Definitely it is possible. I will definitely try to make such video very soon. Thanks for watching and sharing nice ides.

[@mns1965]

Thanks for your reply. I started using both of XL formatting you taught, Very much useful. Awaiting your video on combining both. Thanks again

[@adaylateacoinshort]

Thanks for this

[@PKAnExcelExpert]

Thanks for watching

[@sangeetagusain5197]

Sir,
Mera jab chart bna rahi hu toh baar baar jo month h vo vertical aa rahe h jabki mujhe horizontal chahiye uske liye main kya karo?

[@tallatnaz]

Please make a video for how to to insert error bars in simple way.

[@maheshmahi3378]

Hi PK.. Please help.. I am not getting bar for 0.00%.. I have applied 0.00 to 5 as green and above dat red.
I required Green bar for 0.00%..

[@omkarokar1938]

Sir MIS Report par videos banaye please

[@PKAnExcelExpert]

Sure I will create it soon

[@nitinsingh.2107]

Gr8!

[@PKAnExcelExpert]

Thanks

[@maheshmahi3378]

Hi PK.. If SL% is 0%.. value is not showing in bar graph

[@subodh59]

PK BHAI I DONT HAVE CHART TOOLS IN MY EXCELL ?

[@bikespot8316]

If three coloum mean

[@bikespot8316]

Single bar

[@jonathanng7141]

How to conditional format clustered chart

[@jasonng3194]

this is actually a nice hack lol

[@PKAnExcelExpert]

Thanks

[@maheshmahi3378]

Hi PK.
O% not showing in the same chart.. please help

[@billyzerocool]

Hai Mr Kumar. May I Know What Is "LOCKED IT" means. I lost to understand how from F1 turn to $F$1. This Video Superb For Amateur Like Me

[@PKAnExcelExpert]

Hi,
Please press "F4" button to lock or freeze the cell or you can put dollar sign manually.
Thanks for watching and sharing your valuable feedback.

[@billyzerocool]

PK: An Excel Expert Tq Mr

[@lifeinfree515]

Cnt understand

[@heshamlotfy2173]

Millon Like,,,

[@PKAnExcelExpert]

Thanks for watching and sharing your valuable feedback