Dynamic Chart: Target Vs Actual Sales

[@Aceralkhafaji]

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

[@PKAnExcelExpert]

Thanks Acer, for your motivational feedback.

[@redmarlon1489]

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.

[@DanielLamarche]

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.

[@PKAnExcelExpert]

Hi Daniel, Thanks for your valuable feedback. Its my pleasure that I got a chance to learn from you. I will use this trick in my upcoming videos. Thanks for your valuable information.

[@olujohnson4408]

Pls anyone how to calculate weekly sales forecast for a year

[@AmeeraHazmar]

Excellent... very well explained

[@PKAnExcelExpert]

Thanks for your valuable feedback

[@pradeepv50]

Super sir really enjoyed your video. Found very helpfull.

[@PKAnExcelExpert]

Thanks for your valuable feedback

[@PiXpilot_Shridhar]

Thanks for tutorial.. this videos can used in our off KPI's. And that can be implemented. Nice and cool ideas. Simply superb... After seen your videos and I'm getting different ideas to implement at our office charts..

[@PKAnExcelExpert]

Thanks for your valuable feedback

[@harichelluri4471]

This is great, thank you for sharing this!

[@PKAnExcelExpert]

Thanks for your valuable feedback

[@harichelluri4471]

@@PKAnExcelExpert ​ Hello! Just had a follow up question. What if different groups of salespeople had different sales targets. For example, say employees 1-10 in your example all have a different target set from the rest of the group. Is there a way to incorporate that into a single dynamic chart? Thank you!

[@Zakirkhan777]

That What i was looking for ❤️...

[@PKAnExcelExpert]

Thanks

[@mariafriend644]

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...

[@alexrosen8762]

Super useful tutorial. Big thanks!

[@aaqilkhan]

Good tutorials. Very informative. Keep it up.

[@miguelcalejo1770]

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

[@PKAnExcelExpert]

Thanks for your valuable feedback

[@nilbasakoglu1372]

It is very helpful for me thanks for it

[@PKAnExcelExpert]

Thanks for your valuable feedback

[@sudheeralle]

Thanks sir, your videos are very simple & super.

[@PKAnExcelExpert]

Thanks for your valuable feedback

[@TATIANACHERVYAKOVA]

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

[@PKAnExcelExpert]

Thanks for your valuable feedback

[@abdelhadia8712]

Thanks a lot

[@PKAnExcelExpert]

Welcome

[@rajibbal2055]

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....

[@PKAnExcelExpert]

Hi Rajib, Thanks for your valuable feedback. You can change the target in raw data for each employee.

[@pawansharma-wo3xh]

Great job pk!!!!! As always

[@PKAnExcelExpert]

Thanks Pawan For your valuable feedback

[@littlecanvases]

I was really trying to learn and follow but as the ads kept interrupting I could not get good concentration.

[@hun10hun]

Great video. Sir just want to ask if each employee has their individual separate targets and each hour target is same for a particular employee. How we can represent.

[@suhailnbd]

Very nice 👍

[@donbogdala5428]

Awesome Job!

[@PKAnExcelExpert]

Thanks for your valuable feedback

[@thedatalabs]

Very helpful

[@PKAnExcelExpert]

Thanks for your valuable feedback

[@victorrweyongeza8634]

Amazing!! Keep it up 😍

[@PKAnExcelExpert]

Thanks for your valuable feedback

[@cricketkajunoon]

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

[@amimahmad9699]

Sir, very useful video. I have a ques, that how can I search and then select the employee in the list option? As employee no may be very large and scrolling all will b time comsuming

[@PKAnExcelExpert]

Thanks for your valuable feedback. You can use combobox in place of listbox

[@amimahmad9699]

@@PKAnExcelExpert thank you

[@rijaskhan2003]

Excellent. how can we do the same process with multiple criteria

[@ALPHERATZ3650]

this video is great!!!

[@SyedMuzammilMahasanShahi]

amazing work. thanks

[@PKAnExcelExpert]

Thanks a lot

