Excel Pivot Chart with Slicers for Months to Show Values by Weekday Names

[@LeilaGharani]

Grab the file I used in the video from here 👉 pages.xelplus.com/weekday-slicer-file

[@yerbolabzhamiyev3268]

I can't stop watching Leila's videos! They are so interesting!

[@brianbruno4749]

Leila....2.5M subscribers? Wow! And the content is fantastic. I consider myself an expert in Excel, but I've just never had a reason to use pivot tables. This is just what the doctor ordered. Thanks

[@wrivers6412]

Finding your videos was the best thing ever!!! I've learned so much about excel and over the last two weeks that I've actually applied what I learned to some projects at work!!! Not only am I happy but my Leadership team at work is also happy!!!

[@LeilaGharani]

That's GREAT! I'm really happy to hear that! Thanks for sharing :) You've done the difficult part which is applying what you learnt to your own work.

[@ChristyCorum]

I always look specifically to you, Leila. Great explanations, Easy to understand, Concise! Thank you, Thank you, Thank you!

[@rachaelhuntley4905]

Just found you - you are amazing and the examples/lessons you give are the easiest to follow and you give the best explanations - thank you

[@2808drw]

I love her way talking 👍 Her language so easy to understand and explantion is clear 👏👏👏

[@evgeniam8882]

Excel-lent video and this slicer format I was searching for a while finally it came to me! Thank you so much Leila!!

[@puranyashkapoor7468]

I am really blown away by the beauty of what you can create in excel. Keep it up !

[@LeilaGharani]

Thanks, will do!

[@craigvoss1468]

I like how you take a simple chart and slicer, and turn it into something that looks so nice.

[@LeilaGharani]

what is that quote? "simplicity is the ultimate sophistication" :)

[@MIRZA1515]

I'm grateful for your tutorials. As an old-school guy, I have been learned a lot thanks to you.

[@LeilaGharani]

Thanks for the kind words Erhan!

[@gautierlaurent2476]

Just discover your channel a few days ago, yours videos are awesome. Simple and precise explanations to get what you want to do. Thank you very much for your teaching... and for us!

[@LeilaGharani]

My pleasure. Glad to have you here!

[@ramlan8581]

To tell the truth , your explanation is 100% times better than my school teacher. Thanks a lot this is really gonna help me in my exams tomorrow ☺😊

[@LeilaGharani]

Good luck for tomorrow!

[@jrobinson8898]

Leila you never cease to amaze me!! Thank you for your easy to follow yet super informative vids!♥️

[@LeilaGharani]

You are so welcome!

[@rickfuqua]

I love all the info I learn from you. You make it easy to understand. Thanks!!!

[@LeilaGharani]

You are so welcome, Rick!

[@asiflangha]

You are superb. your examples are super easy to understand and likely to engage the viewer. Excellent job.

[@LeilaGharani]

Thank you for the kind feedback.

[@gjeess1]

Another excellent video, that provides clear instructions for the end-user. Thank you.

[@rvibrahim]

Your videos are really awesome! Excellent demos/examples that you present offers us a great learning experience.

[@Adam_K_W]

It's easier to use the TEXT function than it is to use the WEEKDAY function. Just type =TEXT(A2,"DDDD"), that will populate the fully spelled out day "TUESDAY", or type =TEXT(A2,"DDD") will give you the 3 letter abbreviation of the day, ie. "Tue"... That will save you from having to navigate the WEEKDAY function. This also works with months by typing "MMM" or "MMMM".

[@roderickmose4691]

@F yes, but the Pivot table doesn't seem to like the =A2 option.

[@miraskhabibulla1345]

Your tutorials are amazing! Concise and straight to the point

[@1970mariano]

Leila, your videos are excellents and addictive. Thanks for sharing

[@sasarakayuhuu8035]

OMG you are brilliant... Thanks I really need it as I am creating a dashboard now. Wish for your happiness and success in life!

[@LeilaGharani]

Glad you can apply it to your dashboard :) You're very welcome Sasaraka.

[@archanamuppidi14]

Your videos provide so much to learn... I hv subscribed to so many other excel videos... but your videos provide every detail and huge information and clarity.... thank u so much for your help...

[@LeilaGharani]

Thank you so much for subscribing! I’m glad you find the videos helpful.

[@michaeldiamond2726]

Great Video Leila - like your explanation on some of the in's and outs of how to manipulate a slicer. Keep them coming!

[@LeilaGharani]

