Top Bottom Analysis Dashboard in Excel

Поділитися
Вставка
  • Опубліковано 21 жов 2024

КОМЕНТАРІ • 62

  • @bjworksit1174
    @bjworksit1174 3 роки тому +1

    PK, you are a genius!!!!

  • @SinghalPrateek
    @SinghalPrateek 4 роки тому +2

    Amazing, awesome... i like all your videos

  • @KhalilAhmad74036
    @KhalilAhmad74036 4 роки тому +1

    Great Video, and very helpful,

  • @selvakumarappavu4961
    @selvakumarappavu4961 4 роки тому +1

    Very detailed tutorial and very helpful. Thanks

  • @BurbenogExpert
    @BurbenogExpert 4 роки тому +1

    Bro you are a beast!

  • @jcsalao8
    @jcsalao8 4 роки тому +1

    Great Tutorial PK as always.

  • @md.raselhossain5086
    @md.raselhossain5086 4 роки тому +1

    very good . thank you very much boss.

  • @RPEXCELLENT
    @RPEXCELLENT 4 роки тому +1

    Very nice PK as always

  • @ukemeisaac
    @ukemeisaac 4 роки тому

    You are too good Sir! Thank you.

  • @ahmaddin7565
    @ahmaddin7565 4 роки тому +1

    Amazing dashboard

    • @PKAnExcelExpert
      @PKAnExcelExpert  4 роки тому +1

      Thanks for your valuable feedback

    • @ahmaddin7565
      @ahmaddin7565 4 роки тому

      @@PKAnExcelExpert I am passionate to learn VBA hopeful that your VBA course will be great for me.

  • @dineshpawar7869
    @dineshpawar7869 4 роки тому

    Very Nice.... however there is one issue..
    Once we click on bottom button then instead of logos showing normal bar. Please check and let me know if anything needs to be done for showing logos. Thanks

  • @sarva0483
    @sarva0483 4 роки тому

    Very Smart techniques 👏

  • @SuperTilea
    @SuperTilea 4 роки тому

    I love your videos. Can you generate a mortgage amortization dashboard?

  • @bhakthatech9818
    @bhakthatech9818 4 роки тому +1

    Excellent...👌👏👏👏

  • @venugopal7161
    @venugopal7161 4 роки тому +1

    Awesome video sir.

  • @Angexcel
    @Angexcel 4 роки тому

    Excelente explicación del tablero Top Bottom Analysis Dashboard in Excel, es posible compartir el archivo del tutorial, saludos desde Colombia.

  • @PriyaRajvanshHR
    @PriyaRajvanshHR Рік тому

    Please let me know how to actiate list control form in a text box

  • @AjaySingh-ll5qw
    @AjaySingh-ll5qw 4 роки тому +1

    It is really owesome. ....

  • @romlef526
    @romlef526 4 роки тому

    Good work
    Thank you

  • @satishnair1324
    @satishnair1324 3 роки тому

    Hi PK, I recently came across your channel and trust me it simply AWESOME. One issue while creating a indirect formula the selected cell text is displaying as =Indirect(' Support '!$xxxx) can you assist on the same

  • @rajsahu1029
    @rajsahu1029 4 роки тому

    Excellent, very interesting

  • @piarchanddogra1659
    @piarchanddogra1659 4 роки тому

    Fantastic 👍👍

  • @Atozcompletesolution
    @Atozcompletesolution Рік тому

    I WANT TO GET FULL COURSE HOW MUCH I HAVE TO PAY? ONLY ADVACNE ECEL STEP BY STEP

  • @srikanthdonthula5389
    @srikanthdonthula5389 4 роки тому

    Sir I have a doubt regarding my dashboard which I'm preparing.. can u please help me sir

  • @riteshvishwakarma9595
    @riteshvishwakarma9595 4 роки тому +1

    Superb! 👏🏻👏🏻

  • @johnreyleosala2935
    @johnreyleosala2935 4 роки тому

    Can u create a population dashboard. Thanks.
    Btw been viewing your channel for some info that i didnt know b4. Thanks.

  • @jagdishchandersatyawali9110
    @jagdishchandersatyawali9110 4 роки тому

    Sir I have tried this but there is problem. When I save this the picture I have used for location bars as you have shown in video it saves only for one option either for top or for bottom. And another option it shows always bars not the picture

  • @anniebannie221
    @anniebannie221 2 роки тому

    Sir I have created it for my organization but when I send this data to anyone..image from series removes automatically and it sends plan bar chart.

  • @aswinidhaneshkumar9166
    @aswinidhaneshkumar9166 3 роки тому

    Hello Sir, I took your video as a reference and prepared for Procure to Pay Performance dashboard. It's a Comprehensive dashboard and I have included this Top/Bottom analysis as one tab to this report and here comes the problem. whenever I re-open the report, I couldn't see the Bottom emp/location images which I pasted. it's simply showing as a bar chart. can u pls help me with this? what could be the reason for this error? Hence, when I publish this report via email. the receiver also seeing this chart as bars instead of images. This is a prob for Top/bottom only.

  • @anandkumar-xu3yq
    @anandkumar-xu3yq Рік тому

    I made this dashboard but picture auto change to bar chart when I closed and re-open excel file. Any one can help me?

  • @bharathg6256
    @bharathg6256 4 роки тому

    Kindly help me out to create monthly activity report in excel.

  • @shivammdwivedi8364
    @shivammdwivedi8364 4 роки тому +1

    pls share this excel sheet orr share the link so we cqn download it and practice accordingly..... Pls

    • @PKAnExcelExpert
      @PKAnExcelExpert  4 роки тому

      Excel download link has been given in videos discretion box or visit our website Www.pk-anexcelexpert.com

  • @vishwesht
    @vishwesht 4 роки тому +1

    PK sir, thank you for explaining so vividly and in a simple way. Can you please share a dashboard for KPI tracking which will be very useful for me. It would be great if the tracking is not based on nos but on supervisors inputs of High Medium and Low

    • @PKAnExcelExpert
      @PKAnExcelExpert  4 роки тому

      Thanks for your valuable feedback. I will definitely try to make such video

  • @rajashekarchary152
    @rajashekarchary152 4 роки тому

    Great work.. i have been making a sample sheet but while creating a indirect formula the selected cell text is displaying as =Indirect(' Support '!$xxxx) where as your video shows = Indirect (Support!$xxx) could you please let me know the error why spacing is formed automatically in my formula

    • @ankitasutar7496
      @ankitasutar7496 Рік тому

      I one error this one.... support formula using but there is not selected a column... please help

  • @sumank2190
    @sumank2190 4 роки тому

    pls keep this sheet for Download ....for Practice purpose.

  • @sumank2190
    @sumank2190 4 роки тому

    hi pk...Pls this excel sheet for practice purpose..

  • @abmalpani
    @abmalpani 4 роки тому

    Excellent creation and well explain. Love your work. How do I contact you for guidance or query on formulas?

  • @omkarpatil695
    @omkarpatil695 4 роки тому +1

    U hv one bugs/error in this... What if pivot start from a4 and scroll bar value selected as 1 then range goes upper side

    • @PKAnExcelExpert
      @PKAnExcelExpert  4 роки тому

      Pivot will never start from A4 because we have manually set it.

  • @sunilbs2455
    @sunilbs2455 4 роки тому

    I have 100 employee details for 4 months... How can I create this with month slicer

  • @bunty300981
    @bunty300981 4 роки тому

    sir need one help on excel work book

  • @kamrulzoha9223
    @kamrulzoha9223 2 роки тому

    Sir
    BOM banaiye ek please

  • @TallyAccountingSolution
    @TallyAccountingSolution 4 роки тому

    Sir aap Hindi me video kyo nahi banate hai.....

  • @antonionotarangelo1995
    @antonionotarangelo1995 4 роки тому

    👏👏

  • @arunsandhu3087
    @arunsandhu3087 Рік тому

    Not helpful doing very fast and confusing