VBA: Dynamic Charts in User Form

Поделиться
HTML-код
  • Опубликовано: 15 окт 2024
  • #VBA #UserForm #DynamicChart
    Hello Friends,
    In this video you will learn how to create dynamic charts on a VBA User form. I have created Battery Chart, Speedometer Chart, Moving man chart and Progress Circle Chart.
    Please download this excel file from below given link:
    www.pk-anexcel...
    Learn how to create below chart in Excel:
    Battery Chart: • How to create a batter...
    Speedometer Chart: • HOW TO CREATE A SPEEDO...
    Moving Man Chart: • Amazing KPI graph in E...
    Progress Circle Chart: • Infographics: Progress...
    Purchase our Excel Products:
    www.pk-anexcel...
    Visit to learn more:
    Chart and Visualizations: www.pk-anexcel...
    VBA Course: www.pk-anexcel...
    Download useful Templates: www.pk-anexcel...
    Dashboards: www.pk-anexcel...
    Watch the best info-graphics and dynamic charts from below link:
    • Dynamic Graphs
    Learn and free download best excel Dashboard template:
    • Excel Dashboards
    Learn Step by Step VBA:
    • VBA Tutorial
    Website:
    www.PK-AnExcel...
    Facebook:
    / pkan-excel-expert-9748...
    Telegram:
    t.me/joinchat/...
    Twitter:
    / priyendra_kumar
    Pinterest:
    / pkanexcelexpert
    Send me your queries on telegram:
    @PKanExcelExpert

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

  • @josecarlosconejo5724
    @josecarlosconejo5724 4 года назад +4

    Simply Incredible. You are not an Excel expert. You are an Excel Artist and Genius... I am speechless 😶

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

      Thanks for your valuable feedback

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

      a trick: you can watch series at kaldrostream. Me and my gf have been using it for watching a lot of movies lately.

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

      @Aydin Owen Yup, been watching on kaldrostream for since november myself :D

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

      @Aydin Owen Definitely, have been using kaldroStream for years myself :D

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

      @Aydin Owen yea, I've been using Kaldrostream for months myself :)

  • @KrishanKumar-zq1hb
    @KrishanKumar-zq1hb 4 года назад +3

    Its really useful VBA code, which will save lot of time of anyone. Thanks for your video

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

    Excelente gráficos en formularios.
    Muchas gracias por compartir sus extensos conocimientos con nosotros.
    Saludos desde Argentina.
    Charles

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

    You saved my life love uo

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

    Thank you so much, PK. Helped me a lot

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

    This is awesome. Runs very well. Thanks for sharing!

  • @joses.pacheco3069
    @joses.pacheco3069 5 лет назад +1

    Quando eu penso ter visto tudo sobre gráfico no Excel. Você mostra que é possível superar.

    • @sharmarudra
      @sharmarudra 5 лет назад

      Por favor, você pode comentar em inglês?

    • @joses.pacheco3069
      @joses.pacheco3069 5 лет назад

      @@sharmarudra When I think I have seen all about chart in Excel. You show it's possible to get over it. I put it in the translator. I am Brazilian and I do not speak English.

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

    OK, this is nice. The key part is at around 7:30. The trick is to have your chart already set up, then in the code export it as an image file. Besides Windows, has anyone tested this out on iOS and Android?
    Many thanks for uploading.

  • @SM-tz1hc
    @SM-tz1hc Год назад

    How to apply this process for monthly purshase ?

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

    How do you do set name chart and chart making

  • @chandanlimma3443
    @chandanlimma3443 5 лет назад

    Awesome PK sir.
    You are super as always.

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

    I am using this code , it works very well. But if I close the excel and reopen it , it starts giving error. Do you have any idea why it is so ?

    • @HUSSAINKHAN-zp9pt
      @HUSSAINKHAN-zp9pt Год назад

      ThisWorkbook.Sheets("Sheet_Name").ChartObjects("Chart_Name").Activate
      use this code in the last...i mean after loading picture code

  • @durgesh91tomar
    @durgesh91tomar 5 лет назад +1

    Awesome.... trick.....

  • @zahir585
    @zahir585 5 лет назад

    what amazing work! I have a specific question regarding the moving man chart i wonder if i can send a personnel email?

  • @suhailnbd
    @suhailnbd 5 лет назад +1

    Great👍

  • @alternativeenergyresearch4857
    @alternativeenergyresearch4857 2 года назад

    Hello
    Can you write excel code for DDE setup

  • @medkari
    @medkari 5 лет назад

    Merci mon ami

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

    Hi Sir.. I am encountering Run time error 481 in loading some graph with the same code. Appreciate your assistance

    • @HUSSAINKHAN-zp9pt
      @HUSSAINKHAN-zp9pt Год назад

      ThisWorkbook.Sheets("Sheet_Name").ChartObjects("Chart_Name").Activate
      use this code in the lase...i mean after loading picture code

  • @heisgreat-b7888
    @heisgreat-b7888 3 года назад

    Hi Sir
    Please share vba Code for same userform for 3 Users at a time in 3 different PCs

  • @david4ever160
    @david4ever160 5 лет назад +1

    awesome

  • @معلمسالم-ك2ج
    @معلمسالم-ك2ج 3 года назад +1

    Its really useful VBA code, which will save lot of time of anyone. Thanks for your video