Dynamic Chart: Target Vs Actual Sales

Поділитися
Вставка
  • Опубліковано 15 бер 2018
  • Hello Friends,
    In this video you will learn how to create a dynamic chart for Target Vs Actual Sales.
    Please download this excel file from below given link:
    www.pk-anexcelexpert.com/targ...
    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-AnExcelExpert.com
    Facebook:
    / pkan-excel-expert-9748...
    Pinterest:
    / pkanexcelexpert
    Telegram:
    t.me/joinchat/AAAAAE2OnviiEk5...
    Twitter:
    / priyendra_kumar
    Send me your queries on telegram:
    @PKanExcelExpert

КОМЕНТАРІ • 100

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

    Excellent tutoriel. J'ai découvert il y a quelques jours ton site internet et je ne le quitte plus. Merci PK pour le partage.

  • @alexrosen8762
    @alexrosen8762 6 років тому +1

    Super useful tutorial. Big thanks!

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

    This is awesome, and the raw data can be changed to suit different targets. I would use monthly Targets rather than daily . Also I can change Empl to Regions! Cool stuff...

  • @pulse_sonic
    @pulse_sonic 5 років тому +1

    Thanks for tutorial.. this videos can used in our off KPI's. And that can be implemented. Nice and cool ideas. Simply superb...

  • @miguelcalejo1770
    @miguelcalejo1770 6 років тому

    Great tutorial, one of the best (because it is simple) sales vs. objectives chart. Thnank you.

  • @Aceralkhafaji
    @Aceralkhafaji 6 років тому

    The truth is that everything you offer is simply wonderful and very useful. Thank you, thank you from the heart, my friend

  • @DanielLamarche
    @DanielLamarche 6 років тому +4

    Hello mate. Thanks for all your cool ideas. If I may give you a tip, when you resize a chart and Form control you can hold the Alt key and they will snap to the worksheet grid. It makes resizing the chart & the control a ... breeze! I've been teaching this trick for over 20 years.

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

    Good tutorials. Very informative. Keep it up.

  • @TATIANACHERVYAKOVA
    @TATIANACHERVYAKOVA 5 років тому +1

    Thank you so much for such a great video!!! It's awesome!))

  • @ALPHERATZ3650
    @ALPHERATZ3650 6 років тому

    this video is great!!!

  • @sudheeralle
    @sudheeralle 6 років тому

    Thanks sir, your videos are very simple & super.

  • @pawansharma-wo3xh
    @pawansharma-wo3xh 6 років тому

    Great job pk!!!!!

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

    Super sir really enjoyed your video.

  • @donbogdala5428
    @donbogdala5428 6 років тому +1

    Awesome Job!

  • @SyedMuzammilMahasanShahi
    @SyedMuzammilMahasanShahi 6 років тому

    amazing work. thanks

  • @victorrweyongeza8634
    @victorrweyongeza8634 6 років тому +1

    Amazing!! Keep it up 😍

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

    This is great, thank you for sharing this!

  • @rajibbal2055
    @rajibbal2055 5 років тому +1

    Thanks for the Nice tutorial sir, it would be very helpful to me if you show how this chart can be made if all the employees have different targets. Waiting for your feedback....

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

    Thanks! Very informative. The Project I have been given at work is kind of similar to this. I have a question though. For the “row-Index” number, I have 3 different rows. What can I do to make the formula work? In this example, there’s only one target row for all the employees. I have 3 employees in my example and all of them have their own rows of project/target amount. Please help

  • @nasserawadh2722
    @nasserawadh2722 6 років тому

    amazing . big thanks