Weekly Sales chart in Excel

Hello Friends,
In this video you will learn how to create a beautiful Weekly Sales Chart in Excel.
Please download this excel file from below given link:
www.pk-anexcelexpert.com/week...
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...
Telegram:
t.me/joinchat/AAAAAE2OnviiEk5...
Twitter:
/ priyendra_kumar
Pinterest:
/ pkanexcelexpert
Send me your queries on telegram:
@PKanExcelExpert

[@ccastellanos1972]

Excelente trabajo, gracias por compartir tu habilidad.

[@joses.pacheco3069]

Explicação maravilhosa. Parabéns!

[@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!

[@teenachopra1835]

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

[@PKAnExcelExpert]

Thanks and welcome

[@DiamondDiamondHeart]

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

[@smarttraderrs]

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

[@bricc322]

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

[@PKAnExcelExpert]

Thanks Celia for your valuable feedback.

[@rienthongw]

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

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

[@jackjimenezpereda9252]

Excelente trabajo mi amigo..!!! un abrazo

[@carolmonteiro7790]

You are incredible! You ALWAYS suprise me!

[@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

[@sondrad1839]

Excellent easy to follow instruction. Thank you

[@KulanthaiveluV]

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

[@PKAnExcelExpert]

You are very welcome

[@triptabhattacharjee7004]

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

[@PKAnExcelExpert]

Thanks for your valuable feedback🙏

[@pablom8863]

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

[@PKAnExcelExpert]

Thanks for your valuable feedback

[@MagdyTawfikA]

Thank you man for this one!

[@ariskayuliana8055]

you saved me! thanks for always being so helpful!

[@PKAnExcelExpert]

Thanks for your valuable feedback

[@gilsoncosta6869]

More beautiful and praticte, congratulations.

[@PKAnExcelExpert]

Thanks for your valuable feedback

[@olabanjid.akinpelu3762]

Loved this. Welldone and thank you for sharing.

[@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

[@SeekerIam]

Fantastically made so easy to understand, We appreciate Sir!

[@PKAnExcelExpert]

Thanks🙏

[@soujanyaappalla7971]

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

[@PKAnExcelExpert]

Thanks for your valuable feedback

[@vishwakarmamadhusudhan4810]

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

[@PKAnExcelExpert]

Thanks for your valuable feedback

[@user-yc7ir9qk1f]

Thank sir. my boss really like it!

[@PKAnExcelExpert]

Thanks for your valuable feedback

[@janerravelo9187]

Excelente... Muchas Gracias...

[@PKAnExcelExpert]

Gracias por sus valiosos comentarios

[@gagansaluja5523]

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

[@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

[@querrythis]

Perfect for needs. Thanks again.

[@PKAnExcelExpert]

You're welcome!

[@iftekharraju318]

Thank you for the wonderful work

[@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 👍

[@deysmisaj]

Very interesting way for presenting your data!!!

[@PKAnExcelExpert]

Thanks for your valuable feedback.

[@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

[@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

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

[@festusco]

This is very insightful. Thank you

[@PKAnExcelExpert]

Thanks for your valuable feedback

[@mileshuang8489]

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

[@PKAnExcelExpert]

Thanks for your valuable feedback

[@unnikrishnansanthosh]

majestic , thank you for sharing

[@theropilane4812]

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

[@PKAnExcelExpert]

Glad I could help!

[@luckymadhoo]

Very nicely explained... thank you brother

[@PKAnExcelExpert]

Thanks for your valuable feedback

[@agirmas]

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

[@PKAnExcelExpert]

Most 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!

[@pawansharma-wo3xh]

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

[@PKAnExcelExpert]

Thanks Pawan

[@jmarvel1802]

Wow, Thank you so much PK

[@PKAnExcelExpert]

Thanks for your valuable feedback

[@bonitabanana9342]

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

[@PKAnExcelExpert]

Thanks for your valuable feedback

[@katsiarynaadamenka6459]

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

[@PKAnExcelExpert]

Glad it helped!

[@rajaanwarrajaabidin4196]

you are a genius my friend. thank you

[@PKAnExcelExpert]

Wow, thanks

[@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

[@mvvjal]

Great job bro... God bless you

[@PKAnExcelExpert]

Thanks for your valuable feedback

[@ronalddmello9321]

Hi Sir, Thanks for this wonderful tutorial. Can you let me know if we can illustrate quarterly results using this chart? I want to show the results for more than 8 quarters.. Please reply

[@MadanKumar-uy4iu]

Excellent video and thanks for new information

[@PKAnExcelExpert]

Thanks for your valuable feedback

[@rafaelcaal]

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

[@PKAnExcelExpert]

Most welcome

[@tienngotk]

Very interesting, thanks for sharing.

[@PKAnExcelExpert]

Thanks for your valuable feedback

[@gwengwen7435]

THANK YOU SO MUCH!!

[@PKAnExcelExpert]

Thanks for your valuable feedback

[@PayongKaibigan]

Wow this is very useful 💚

[@PKAnExcelExpert]

Thanks for your valuable feedback

[@vincentpuchalt9683]

excellent as usual...thanks PK

[@PKAnExcelExpert]

Thanks for your valuable feedback

[@Ananthunic]

Thank you !! Much Appreciated !!

[@PKAnExcelExpert]

You're welcome!

[@mukulchauhan19]

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

[@PKAnExcelExpert]

Thanks for your valuable feedback

[@mao082]

Thank you for sharing sir :)

[@PKAnExcelExpert]

Thanks for your valuable comments. Please share it with your friends and colleagues.

[@Ham_1982]

Great work, thank you!

[@PKAnExcelExpert]

Thanks for your valuable feedback

[@gopigopichand4379]

Really enjoyed.. thank you..

[@PKAnExcelExpert]

Thanks for your valuable feedback

[@dhananjaypinjan2643]

Amazing Chart.. Thanks PK..

[@PKAnExcelExpert]

Thanks for your valuable feedback

[@scm.prashant]

Excellent Graph !

[@PKAnExcelExpert]

Thanks Prashant

[@mlspradeep]

Thank you, it is lovely

[@PKAnExcelExpert]

Thanks for your valuable feedback

[@dav4238]

Wonderful . Thank you so much.

[@PKAnExcelExpert]

Most welcome

[@opioeric2847]

Very creative and useful as usual. Thank you Sir

[@PKAnExcelExpert]

You are welcome

[@PKAnExcelExpert]

Most welcome🙏

[@pandharinathjoshi6565]

Nice sir, explanation👍

[@huaanh7769]

thank you. very useful.

[@PKAnExcelExpert]

Thanks for your valuable feedback

[@abrahamsalazaraguirre2048]

Eres el puto amo!

[@GebyThePhotographer]

4yrs old but still good, thank you!

[@PKAnExcelExpert]

Most welcome

[@majidsiddique8227]

really fantastic

[@gilsoncosta6869]

ESPECTULAR, GREAT.

[@PKAnExcelExpert]

Thanks for your valuable feedback

[@lucianoribeiro7639]

Very Nice, thanks so much

[@PKAnExcelExpert]

Thanks for your valuable feedback

[@ajoobmedia]

nice excel tutorial.thank you

[@PKAnExcelExpert]

Thanks for your valuable feedback

[@nansri1]

Super.. Very useful.. Thank you

[@PKAnExcelExpert]

Thanks for your valuable feedback

[@keano08]

Hi there, thanks for creating this video. I am using Excel 2010 and can't work out how to change the size of the up/down bars. When selecting the bars and then going to the layout tab, adjusting the size is greyed out and not an option. Do you know if there is a workaround for this?

[@barivp82]

Chart specialist 👍

[@PKAnExcelExpert]

Thanks for your valuable feedback

[@alsuwilmi]

Thanks 🙏🏻 so much 👌🏼🌟🌟🌟

[@PKAnExcelExpert]

Most welcome

[@controlz2010]

Appreciate your efforts really really you are good man, thanks

[@PKAnExcelExpert]

Thanks Ali for your valuable feedback

[@hayatikoc9929]

Teşekkürler Harika

[@prabhakarpawar573]

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

[@PKAnExcelExpert]

Thanks Prabhakar

[@casper3842]

Still the master!

[@jacobmnisi]

thanks a lot you're so brilliant

[@PKAnExcelExpert]

Thanks for your valuable feedback

[@reddinaidu6082]

Hi Sir, Thank you very much for your video. if any zero (0) values in the table how we can skip or eliminate the gaps.

[@mansurahmad2699]

Thank You PK

[@PKAnExcelExpert]

Thanks for watching

[@datascientist6233]

Excellent sir..

[@PKAnExcelExpert]

Thanks a lot🙏

[@jhamca10]

Really you are doing a great work. You are introducing new new things. PK I have an Query I wanted to create one Speedometer with maximum Average score is 7 how Can I create this speedo meter kindly give me some suggestion for taking the data.

[@ammcclellan9760]

Brilliant!

[@PKAnExcelExpert]

Thanks for your valuable feedback

[@KNLP23]

Jolly good, sar!

[@PKAnExcelExpert]

Thanks for your valuable feedback

[@shazee32]

Nice work you r great man

[@PKAnExcelExpert]

Thanks for your valuable feedback

[@zoeyhorr]

thank you!!! that's amazing!!

[@PKAnExcelExpert]

You're welcome!!

[@AshishKumar-dc2zd]

Excellent Job.......

[@PKAnExcelExpert]

Thanks for your valuable feedback

[@ranasaqib372]

that's amazing. keep it up :)

[@PKAnExcelExpert]

Thank you! 😊

[@andrewalfred3473]

This is outstanding

[@PKAnExcelExpert]

Thanks for your valuable feedback

[@suki9860]

Very nice. Thank you!

[@PKAnExcelExpert]

Thanks for your valuable feedback

[@abdelhadia8712]

Thanks a lot professor

[@PKAnExcelExpert]

Most welcome

[@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?

[@birendraprasadsah5517]

Great video!

[@PKAnExcelExpert]

Thanks for your valuable feedback