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

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

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

[@PayongKaibigan]

Wow this is very useful 💚

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

[@desilinaabdul5537]

I'm not be able to produce as your graph chart.. it's does not appear as you show for transparent options.. Kindly assist. Thank You.

[@tinachopra10]

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

[@PKAnExcelExpert]

Thanks and welcome

[@sabhattibhatti726]

please share the excel file .

[@PKAnExcelExpert]

Please download the excel file from the link given in videos description box or visit our website www.pk-anexcelexpert.com

[@SeekerIam]

Fantastically made so easy to understand, We appreciate Sir!

[@PKAnExcelExpert]

Thanks🙏

[@rajeshsomayaji6598]

Thanks so much mate

[@PKAnExcelExpert]

Happy to help

[@vickybhojwani4562]

Hi sir, need u r help for freeze panes n how we can freeze multiple coloumns n rows in tables

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

[@aks6865]

after turning my total to a line chart my up and down bars are not coming up after ticking the box

[@pandharinathjoshi6565]

Sir, why you have taken bottom line, just added and deleted sir..

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

[@mohammedhasmi3826]

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

[@PKAnExcelExpert]

My pleasure

[@jigargalani441]

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

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

[@rukmagar-v1z]

excelent bhai. can make video on multiple chart link one button.

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

[@nikitharebello]

Thank you :)

[@PKAnExcelExpert]

You're welcome!

[@Mr_ELF]

Good JOb!

[@PKAnExcelExpert]

Thanks

[@aditisood7319]

Make a clear video sir.. in full hd with with big letter

[@dheerajsah]

Hi PK I have a small issue, when I create the chart I do not get the chart based on Days(coloumns), but I get it based on Names(Rows), so when I switch the row/coloumn all the totals are clustered in the end and hence this method does not work. Can you please help

[@rienthongw]

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

[@PKAnExcelExpert]

Thanks for your valuable feedback

[@danielteague2300]

Good presentation! Would have been better without the popups and commercials.

[@PKAnExcelExpert]

Thanks for your valuable feedback.

[@gurubalaful]

nice sir

[@PKAnExcelExpert]

Thanks

[@peerlavenkateswarluvenki9969]

I need training excel please when start new batch sir

[@rayymonst3743]

Can u try in google sheet docs....

[@tariqcassim786]

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

[@PKAnExcelExpert]

Thanks

[@KulanthaiveluV]

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

[@PKAnExcelExpert]

You are very welcome

[@humairaahmed5762]

thanks

[@PKAnExcelExpert]

Welcome

[@theropilane4812]

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

[@PKAnExcelExpert]

Glad I could help!

[@ziarehman482]

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

[@PKAnExcelExpert]

Thanks for your valuable feedback

[@sagy89]

How can I compare for 2 weeks in one chart??

[@neerajroy8010]

Sir please tell me
App kaunse windows use karte ho

[@LearnersPage]

Super Sir .......

[@PKAnExcelExpert]

Thanks for your valuable feedback

[@katsiarynaadamenka6459]

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

[@PKAnExcelExpert]

Glad it helped!

[@factsfactory2768]

please make same to monthly with atv and upt

[@HanNguyen-jm6jd]

I don't know why when I select color in format down bars, Color in bar not change color like as video. Please help me

[@fasyinabda2472]

same with my case

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

[@lisay5302]

❤ another amazing chart tutorial!

[@PKAnExcelExpert]

Thank you! 😊

[@agirmas]

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

[@PKAnExcelExpert]

Most welcome🙏

[@triptabhattacharjee7004]

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

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

[@luckymadhoo]

Very nicely explained... thank you brother

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

[@minhlinhtinhkhong7327]

Please help me, when I click on "Up/down Bar". Nothing happens. No column that have color dropped down. I am using MS 2019. Thank you.

[@Ananthunic]

Thank you !! Much Appreciated !!

[@PKAnExcelExpert]

You're welcome!

[@bhmsupra]

"total of the "beek"....LoL

[@MadanKumar-uy4iu]

Excellent video and thanks for new information

[@PKAnExcelExpert]

Thanks for your valuable feedback

[@varunkhanor]

Why you chose bottom line?

[@ariskayuliana8055]

you saved me! thanks for always being so helpful!

[@PKAnExcelExpert]

Thanks for your valuable feedback

[@benmesoudmohammed5820]

Hi friend,
I'm working on call center actually and looking to learn the strategy for achieving kpis by week and month. I've 6 kpis. Thank you in advance freind.

[@bonitabanana9342]

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

[@PKAnExcelExpert]

Thanks for your valuable feedback

[@dav4238]

Wonderful . Thank you so much.

[@PKAnExcelExpert]

