Sir I did it with condition a formatting.(also learned from you). And it was easy.
@TecniswebAragasplus4 жыл бұрын
Bellissimo video, complimenti
@karthikkeyan25906 жыл бұрын
I learned a lot from u bro. Really awesome . U r a excel genius
@PKAnExcelExpert6 жыл бұрын
Thanks for your valuable feedback
@swanandti4 жыл бұрын
Super like boss... Thank you
@PKAnExcelExpert4 жыл бұрын
Thanks for your valuable feedback
@aydneroglu79084 жыл бұрын
Thanks so much my friends. you are perfect about this. I wanna make dashboard for my report. I hope ı can make it :)
@donbush67024 жыл бұрын
Hi PK I really am enjoying most of your videos especialy about charts, so thanks for that. In this one though I am struggling, I can't seem to get the formula for the occupancy right. Copying the formula down and accross it just comes up with zero and the occupancy rate registers 100% perhaps their is something simple that I may or may not be doing, I would appreciate a little advice. many thanks. DB
@AD46056 жыл бұрын
thank you too for pretty cool subjects
@PKAnExcelExpert6 жыл бұрын
Thanks for your valuable feedback
@yaminibhatt43485 жыл бұрын
It's great but in which type of data we can use it?
@PKAnExcelExpert5 жыл бұрын
Thanks for your valuable feedback. You can use it to show occupancy or work load % in this chart
@lukev7306 жыл бұрын
Amazing
@PKAnExcelExpert6 жыл бұрын
Thanks for your valuable feedback
@sergiohernanrojasbuitrago11306 жыл бұрын
If you insert a line above "occupancy" the formula does not work when you put 1%, why?
@UsamaAmeer Жыл бұрын
How truk filled show from bottom to top not left to right
@alpeshdoshi78277 жыл бұрын
sir...pls explain logic of formula
@PKAnExcelExpert7 жыл бұрын
Hey Alpesh, We need the number of boxes = Occupancy For example the occupancy is 52% then we need a 10x10 table wherein 52 times should 1 and rest in 48 cells should 0.
@mufycw6 жыл бұрын
Hi PK, I have a question, the workload box you made for the truck with formula same could have been made with conditional formatting like you did in KPI indicators video where you used conditional formatting to colour the blocks. In this video kzbin.info/www/bejne/bKaogImsfr6sbKc. Why you used formula for colouring the blocks ??
@PKAnExcelExpert6 жыл бұрын
Hi Mufaddal, Its nice question. Yor are right it could have been achieved by using conditional formatting also, but my objective is share the maximum knowledge with people. That is the reason i have used Excel cells in one video and excel chart is 2nd video. Thanks for watching.