Glad to hear that Michael. You're very welcome.

[@patriceairoldi]

Very good explanations, now I know better how to create a pivot chart. Thanks for this very good video Leila !

[@LeilaGharani]

Happy to hear that Patrice!

[@tristangeoffroy9286]

Thank you for the explanation on how customising slicer, .. very stylish as always with your tutorials, ...and a very sweet voice. thank you

[@sadavies2906]

Love the videos Leila very easy to follow and results are great. In this example is it easy to include all week days in the pivot table and subsequent chart if there isn’t and data for the day in the table. Obviously as you use the slider the chart changes based on the data but would like to have 7 days showing all the time with blanks if nothing was on a Monday for example

[@Rascalini19]

You are so Awesome! Very easy to follow along... Thank you so much!!!

[@nsanch0181]

You've helped me so much with charts and graphs. Thanks Leila!

[@LeilaGharani]

You're very welcome!

[@eg_ak84]

New sub! Wow! Blown away with the content. Such quality, beauty, and knowledge all jam packed in each video! (Thank you, KZbin!)

[@kHoPhAe]

Wow, I'm glad I subscribed, your channel is a gold mine, thank you!

[@LeilaGharani]

I'm glad to hear that :)

[@Zabikhan14]

Thank you so much.. ur video's not only motivate but also a way of solution.... thanks alot

[@torgal786]

You are a wonderful and Excel Google for all of us...

[@shafikhan100]

I regular learn from your videos, request you to make an end to end video on pivot tables from basics to extremely advanced (A-Z)

[@amrelmashwady]

thank you so much , each lecture I learn thing new in" excel "from you

[@LeilaGharani]

That's great to hear Amr! You're very welcome.

[@charlesjames5965]

Leila can you please share your email for us to have those lectures even if it costs no matter

[@nickybanya3206]

Hi Leila, your excel skills are excellent and very much effective in workforce management. This slicer is really nice. Can you please help with one click dashboard skills please.

[@resrussia]

Good explanation and suggestion for adding days of week to a pivot chart. I would have never thought of using the format to convert a date to the day of week. My solution was use the TEXT function. Keep up the excellent work.

[@LeilaGharani]

Thanks Training Research. Glad you found it useful :)

[@javelpalmer]

Perfect! What's the easiest way to Import Data from the stock market Website to Excel? With this Pivot style.

[@mohitverma8190]

Hi Leila, Looking forward for your reply as i have a doubt after practicing. Slicer is able to control pivot and pivot chart, however data is not organised with the slicer. Is there a way that all three ( Data, Pivot Table, Pivot Chart) are controlled with single slicer. In your video as well it is same.

[@ozlemcivan7455]

Hey there, thanks for the great vid, one question how can i use pivot charts with a table of data which expands every month. So the amount of data just gets larger and larger every day can pivot handle that ? Kind Regards

[@mans0011]

Thanks again for another great video. How would you force the chart to show empty weekdays? Don’t want to see Sunday then Tuesday, for example.

[@tamimsajid]

a beautiful video from a beautiful soul. Thanks a lot.

[@LeilaGharani]

You're very welcome. Glad you like the video 😊

[@malcbatotony9518]

Thanks Leila. Very happy with this video.

[@LeilaGharani]

You're welcome 😊

[@veebee3969]

Very helpful. Great video.

[@tsauraiketiwa1086]

You are just good in this.

[@luisguillermoperezmejia7907]

Excelente aporte. Quedó suscrito. Cordiales saludos desde Medellín Colombia.

[@Mineirovsky]

I liked it very much. It's just what I'm looking for. Thanks!

[@sheenaachyuthan428]

Awesome, thank you so much for showing the slicer function along with pivot chart.

[@travelwithwings9674]

You are amazing.. What a great way of explaining this concept 👏

[@LeilaGharani]

Thanks a lot 😊

[@wout_s]

Thanks very much, especially for the formatting of the slicer! I have one problem though: when I click on the slicer, the cursor always jumps to the pivot chart. Is there any way to stop this from happening? I don't see it in your video!

[@yanmike5212]

Thank you so much for imparting the knowledge

[@rnjy20]

it wouldn't be a problem if i tell someone that you invented the Excel, as its totally believable :D you know the options so well

[@Rice0987]

Like for Leila as always! I'm using pivots and slicers for a long time, but some moments was interesting for me. So, thank you!

[@LeilaGharani]

Glad you found something useful John. Thanks for your support.

[@Rice0987]

