Stylish and Dynamic Comparison Chart | No Excel Shape or Picture used

Поделиться
HTML-код
  • Опубликовано: 21 окт 2024

Комментарии • 98

  • @nsanch0181
    @nsanch0181 3 года назад +2

    PK, this morning I brewed a coffee, watched your video and learned how to make this beautiful comparison chart. Such a good way to start a morning. Life is good; and thank you so much for sharing!

  • @samimahbub1999
    @samimahbub1999 4 года назад +3

    You are my Guru..... Dynamic Charts, graphs, data representation.... all I've learned from you..

  • @ajmraghu2683
    @ajmraghu2683 2 года назад +1

    wonderful chart - Thanks for teaching this to us🙏🙏🙏

  • @at-excel
    @at-excel 4 года назад +5

    A really wonderful presentation. You inspirated me to create a similar chart with a xy scatter plot. Greetings from your German Excel colleague!

  • @iftekharraju318
    @iftekharraju318 Год назад +1

    Excellent.. You are my excel mentor ❤️

  • @stanulli
    @stanulli 3 года назад +1

    Very useful chart and useful for presenting financial data as well. Thank you for sharing.

  • @wangzig9800
    @wangzig9800 3 года назад +1

    Excellent tutorial. thanks a lot

  •  4 года назад +1

    Excelentes vídeos, muy bien explicados. Gracias. Con estos vídeos innovadores, nos motivas a ser más creativos con nuestras herramientas actuales...

  • @carlosrobertomartinezandra9120
    @carlosrobertomartinezandra9120 4 года назад

    wonderful, dear friend, you will have smart graphics like this, regarding heat map in Excel

    • @PKAnExcelExpert
      @PKAnExcelExpert  4 года назад

      Big thanks, Please watch the below video for Heat map
      ruclips.net/video/ekhbD_BCENw/видео.html

  • @omercetinkaya8962
    @omercetinkaya8962 3 года назад +1

    Perfect chart. Well done brother

  • @FCabralSa
    @FCabralSa 3 года назад

    Brilliantly conceived chart and source data.

  • @albanoteles4924
    @albanoteles4924 4 года назад +1

    The Best Excel Guru!Thanks for sharing

  • @piarchanddogra1659
    @piarchanddogra1659 4 года назад +1

    Great, Really PK is excel expert 👍👍

  • @Ruby81Channel
    @Ruby81Channel 4 года назад +1

    I wanna say thank you for your share knowledge,,, always a success for u and your RUclips Channel

  • @MrDhunpagla
    @MrDhunpagla 3 года назад

    Thanks a ton ...I was lukin for it for such a long 🙏🙏🙏

  • @vacilando86
    @vacilando86 4 года назад +1

    Again an awesome tutorial

  • @zacompta
    @zacompta 4 года назад +1

    Thank you so much, you are the best

  • @sridharkrishnappanavanerth3388
    @sridharkrishnappanavanerth3388 4 года назад +1

    Just Fantastic, Thanks for sharing this video.

  • @durgesh91tomar
    @durgesh91tomar 4 года назад +1

    Awesome work Dost.

  • @balbirsinghkalwan4729
    @balbirsinghkalwan4729 Год назад

    Excellent 👍

  • @manjunathchandran7423
    @manjunathchandran7423 4 года назад

    Great! Thanks Sir ,Just Awesome class

  • @varunkhanor
    @varunkhanor 4 года назад +2

    This is beyond pro level stuff
    Awesome. You are god of excel

  • @josearmaza863
    @josearmaza863 4 года назад +1

    Great, PK. Another useful video, thank you.

  • @deepaknagar5697
    @deepaknagar5697 4 года назад +1

    Great work sir.

  • @pandharinathjoshi6565
    @pandharinathjoshi6565 4 года назад +1

    Its very useful sir., nice👌👌

  • @sushilv2234
    @sushilv2234 4 года назад +1

    Wow... Amazing .. may your channel soon touch 1 million subscribers mark .. best of luck ahead

  • @DM-YouTube
    @DM-YouTube 4 года назад +1

    Great, as usual 👍 Thanks for sharing 🙏

  • @Success_Mantra82
    @Success_Mantra82 4 года назад +1

    Awesome Dashboard 😉😁😁👍

  • @adnanbulut9983
    @adnanbulut9983 3 года назад

    It is great work... You are (P)rimary (K)ey in Excel for me. I really thank you for your tutorials and shared example files that try to whenever improve my Excel projects.

  • @bunty300981
    @bunty300981 4 года назад +1

    Good one PK ji

  • @vineetjain6600
    @vineetjain6600 4 года назад

    Hi p.k. this video is very helpful...and thank you for making this...but can you pls make a video on quarter wise comparison..manager wise etc.

  • @sps8585
    @sps8585 4 года назад +1

    Awesome PK sir...

  • @haninawaya9967
    @haninawaya9967 3 года назад +1

    Great

  • @pandharinathjoshi6565
    @pandharinathjoshi6565 3 года назад

    Very good video to observe Inventory product.
    Sir one doubt sir, in ur product shows only 10., if it is more than 200 Items, how we can set sir., pls pls inform sir

  • @sunilhar8623
    @sunilhar8623 4 года назад

    Super..r.r...b. Big thumps up. Just one question: Your this graph is fixed with 10 products. How can we make more dynamic chart with any number of products .. it may be 2-3 products or 20-25 products? can you make video on that?
    Very very important: I downloaded your practice file from your site. when i choose 2014 Vs 2019 or 2013 Vs 2019, Many labels are blank in chart. There are many combinations where values are there in support sheet but labels are blank in chart.

  • @Bhimraj2210
    @Bhimraj2210 4 года назад +1

    Great...
    Thanks for this..

  • @024_adityamishra7
    @024_adityamishra7 4 года назад

    thank you so much sir for a nice video. sir is it excel 2019 ?

  • @Laxmanmane007
    @Laxmanmane007 4 года назад

    Hello sir please start series on Alteryx also

  • @davendersundri3819
    @davendersundri3819 4 года назад

    Hi PK,
    Thank you for posting such great content. I have a question for you. I hope you can help.
    The question is related to bank reconciliation. Suppose I have 2 sets of data. 1. Bank statement download in csv format and 2. Bank data/ledger from the accounting software.
    Both the data sets have columns like date, particular, debit and credit. Is there a way we van use excel for the reconciliation.
    Important point to note is that we have many duplicate values in both the data sets. Also please assume that there is no unique key/identifier. Hence Vlookup/ match or highlighted conditional formatting will not work.
    Thanks in advance

  • @newave2010
    @newave2010 4 года назад

    Can you create column chart from Privot data table and use Slicer. The point is when select column by use slicer, only selected column change color, other column no change.

  • @arjasarkar13
    @arjasarkar13 4 года назад +1

    As always you are amazing. Highly impressive 👏

  • @MuhammadRizwan-vj7fp
    @MuhammadRizwan-vj7fp 4 года назад +1

    Awesome!

  • @ca.lokenderchauhan2605
    @ca.lokenderchauhan2605 4 года назад

    In data label column we can use ifs formula instead of if

  • @a.rakeshpatro
    @a.rakeshpatro 4 года назад +1

    super

  • @razzaqabdur7519
    @razzaqabdur7519 4 года назад +1

    Good, I like 👍

  • @shermanho867
    @shermanho867 4 года назад

    Can this be done in PowerPoint also?

  • @sakthiagri
    @sakthiagri 3 года назад

    how can we present this dynamic chart in ppt & presentation dynamically?? ji

  • @dharanim6570
    @dharanim6570 4 года назад

    when i compare product 3 and product 5 for 2012 vs 2019, green arrow is coming. however, the values are not showing in the data bars.

  • @shabarish.d.vd.v4346
    @shabarish.d.vd.v4346 3 года назад

    How to create for one product with red arrow or green arrow

  • @Facesshower
    @Facesshower 4 года назад +1

    Can we use xlookup instead of vlookup

    • @PKAnExcelExpert
      @PKAnExcelExpert  4 года назад

      Yes we can use

    • @Facesshower
      @Facesshower 4 года назад +1

      @@PKAnExcelExpert ok. Thank you. You are excelent

    • @Facesshower
      @Facesshower 4 года назад +1

      @@PKAnExcelExpert I am 11 years years old. I love doing charts and ppt.

    • @PKAnExcelExpert
      @PKAnExcelExpert  4 года назад

      Thanks for your valuable feedback

    • @PKAnExcelExpert
      @PKAnExcelExpert  4 года назад

      Wow. You are genus

  • @apn6824
    @apn6824 4 года назад

    PK.. Everything is fine but from constructing the formula for data label its getting difficult to understand...

  • @rez2109
    @rez2109 3 года назад

    hi, greetings from Malaysia. I have texted you personally at your telegram acc.

  • @aryanshrivastav595
    @aryanshrivastav595 4 года назад +1

    1st comment