Most welcome

[@gagansaluja5523]

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

[@PKAnExcelExpert]

Thanks for your valuable feedback

[@alsuwilmi]

Thanks 🙏🏻 so much 👌🏼🌟🌟🌟

[@PKAnExcelExpert]

Most welcome

[@GebyThePhotographer]

4yrs old but still good, thank you!

[@PKAnExcelExpert]

Most welcome

[@mohammedaltaf4877]

If you can make this chart with pivot will be helpful to make dashboard

[@PKAnExcelExpert]

I will definitely try to make this chart with Pivot table at the earliest.

[@querrythis]

Perfect for needs. Thanks again.

[@PKAnExcelExpert]

You're welcome!

[@mileshuang8489]

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

[@PKAnExcelExpert]

Thanks for your valuable feedback

[@theislamiaeducationacademy]

this Excel is 2010 ?

[@rajaanwarrajaabidin4196]

you are a genius my friend. thank you

[@PKAnExcelExpert]

Wow, thanks

[@kuuuyajim]

Love it!

[@PKAnExcelExpert]

Thanks for your valuable feedback

[@jacobmnisi]

thanks a lot you're so brilliant

[@PKAnExcelExpert]

Thanks for your valuable feedback

[@ammcclellan9760]

Brilliant!

[@PKAnExcelExpert]

Thanks for your valuable feedback

[@dhananjaypinjan2643]

Amazing Chart.. Thanks PK..

[@PKAnExcelExpert]

Thanks for your valuable feedback

[@monjurmorshed5166]

How can we use condional colours on per days acv, example if it's greater the 70 it will be green if its less then 70 will be read, total also will be in same format, is it possible??

[@gilsoncosta6869]

More beautiful and praticte, congratulations.

[@PKAnExcelExpert]

Thanks for your valuable feedback

[@nansri1]

Super.. Very useful.. Thank you

[@PKAnExcelExpert]

Thanks for your valuable feedback

[@zoeyhorr]

thank you!!! that's amazing!!

[@PKAnExcelExpert]

You're welcome!!

[@opioeric2847]

Very creative and useful as usual. Thank you Sir

[@PKAnExcelExpert]

You are welcome

[@PKAnExcelExpert]

Most welcome🙏

[@emueyakiemmanuel6033]

This is good but the small multicolored columns are not showing in print preview

[@joses.pacheco3069]

Explicação maravilhosa. Parabéns!

[@suki9860]

Very nice. Thank you!

[@PKAnExcelExpert]

Thanks for your valuable feedback

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

[@vishwakarmamadhusudhan4810]

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

[@PKAnExcelExpert]

Thanks for your valuable feedback

[@unnikrishnansanthosh]

majestic , thank you for sharing

[@luisfernandocuestasanchez4343]

Thanks a lot ¡¡¡

[@olabanjid.akinpelu3762]

Loved this.
Welldone and thank you for sharing.

[@PKAnExcelExpert]

Thanks for your valuable feedback

[@sondrad1839]

Excellent easy to follow instruction. Thank you

[@bensonabraham859]

Thanks much.

[@huaanh7769]

thank you. very useful.

[@PKAnExcelExpert]

Thanks for your valuable feedback

[@heliosonline9575]

Hello Sir,...tell me one think how to create a days wise total separate in grand total

[@mashokhan8811]

Excellent superb

[@PKAnExcelExpert]

Thanks a lot

[@abdelhadia8712]

Thanks a lot professor

[@PKAnExcelExpert]

Most welcome

[@busyshah]

Superb chart.

[@PKAnExcelExpert]

Thanks a lot

[@sunnybaggu785]

Hii...Can we draw a tetrahedron with known 3d (x,y,z) coordinates in excel chart

[@abhksa123]

How can we increase the day column height as it is looking very small.

[@sriyantocakep]

Cool this..never been seen before

[@PKAnExcelExpert]

Thanks for your valuable feedback

[@Ham_1982]

Great work, thank you!

[@PKAnExcelExpert]

Thanks for your valuable feedback

[@sirius6782]

Great 👏

[@ajoobmedia]

nice excel tutorial.thank you

[@PKAnExcelExpert]

Thanks for your valuable feedback

[@kimkheangphy6767]

Can we do this type of chart in PowerBI?

[@rzv_sd3720]

I wonder if there is any chance to have each column , other colour :(
for example like : John is red, PK is blue etc

[@mumbaitiger]

Can you add slicers fir weeks e.g week 1 , week 2 etc. as well as for months and a comparison chart between weeks (previous vs current) as well as months (previous and current) and for previous and current years.

[@shazee32]

Nice work you r great man

[@PKAnExcelExpert]

Thanks for your valuable feedback