@@LeilaGharani Thank you! Please, dont stop to explore of excel magic and share with us. 😊

[@mykidwholovesminecraft7092]

I like your Excel video. Very informative. But if i have a pivot slicer how can i retrieve information using count

[@irviantantohadiprasetyo689]

It's very useful. Thanks, Leila

[@LeilaGharani]

My pleasure. I'm glad the video is useful.

[@viptech3491]

I am big fan your video's I am learning and learnt a lot from your video's. one word to describe Excellent

[@LeilaGharani]

Very happy to hear that YoTech :)

[@sanyuktarajgolikar9851]

hi leila, firstly thanks for the lucid lessons/ example.. secondly how to share excel workbook which contains slicers controlled charts? protected excel prevents slicer usage whereas unlocked sheet gives user scope of disarranging the layout etc Pls advise

[@AndreaUK1973]

Hi Leila! Hope you’re well! Do you have a tutorial for building a Dynamic Employee’s Annual Leave spreadsheet ? I can’t find one in your channel!

[@uningeniero3343]

Oro, puro oro por estos rumbos.

[@stephengibson100]

These are wonderful. I'm learning so much, and building my own file of templates. Thanks so much.

[@LeilaGharani]

I'm glad you find these useful Stephen.

[@frederikjrvanbruggen]

thanks for your examples, but how do you do that: date and automatically weekday, months, etc. Frits from Holland

[@iloveyoumadhuri]

Hi Leila! I had difficulty getting the Months slicer into my pivot table for my Mac. At the 6:30 part, where I had to remove my original slicer, I could not get months by clicking on the dates in the Pivot Chart Fields like you. Is it possible to get help from you?

[@LeilaGharani]

Sorry, I don't have Mac in the office. Maybe someone else from the community can help out.

[@jitendragupta78]

I learnt so many things like how to have multiple columns in slicers, how to make charts much more presentable..

[@englishbobshousemusic]

Hi Leila. I am trying to make a dashboard. It has multiple slicers controlling a pivot table. I want to stop the automatic sorting that happens to the slicers when selecting something. Do you have a solution for this. Great channel.

[@asadmahboob1123]

Hi Leilal, Thank you for the video. It's very informative. Is there a way to show the data label on a chart only when one single button on a slicer is selected/clicked? If filter is cleared on the slicer, I don't want the data level to be displayed as it will get clumsy.

[@jessiesi1412]

Thanks for making so many great excel videos. These are so useful in the work. I have a question about slicer. If you have multiple slicers, is there a way to make them stay at the same place not collapse? One day I tried to add multiple slicers and adjust them the size I liked. However, when I tried to play with them, I found by select different categories, these slicers will move and not stay at the same position I organized first. Do you have an idea why? By the way, could we link the slicers to a different pivot table which we used the same data source? Could you please advice me? Thank you.

[@yogalekshumimarimuthu2173]

Thank you Leila, can you do a calendar dashboard using this slicer please ..

[@rajamanikamr4779]

Thank you for you excel training, since I have developed Excel knowledge.from your videos

[@LeilaGharani]

You're very welcome! I'm glad you enjoy the tutorials.

[@hassanmburia8825]

I have created my team dashboard through the slice be blessed

[@s.miller7444]

You make it seem so easy and effortless. Thanks Do you have any lessoons with data to practice with?

[@iziaurrahman]

Learnt so much from this tutorial. Excellent stuff!

[@jayrichzhanra4988]

You are amazing!!! Thank you for your time and effort. I really appreciate. This is very useful to me.

[@LeilaGharani]

I'm very happy you find the content useful! Thank you for the nice comment :)

[@Pecintakebenaran]

Very nice tutorial...very helpfull...how to analyze data with merge colom few subheader, please guide us on that

[@r.i.4259]

Thank you very much for your tutorials !!

[@LeilaGharani]

You're very welcome Rustam. Thanks for your support.

[@briant6164]

Hi Leila, thanks for this. What if we have different numbers of rows for each day (such as a line for each sale) and (here is the hard part) some days have zero rows. I can't figure out a way for days without a row to count as zero when the pivot table calculates the average.

[@benosborne413]

Hi Excellent videos. I have and learning so much. I have the dates but not the days. How can I add the days next to the dates in excell?

[@LeilaGharani]

You can use the DAY function to grab the day from the date. =DAY(A1) where A1 has a date.

[@benosborne413]

@@LeilaGharani Thanks. I see it when my week starts on a Sunday. How if Monday is my first week day

