Weekly Sales chart in Excel

[@Michael_Alaska]

Definitely one of the best charts I've seen for Excel. I created two charts side by side with one for employees and one for days of the week; then added a hidden scatter diagram to keep the scales the same on both. Looks great. Thanks.

[@PKAnExcelExpert]

Most welcome

[@misterwill3625]

I’ve never seen such a layered, informative chart! Cluster chart🤯Switch row/column data🤯You explained a complicated table in a simple way. Thank you 👏🏾That was magic 🪄

[@PKAnExcelExpert]

Thanks for your valuable feedback🙏

[@janicelayne9053]

PK you make some of the most creative charts I've seen on You tube. Your work is art! Thank you and keep letting the Lord use you to bless others!!!!

[@PKAnExcelExpert]

Wow, thank you!

[@sa5er1234]

I was stuck in this for the last 24 hours and no other video video how to do this. Well done mate.

[@PKAnExcelExpert]

Thanks

[@SeekerIam]

Fantastically made so easy to understand, We appreciate Sir!

[@PKAnExcelExpert]

Thanks🙏

[@triptabhattacharjee7004]

One of the best things I have found today. Thank you so much!

[@PKAnExcelExpert]

Thanks for your valuable feedback🙏

[@KulanthaiveluV]

Really fantastic. God bless you for the openness of sharing your skills. Thank you.

[@PKAnExcelExpert]

You are very welcome

[@lisakoski8620]

Thanks so much for sharing! Been struggling with large data set and how to formulate, this has helped very much! :)

[@PKAnExcelExpert]

Glad it helped!

[@lisay5302]

❤ another amazing chart tutorial!

[@PKAnExcelExpert]

Thank you! 😊

[@rafaelcaal]

Thank you for sharing this. That was an awesome chart, I'll definitely use that.

[@PKAnExcelExpert]

Most welcome

[@sondrad1839]

Excellent easy to follow instruction. Thank you

[@rajaanwarrajaabidin4196]

you are a genius my friend. thank you

[@PKAnExcelExpert]

Wow, thanks

[@tariqcassim786]

Very very nice Bhai Jaan! I always use your charts they are awesome!

[@PKAnExcelExpert]

Thanks

[@katsiarynaadamenka6459]

Thanks a lot for such a valuable video! It helped me a lot!

[@PKAnExcelExpert]

Glad it helped!

[@agirmas]

Thanks a lot for the tutorial video and the excel file! 🙌🏻

[@PKAnExcelExpert]

Most welcome🙏

[@PayongKaibigan]

Wow this is very useful 💚

[@PKAnExcelExpert]

Thanks for your valuable feedback

[@jigargalani441]

Your tutorial helped me complete a ppt for my weekly report.... Beautiful presentation and easy understanding

[@PKAnExcelExpert]

Thanks for your valuable feedback

[@tinachopra10]

You are brilliant,Sir . Thank you so much for teaching us in such an easy way.. 🙏😊

[@PKAnExcelExpert]

Thanks and welcome

[@querrythis]

Perfect for needs. Thanks again.

[@PKAnExcelExpert]

You're welcome!

[@carolmonteiro7790]

You are incredible! You ALWAYS suprise me!

[@PKAnExcelExpert]

Thanks for your valuable feedback

[@soujanyaappalla7971]

Amazing tips and Teaching Technique, Simple and crystal Clear, All the Best sir

[@PKAnExcelExpert]

Thanks for your valuable feedback

[@opioeric2847]

Very creative and useful as usual. Thank you Sir

[@PKAnExcelExpert]

You are welcome

[@PKAnExcelExpert]

Most welcome🙏

[@asadrao28]

Dear PK, you are doing wonderful work and giving us the opportunity to learn new ideas from you.Really you are GREAT.

[@PKAnExcelExpert]

Thanks for your valuable feedback

[@asadrao28]

Dear PK, please teach us how to use this Graph with Pivot table.Thanks for your continues support.

[@ariskayuliana8055]

you saved me! thanks for always being so helpful!

[@PKAnExcelExpert]

Thanks for your valuable feedback

[@ziarehman482]

What a great video sir....i actually learned a new skill bit today.. so happy

[@PKAnExcelExpert]

Thanks for your valuable feedback

[@theropilane4812]

Youre amazing man! ive been looking for this type of chart

[@PKAnExcelExpert]

Glad I could help!

[@dhananjaypinjan2643]

Amazing Chart.. Thanks PK..

[@PKAnExcelExpert]

Thanks for your valuable feedback

[@mohammedhasmi3826]

Thank Youuuu so much for sharing this particular chart, Biiiig Up

[@PKAnExcelExpert]

My pleasure

[@GebyThePhotographer]

4yrs old but still good, thank you!

[@PKAnExcelExpert]