[@Xyour_starX]

You are the best

[@PKAnExcelExpert]

Thanks for your nice words

[@omkarkelshikar7484]

Very useful video sir

[@PKAnExcelExpert]

Thanks for your valuable feedback.

[@heshamlotfy2173]

Very useful my dear,,,

[@heshamlotfy2173]

Please I need to clarify what can we do if we have a different target per each employee

[@heshamlotfy2173]

Please if we have some employees reporting to different supervisors, can we use this example or we have another option

[@nasserawadh2722]

amazing . big thanks

[@PKAnExcelExpert]

Thanks for your valuable feedback

[@shj92922]

Thx man, can i make y axes always consistent automatically, because if i put max 10000 ot will solve it, put some target is less than 2000 and some is 100000

[@karthickenigoo2476]

Hi, Kindly clarify how to use the same method with 4 or 5 data points, eg, (Volume, Actual, Target, Balance). Can you make video for more data with 4, 5 staked columns, Thanks in advance

[@ArmanKhan-iq3ji]

Brother please make a video of sales enquiries booking and retail on dashboard

[@sanvibhalekar8947]

Nice

[@PKAnExcelExpert]

Thanks

[@dilipsingh-is5zu]

Mast technique

[@PKAnExcelExpert]

Thanks for your valuable feedback

[@dilipsingh-is5zu]

Mast guru

[@PKAnExcelExpert]

Thanks

[@shwetabisht1689]

Thanks for the tutorial sir, but how this chart can be made if all the employees have different targets.

[@go2mac]

still works, since you put different values from each of the staff.

[@ramanchandrangobalan2220]

thanks

[@noorm516]

Hi Can you please show actual sales vs target chart over the years

[@chiragkhuranaa]

I don't understand why did u select E1 to close the formula when ranging the employee selection.

[@TylehurstXL]

Great video! Question, how do you guarantee primary and secondary axis will have the same scale?

[@gdecome]

I think in the way it was built you have this risk ... different scales in some cases. An option to fix that would be two additional series with just one value (the maximum of both columns). One is the on the primary axis and the other in the second one. Change the format of this "point" to line (as one single point you won´t see anything in the screen because you need two points to create a line). In this way you can make sure both scales have the same size based on the maximum value of the two series.

[@TylehurstXL]

Gilberto Come yes! 😎

[@TylehurstXL]

Yes, that works 😎

[@nganhuynh3600]

Can we embed or make the same chart in PowerPoint?

[@spuneet156]

I had another method which seems bit tricky. It is better

[@catherinelinerte-hecken7855]

How can we do kind of the same but in a pie chart?

[@geethakonjeti2092]

Hi, I need your help to draw chart on monthly Vs YTD achievement

[@anjanajayananda7741]

Thans For shairaning these Excel Knlodge.can i contact you for for further advaces from you.

[@nehashah4714]

Can we have 2 different targets and 2 achievements for them ?

[@excelmylife1565]

Nice sir

[@RamRam-zv5od]

Very nice , your creation .thanks

[@PKAnExcelExpert]

Thanks for your valuable feedback

[@deepakjangra2076]

Hi this is very helpful but have a doubt so clear plz

[@deepakjangra2076]

i want to transpose the table as per requirement all employee show in one chart

[@robcox500]

Good videos, but KZbin is destroying your videos with too many ads. 9 ads in 14 mins.

[@TheTomar33]

Great video, but the ads are getting in the way.

[@kunalnarang2576]

can we have more than one target ?

[@PiXpilot_Shridhar]

If I need any help or suggestions how would I contact you..pls suggest

[@PKAnExcelExpert]

You can email me on [e-mail]

[@alandwikesumo7230]

How if the data is update?

[@RafiqulIslam-wv5to]

Microsoft office Version Details Please

[@toofanfeizi1353]

Hi I really need your help on Target ,Actual produced ,Target overachieved and Target not met Thanks for your help, if you contact me.

[@sajadbashar-doust8120]

Gramercy brother