[@norulzanamohamedsamuri1364]

thanks. great help. nice tutorial

[@sulaimansait864]

Super mam you are explain so more update video for the excel sheet I small douit mam you can explain daily for the payroll excel sheet

[@lathikapreethi9276]

Leila, your lessons are amazing, simple and to the point!love it! One thing that I want to bring to your notice is that you have given a link to access and download the workbook you use in the course. The link really doesn't download it and I cannot find it on my PC as well. Can you pls check on that?

[@LeilaGharani]

The link will bring you to the blog post. When you scroll down to the bottom of the post you'll find the workbook to download.

[@BayuHendra-qe7kg]

Excel is opened, Barbara, thanks for my solution

[@jubileelifeinsurance5991]

ma'm you have very wonderful knowledge.

[@LeilaGharani]

Thank you for your support Sohail. I'm still learning all the time :)

[@adighose]

Excellent video Leila

[@ckokse]

Yet another great video! Thank You!

[@Ardhyatripathi9]

Very Nice Video... Thank you Leila

[@LeilaGharani]

Welcome 😊

[@ravibopara3559]

Firstly, many thanks to your tutorials on KZbin and on your website. Those helped me to boot my productivity levels in using Excel. Here is my requirement: 1. I want to create a excel like interface with rows and columns in SharePoint with borders as my team members are familiar with excel. 2. When adding a new item in list, most of the columns need to be updated from auto-populated list for each column. 3. This list of options for each column will change on weekly basis and that is captured in an excel workbook which I want to connect to this SharePoint list. If this can be achieved, please guide me. If this requirement can be achieved with other set of office apps in a better way, please suggest.

[@saidhanafi5174]

شكرا ميس ليلى

[@rankingacademy]

awesome and so clear

[@LeilaGharani]

Thank you.

[@1gopalakrishnarao]

very very informative.Thank you, doing a great job in Excel.

[@LeilaGharani]

Great! You're welcome Gopala.

[@adlaialmeida9815]

Hi Leila , please can you advise why in a data table you cannot combine and index match ?

[@douglaszulu6281]

Great video on dashboards

[@LeilaGharani]

Thanks Douglas.

[@Tanushree00099]

Hi Liela, For Excel 2010 ,Just found out that to get Slicer for the Months - we can add a column containing the month name.TEXT(A2,"MMMM"). Then we do not have to go through the process of grouping as the Pivot Table field does not reflect the Month option like it is for your excel. Further the Slicer setting does not have the option of "Hide blank data".

[@hongqirong9927]

Hi, alternatively, one can after selecting "Date" in the PivotTable fields at video 06:25 right click on the newly created date, select the line after the day, i.e Select 6-Mar or 13-Mar or 20-Mar which is found within the Sunday group. So I repeat, right click on any one date, Select Group, Select Starting date 9/2/2016 and ENding at 8/8/2016 (This is automatically selected - depending on the dates you have in your data, it is on auto), Select next "By Months" and "By Days". And we can proceed to add slicer as per in the video 07:30 . Thanks.

[@FarhanKhan-hu2er]

Excel is Magic...

[@LeilaGharani]

So true :)

[@tall_bradda224]

your videos are so helpful thanks

[@LeilaGharani]

Very happy to hear that Chris :)

[@hassanmburia8825]

BE BLESSED

[@technicalafghan-8564]

brilliant job thanks i am your previous subscriber and i also subscribe on this channel because your video give me many thinks . thanks

[@LeilaGharani]

It's great to have you here.

[@TsiriniainaRakotonirina]

Dear Leila, Thank you for your much appreciated training. I purchased all your 07 courses and finished the Basic Excel. I'm on the *Advanced Excel: Top Excel Tips & Formulas* now. I am following step by step this *17. Tip 10- PivotTables: Calculated Fields, Slicers & Helpful Tricks* and on the video *17:56*: ---> I try to Center the 2016 and 2015 across the Selection. And the Headings below as well. It definitely works. ===> *Unfortunately, when I update the filters, the formatting are gone every time.* I kept the *Analyze>>Options>>"Layout Format" Preserve Cell formatting on update" Ticked* but still nothing. May you help me on this please?

[@remcovankempen422]

Again a perfect explanation !!

[@CKBREEZY7]

Have you got a in-depth video just on pivot tables?

[@bernadettedelacruz154]

Is it possible to apply the slicer too on the data table? Column a to c?

[@asepchannel1735]

great explanation. easy to learn