Most welcome

[@luckymadhoo]

Very nicely explained... thank you brother

[@PKAnExcelExpert]

Thanks for your valuable feedback

[@amanahemad7828]

Hello Mr. Priendar Kumar - First of all thanks for your graphics in excel wonderful, mind blowing thanks alot I am successful 👍👍

[@PKAnExcelExpert]

Thanks Aman, for your appreciation. Request you to please share this with your friends and colleagues.

[@shifranmohamed6565]

@@PKAnExcelExpert hi I have 2007 version but some of the options are not available

[@Ananthunic]

Thank you !! Much Appreciated !!

[@PKAnExcelExpert]

You're welcome!

[@MadanKumar-uy4iu]

Excellent video and thanks for new information

[@PKAnExcelExpert]

Thanks for your valuable feedback

[@bonitabanana9342]

Hello! Thank you so much. You helped me a lot 😊

[@PKAnExcelExpert]

Thanks for your valuable feedback

[@nancys9566]

Thanks A Million! this was so interesting and inspiring. I can create very attractive and interesting ppt and reports :) Can't thank you enough. subscribed for life time :)

[@PKAnExcelExpert]

Thanks for your valuable feedback

[@olabanjid.akinpelu3762]

Loved this. Welldone and thank you for sharing.

[@PKAnExcelExpert]

Thanks for your valuable feedback

[@zoeyhorr]

thank you!!! that's amazing!!

[@PKAnExcelExpert]

You're welcome!!

[@dav4238]

Wonderful . Thank you so much.

[@PKAnExcelExpert]

Most welcome

[@bobby4395]

Bhai Gazab 👍

[@PKAnExcelExpert]

Thanks

[@daisyanthony4660]

Very well explained

[@PKAnExcelExpert]

Thanks for your valuable feedback🙏

[@nansri1]

Super.. Very useful.. Thank you

[@PKAnExcelExpert]

Thanks for your valuable feedback

[@moneytipstricksph7903]

Wow, I love your presentation on this.

[@PKAnExcelExpert]

Thanks for your valuable feedback

[@srimathi2408]

@@PKAnExcelExpert Sir, how do I contact you, please?

[@nagajyothi9698]

How we can contact sir

[@vishwakarmamadhusudhan4810]

Iam fond of excel..i like your charts and good to learn new things. 👍

[@PKAnExcelExpert]

Thanks for your valuable feedback

[@jacobmnisi]

thanks a lot you're so brilliant

[@PKAnExcelExpert]

Thanks for your valuable feedback

[@mvvjal]

Great job bro... God bless you

[@PKAnExcelExpert]

Thanks for your valuable feedback

[@rienthongw]

Thank you for sharing, you're very kind. It is very helpful.

[@PKAnExcelExpert]

Thanks for your valuable feedback

[@nsanch0181]

That is an excellent video. Beautify chart. Thank you so much for sharing. I'm now a subscriber!

[@PKAnExcelExpert]

Thanks for your valuable feedback and subscription 👍

[@suki9860]

Very nice. Thank you!

[@PKAnExcelExpert]

Thanks for your valuable feedback

[@unnikrishnansanthosh]

majestic , thank you for sharing

[@LearnersPage]

Super Sir .......

[@PKAnExcelExpert]

Thanks for your valuable feedback

[@deepaknundoosing994]

It's very useful for me. I will surely use this chart in my management meeting's presentation.

[@thakuranujsingh4419]

Excellent👏

[@PKAnExcelExpert]

Thanks🙏

[@festusco]

This is very insightful. Thank you

[@PKAnExcelExpert]

Thanks for your valuable feedback

[@alsuwilmi]

Thanks 🙏🏻 so much 👌🏼🌟🌟🌟

[@PKAnExcelExpert]

Most welcome

[@gilsoncosta6869]

More beautiful and praticte, congratulations.

[@PKAnExcelExpert]

Thanks for your valuable feedback

[@datascientist6233]

Excellent sir..

[@PKAnExcelExpert]

Thanks a lot🙏

[@abdelhadia8712]

Thanks a lot professor

[@PKAnExcelExpert]

Most welcome

[@pandharinathjoshi6565]

Nice sir, explanation👍

[@bricc322]

Very creative and useful as usual. Thank you, PK!

[@PKAnExcelExpert]

Thanks Celia for your valuable feedback.

[@gagansaluja5523]

amazing video, helped me a lot! Thank you so much for sharing

[@PKAnExcelExpert]

Thanks for your valuable feedback

[@mileshuang8489]

Fabulous tuition! Subscribed, like it and will share with my friends!

[@PKAnExcelExpert]

Thanks for your valuable feedback

[@deysmisaj]

Very interesting way for presenting your data!!!

[@PKAnExcelExpert]

Thanks for your valuable feedback.

[@busyshah]

Superb chart.

[@PKAnExcelExpert]

Thanks a lot

[@mashokhan8811]

Excellent superb

[@PKAnExcelExpert]

Thanks a lot

[@m.raedallulu4166]

That was smart!

[@PKAnExcelExpert]

Thanks

[@Virat20242]

Awesome work

[@PKAnExcelExpert]

Thanks for your valuable feedback

[@Ham_1982]

Great work, thank you!

[@PKAnExcelExpert]

Thanks for your valuable feedback

[@prabhakarpawar573]

जबरदस्त व्हिडिओ है sirji

[@PKAnExcelExpert]

Thanks Prabhakar

[@theaparitchit]

Awesome!!!!!

[@PKAnExcelExpert]

Thanks🙏

[@pablom8863]

I really apreciate this. Thank you very much. I follow you from México

[@PKAnExcelExpert]

Thanks for your valuable feedback

[@DiamondDiamondHeart]

So good! Best one I've seen and easy to follow! I can't want to use it

[@controlz2010]

Appreciate your efforts really really you are good man, thanks

[@PKAnExcelExpert]

Thanks Ali for your valuable feedback

[@kuuuyajim]

Love it!

[@PKAnExcelExpert]

Thanks for your valuable feedback

[@maribethem2616]

Perfect!

[@PKAnExcelExpert]

Thanks

[@ammcclellan9760]

Brilliant!

[@PKAnExcelExpert]

Thanks for your valuable feedback

[@KNLP23]

Jolly good, sar!

[@PKAnExcelExpert]

Thanks for your valuable feedback

[@RameshPatel-fg9qk]

Nice,Very Fine

[@PKAnExcelExpert]

Thanks for your valuable feedback🙏

[@MagdyTawfikA]

Thank you man for this one!

[@rajeshsomayaji6598]

Thanks so much mate

[@PKAnExcelExpert]

Happy to help

[@jackjimenezpereda9252]

Excelente trabajo mi amigo..!!! un abrazo

[@vincentpuchalt9683]

excellent as usual...thanks PK

[@PKAnExcelExpert]

Thanks for your valuable feedback

[@nikitharebello]

Thank you :)

[@PKAnExcelExpert]

You're welcome!

[@pawansharma-wo3xh]

Beautiful chart.... Great creativity pk You always rocks..... Keep it up.....

[@PKAnExcelExpert]

Thanks Pawan

[@mukulchauhan19]

Keep up the good work..I m ur fan now

[@PKAnExcelExpert]

Thanks for your valuable feedback

[@sirius6782]

Great 👏

[@shazee32]

Nice work you r great man

[@PKAnExcelExpert]

Thanks for your valuable feedback

[@Mr_ELF]

Good JOb!

[@PKAnExcelExpert]

Thanks

[@iftekharraju318]

Thank you for the wonderful work

[@PKAnExcelExpert]

Thanks for your valuable feedback

[@farooq346]

I like your tutorial

[@PKAnExcelExpert]

Thanks

[@huaanh7769]

thank you. very useful.

[@PKAnExcelExpert]

Thanks for your valuable feedback

[@joses.pacheco3069]

Explicação maravilhosa. Parabéns!

[@sriyantocakep]

Cool this..never been seen before

[@PKAnExcelExpert]

Thanks for your valuable feedback

[@AshishKumar-dc2zd]

Excellent Job.......

[@PKAnExcelExpert]

Thanks for your valuable feedback

[@smarttraderrs]

its great learning sir from u, awesome chart which can make my boss droll

[@itash22]

Hi! I have been looking to learn how to add shaded bars over my forecast&actual chart. I want all weeks prior to my current week to be filled with a Gray shade so that I cannot see it. I think I can follow what you just showed us with the Bottom line. I think I would need to add a new data series with a formula that checks if the calendar week is before or after todays calendar week, and if it is before, then I just need to know how. Would I set the formula to be equal to 0 and/or 1? Or is it best to use conditional formatting?

[@scm.prashant]

Excellent Graph !

[@PKAnExcelExpert]

Thanks Prashant

[@elakkiyaful]

Lovely sir

[@PKAnExcelExpert]

Thanks for your valuable feedback

[@monu6356]

How can one get the same total umbrella in case of clustered stacked combinational bar graph chart

[@PKAnExcelExpert]

Great suggestion! I will try to create a video on this topic.

[@vermaswaraj11]

I don't know how much Thanks should I say to you. Wonderful explanation and presentation. You make the hardest things in a simple way. Thank you so much for the lovely video. How should I join your class?

[@PKAnExcelExpert]

Thanks a lot.

[@barivp82]

Chart specialist 👍

[@PKAnExcelExpert]

Thanks for your valuable feedback